Hi,
I want to merge 3 internal tables and place respective records in their rows.
my output should be
Nr Amt1 Amt2 Amt3 01 10.00 02 345.00 212.00 03 67.00 30.00 230.00 04 34.00 05 120.00 100.00 07 40.00
REPORT x.
TYPES: BEGIN OF t_itab,
num(2) TYPE c,
amount(18) TYPE c,
END OF t_itab.
TYPES: BEGIN OF t_final,
num(2) TYPE c,
amount1(18) TYPE c,
amount2(18) TYPE c,
amount3(18) TYPE c,
END OF t_final.
DATA: itab1 TYPE STANDARD TABLE OF t_itab.
DATA: itab2 TYPE STANDARD TABLE OF t_itab.
DATA: itab3 TYPE STANDARD TABLE OF t_itab.
DATA: it_final TYPE STANDARD TABLE OF t_final.
DATA: wa1 TYPE t_itab.
DATA: wa2 TYPE t_itab.
DATA: wa3 TYPE t_itab.
DATA: wa_final TYPE t_final.
wa1-num = 01.
wa1-amount = '10.00'.
APPEND wa1 TO itab1.
wa1-num = 02.
wa1-amount = '345.00'.
APPEND wa1 TO itab1.
wa1-num = 03.
wa1-amount = '67.00'.
APPEND wa1 TO itab1.
wa1-num = 04.
wa1-amount = '34.00'.
APPEND wa1 TO itab1.
****************************
wa2-num = 05.
wa2-amount = '120.00'.
APPEND wa2 TO itab2.
wa2-num = 03.
wa2-amount = '30.00'.
APPEND wa2 TO itab2.
wa2-num = 07.
wa2-amount = '40.00'.
APPEND wa2 TO itab2.
******************************
wa3-num = 02.
wa3-amount = '212.00'.
APPEND wa3 TO itab3.
wa3-num = 03.
wa3-amount = '230.00'.
APPEND wa3 TO itab3.
wa3-num = 05.
wa3-amount = '100.00'.
APPEND wa3 TO itab3.
LOOP AT itab1 INTO wa1.
MOVE wa1-amount TO wa_final-amount1.
move wa1-num to wa_final-num.
APPEND wa_final TO it_final.
ENDLOOP.
loop at it_final into wa_final.
write:/ wa_final-num , 20 wa_final-amount1 , 40 wa_final-amount2 , 60 wa_final-amount3.
endloop.
How do you proceed?
Rgds
Vara