topic Re: joining two internal table in Application Development and Automation Discussions

joining two internal table

Former Member — Sun, 10 Feb 2008 09:19:56 GMT

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.

Re: joining two internal table

Former Member — Sun, 10 Feb 2008 15:04:19 GMT

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.

Re: joining two internal table

Former Member — Tue, 12 Feb 2008 04:51:05 GMT

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