Copy a Range form excel to SAP

Help Studio
, ,
1

Good day & Hello,
kindly help me how to copy a range (B2:AE4) but i need to paste it into SAP row by row (B2:AE2) next (B3:AE3)…, i never do this kind activity before, thank you.

Alva

2

@digital_labs

Read the range(B2:AE4)and inside for each row in the data table activity pass the current row as the input to the SAP field.
Share the screen of the Field in which you need to give input.

3

Capture
Capture1503×507 107 KB

thank you.

4

@digital_labs
The sample structure to automate this scenario.

image
image842×701 20.1 KB

Selectors need to be dynamic for each iteration and implement a counter if necessary.
Use the counter inside the selector to achieve the result for each iteration.
image
image667×547 13.4 KB

Add more type into activity to enter other columns in the row.

5

Dear Sangeetha,
using type into was not recommended since total columns are 30 columns.
what i try to solve is how to copy range B2:AE2 and click on the SAP column and pasted the range, and do that for another PO for the next row, thank you.

6

@digital_labs

Check if this approach works

7

HI @digital_labs

Check out this thread

Hope it will helps

Regards
Gokul

1 Like
8

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