cancel
Showing results for 
Search instead for 
Did you mean: 

Copy Data from excel and Paste in SAP and copy status from SAP and paste in Excel

AsitabhaDeb
Level 6
Hi Experts,

My requirement is there is excel with list of Sales Order No.
Now Bot will copy single SO#, enter into SAP , go to line item details, go to SOLI user status , copy data from there and paste in excel ( Next column of Sales Order). Next time BOT will do same activity. There are 50 SO# in the excel and its changing every day.
Will it be possible . If Yes. How.??

In SO status section there are multiple status of the SO day wise. 
Any one can give me solution.??






------------------------------
Asitabha Deb
------------------------------
3 REPLIES 3

Hi Asitabha 

Do you mean 2nd day more 50 row data get added under first 50 row ?

Thanks

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------
Nilesh Jadhav.
Consultant
ADP,India

Hi Nilesh,

No no. Sorry for confusion.

Next day new excel file will generate with might have less no of SO. 
Don't mixed up with next day data.
I only need solution of single days data.

Thank you.



------------------------------
Asitabha Deb
------------------------------

HI Asitabha

Use work Queues and each time  and tag the status, and pull the data whenever it is required so that it will generate day wise.

------------------------------
VamshiKrihsna Dasa
System Architect
Fujitsu India Consulting Pvt. Ltd.
------------------------------
VamshiKrihsna Dasa System Architect Fujitsu India Consulting Pvt. Ltd.