Sap Automation process


Ho to add sequence in the document column where the get text tool moves to second position after it has done with the first one.

@atharva.jadhav

Welcome to the community

Can you please elaborate a little

Cheers

My task is to pick a document no from VF04 and then paste it in VF01 and create the bill. After creating bill I want to again pick the document no from VF04 and continue the same process until that list gets completed

Hi @atharva.jadhav

Best possible way i can think of is

  1. Get all the data from VF04 using the table extraction you will get the data in datatable variable.

  2. Go to VF01 & You can iterate over the datatable using that you got from VF04 & process document one by one till the all the documents gets completed. You will use for each row in datatable for iteration.

Hope this helps :slight_smile:

i extracted the VF04 data into data table variable and now i am using the for each row in data table. Now i am using for each row but what should i add in the body

Hi @atharva.jadhav

Now you can assign the column values that you will get From VF04 datatable to variables or use directly while doing entries in the VF01

CurrentRow.Item("YourColumnName").ToString

Now you don’t have to switch from VF04 to VF01 as you already have all the values in Datatable variable. You can use type into activity to do the entries.

Hope this helps :slight_smile: