I have a excel table with 4 columns and I have a SAP table with 3 columns(first 3 columns are same in Excel and SAP), now I need to copy the 4th column from excel and replace that value in the 3rd column in SAP by matching country and ID. If the quantity is 0 then I have to enter new row in SAP. Can…

Hi @antoromeo18 , First of all, you must have Scripting enabled in SAP to have the best automation experience. I would advice to use the UI explorer and take a look at the Selector in SAP [quality, ID 1] and see if it has some form of coordinates. like column 3, row 2 or [3,2] etc. create a custom …

SAP table update using Uipath

Help Studio

LevKushnir (Lev Kushnir) June 4, 2020, 4:06pm 3

HI @antoromeo18

Please go to the SAP Academy course, where I am explaining how to transfer the data from Excel to SAP. This will solve all your troubles

Completely new SAP Academy course , to help you to learn the automation techniques and the best practices for SAP WinGUI automation

Best regards, Lev

Need a SAP-UiPath Solution

Topic		Replies	Views
Copy excel data table and paste into SAP datatable Studio datatable , excel , uiautomation , sap , orchestrator , robot , activities , studio , studiox , question , activities_panel	6	2859	December 28, 2021
Copying column from Excel to SAP Studio studio , question , activities_panel	9	2786	February 28, 2022
How can I compare item SAP and Excel by selected some item inline (SAP) for an update? StudioX excel , studiox , question	5	1856	February 5, 2021
Copy a Range form excel to SAP Studio studio , question , activities_panel	7	1223	November 15, 2022
Uploading data into SAP Activities datatable , excel , uiautomation , sap , activities , question , data_manipulation	17	2937	September 19, 2021

Most Active Users - Yesterday
ashokkarale
sonaliaggarwal47
anjasing
mkankatala
Anil_G
manasrlenka25
A_Learner
SorenB
balaraman.ramiya
sharazkm32
More details...

SAP table update using Uipath

Related topics