Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data from multiple tables to one table

HI Friends,

I have 4 internal tables,

it_vbak - data from VBAK

it_vbap - data from VBAP

it_vbpa _ data from VBPA

the data i got into the above tables is using vbeln as my select options.

I need to move all the data from the above internal table to one internal table it_vbak_vbap_vbpa.

with a unique key,

in the above case the unique key i am using is VBELN.

Any help on this will be appericiated.

Bye,

Shejal.

Tags:
replied

Hi,

Use a join and select directly into one internal table if possible.

Else you will have to loop at each table individually using a nested loop and move the data to the common internal table.

Cheers

VJ

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question