joining two internal table

[Former Member]

Hi expert,

I'm using 'Reuse_Alv_Hierseq_List_Display' and i wanted to joing the header data(vbak & kna1) and item data (vbap & vbep) seperately.So that i could assign this internal table name in the about funtion module parameters(I_OUTTAB_HEADER & I_OUTTAB_ITEM).Plz help me out!

Regards,

Arshad.

[Former Member]

hi

first join vbak ,kan1 tables into table iheader.

then join vbap,vbep tables into table iitem .

then pass iheader to i_outtab_header and iitem to i_outtab_item.

[Former Member]

Using I Joins decreses the performance.

U can use FOR ALL ENTRIES instead.

1st fetch required data from VBAK

Then fetch data from KNA! for all entries of VBAK

2ndt fetch required data from VBAP

Then fetch data from VBEP for all entries of VBAP

Reward if useful