How to paste Datatable column values in SAP all at once

Help
1

Hi All,

I have Data table values from that i need to paste billing document values in sap. All the values at a time how to paste it.Can some one please help me on this

Untitled
Untitled1366Ă—768 49.1 KB

2

Hi @thima

are you able to use type into and have you enabled GUI SAP editing option

Thanks
Ashwin S

3

Yes i have enabled GUI SAP option

4

Hi @thima,

Please use a For Each Row activity (Data Table) to go through a loop. And now use a Type Into activity selecting the 1st cell of that particular column and then use down option in a Send Hot Key activity.

Hope you will find your solution.

Thanks & Regards,
Apurba

5

But i have huge data 50000 records,is there any other possible solution?

6

Hi @thima,

If only entering data into your mentioned field is permissible in SAP then, the solution will work for any number of data.

Thanks & Regards,
Apurba

7

HI @thima

I would suggest to use this SAP functionality

image
image742Ă—236 8.25 KB

So it means in the first step, you will copy&paste all data from Excel or from original file into Clipboard, than go to SAP and use the button “Upload from Clipboard”. This will insert all 50000 entries at once in SAP just in a second.

Try it out and let me know if it helps

Best regards, Lev

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.