loop through column before after document

[veronicahernand]

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

[veronicahernand]

sorry, table 3 would be like this:

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

Thanks in advance!!!!