loop through column before after document

veronicahernand — Mon, 20 Dec 2021 21:08:46 GMT

Hi,

I need to design a loop and I need help.

I have two tables:

table1

table 2

So, field1 is the claim id and field2 is the returning order id (viqmel in sap).

In the beginning, field3 is the returning order id (the previous document) and field 4 is the following document.

Then, I have to look for the following document of field4, again in table2 (vbfa in sap), so:

At the end I need two tables:

table 1(remains the same)

and table 3

Re: loop through column before after document

veronicahernand — Fri, 15 Jan 2021 10:31:34 GMT

sorry, table 3 would be like this:

I would need all the docs related to that returning order id.

Thanks in advance!!!!