Data from multiple tables to one table
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.
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.