topic Re: Join Internal Tables in Application Development and Automation Discussions

Join Internal Tables

anuradha_wijesinghe — Sun, 16 Feb 2014 03:30:39 GMT

I have ITAB like itab1 and itab2 ad bellow. I need to join that itabs as I have shown in bellow. Please let me know easy way for going that.

ITAB1
SO	LI	FIED1	FIELD2	PO
SO1	LI1	F11	F21
SO2	LI2	F12	F22
SO3	LI3	F13	F23

ITAB2
SO	LI	PO
SO1	LI1	PO11
SO1	LI1	PO12
SO1	LI1	PO13
SO2	LI2	PO21
SO2	LI2	PO22
SO3	LI3	PO31
SO3	LI3	PO32
SO3	LI3	PO33

With join these table O need to get bellow table. Please tel me a method to do that please.

ITAB_FINAL
SO	LI	FIED1	PO	FIELD2
SO1	LI1	F11	PO11	F21
SO1	LI1	F11	PO12	F21
SO1	LI1	F11	PO13	F21
SO2	LI2	F12	PO21	F22
SO2	LI2	F12	PO22	F22
SO3	LI3	F13	PO31	F23
SO3	LI3	F13	PO32	F23
SO3	LI3	F13	PO33	F23

Re: Join Internal Tables

philipdavy — Sun, 16 Feb 2014 04:19:26 GMT

Hi Anuradha,

If I understood correctly,

You have the two internal tables ITAB1 and ITAB2 (already populated), loop through your second internal table and read the first internal table with key SO and LI.
Copy the required corresponding values from ITAB1 and ITAB2 into your final internal table.
Pseudo Code:

Loop at itab2 into wa_itab2.

Read itab1 into wa_itab1 with key SO = wa_itab2-SO and LI = wa_itab2-LI.

* Copy the values required to populate the final internal table.

if sy-subrc = 0.

wa_final-SO = wa_itab2-SO.

wa_final-LI = wa_itab2-LI.

wa_final-field1 = wa_itab1-field1.

wa_final-PO = wa_itab2-PO.

wa_final-field2 = wa_itab1-field2.

append wa_final to itab_final.

clear: wa_final.

endif

Endloop.

Regards,

Philip.

Re: Join Internal Tables

Former Member — Sun, 16 Feb 2014 05:22:21 GMT

Hi,

For the above requirement, loop the ITAB2 and then read the ITAB1 with key fields as SO and LI.

Assign the corresponding fields to the final internal table.

Below is the sample code,

loop at it_tab2 into wa_tab2.

read TABLE it_tab1 into wa_tab1 with KEY SO = wa_tab2-SO LI = wa_tab2-LI.

wa_final-SO = wa_tab2-SO.

wa_final-LI = wa_tab2-LI.

wa_final-FIELD1 = wa_tab1-field1.

wa_final-PO = wa_tab2-po.

wa_final-FIELD2 = wa_tab1-field2.

APPEND wa_final to it_final.

ENDLOOP.

Re: Join Internal Tables

Former Member — Sun, 16 Feb 2014 05:42:04 GMT

loop at itab2 into wa_itab2.
   READ TABLE itab1 into wa_itab1 with key so = wa_itab2-so li = wa_itab2-li.
   MOVE-CORRESPONDING wa_itab1 to wa_final.
   MOVE-CORRESPONDING wa_itab2 to wa_final.
   append wa_final to it_final.
endloop.