LOOPING PROBLEM

[Former Member]

i need to make the two internal tables into one internal table and i need to use at new on tknum and at end on anzpk,btgew,volum plz help me out in this.

IF i_vttk[] IS NOT INITIAL.

LOOP AT i_vttk INTO wa_vttk.

READ TABLE i_vttp INTO wa_vttp WITH KEY tknum = wa_vttk-tknum.

IF sy-subrc = 0.

MOVE: wa_vttk-tknum TO wa_temp_final-tknum,

wa_vttk-datbg TO wa_temp_final-datbg,

wa_vttk-tplst TO wa_temp_final-tplst,

wa_vttk-route TO wa_temp_final-route,

wa_vttk-tdlnr TO wa_temp_final-tdlnr,

wa_vttk-shtyp TO wa_temp_final-shtyp,

wa_vttk-vsart TO wa_temp_final-vsart,

wa_vttp-vbeln TO wa_temp_final-vbeln.

APPEND wa_temp_final TO i_temp_final.

ENDIF.

ENDLOOP.

LOOP AT i_likp INTO wa_likp.

READ TABLE i_kna1 INTO wa_kna1 WITH KEY kunnr = wa_likp-kunnr.

IF sy-subrc = 0.

MOVE: wa_kna1-name1 TO wa_temp_final1-name1,

wa_likp-vbeln TO wa_temp_final1-vbeln,

wa_likp-kunnr TO wa_temp_final1-kunnr,

wa_likp-anzpk TO wa_temp_final1-anzpk,

wa_likp-btgew TO wa_temp_final1-btgew,

wa_likp-gewei TO wa_temp_final1-gewei,

wa_likp-volum TO wa_temp_final1-volum,

wa_likp-voleh TO wa_temp_final1-voleh.

APPEND wa_temp_final1 TO i_temp_final1.

ENDIF.

ENDLOOP.

ENDIF.

[Former Member]

put all the required fields in final internal table.

loop at itab_final into wa_final.

read table i_vttk INTO wa_vttk with key tknum = wa_fianl-tknum.

if sy-subrc = 0.

MOVE: wa_vttk-tknum TO wa_temp_final-tknum,

wa_vttk-datbg TO wa_temp_final-datbg,

wa_vttk-tplst TO wa_temp_final-tplst,

wa_vttk-route TO wa_temp_final-route,

wa_vttk-tdlnr TO wa_temp_final-tdlnr,

wa_vttk-shtyp TO wa_temp_final-shtyp,

wa_vttk-vsart TO wa_temp_final-vsart,

wa_vttp-vbeln TO wa_temp_final-vbeln.

APPEND wa_temp_final TO i_temp_final.

ENDIF.

read table i_kna1 INTO wa_kna1 WITH KEY kunnr = wa_likp-kunnr.

if sy-subrc = 0.

MOVE: wa_kna1-name1 TO wa_temp_final1-name1,

wa_likp-vbeln TO wa_temp_final1-vbeln,

wa_likp-kunnr TO wa_temp_final1-kunnr,

wa_likp-anzpk TO wa_temp_final1-anzpk,

wa_likp-btgew TO wa_temp_final1-btgew,

wa_likp-gewei TO wa_temp_final1-gewei,

wa_likp-volum TO wa_temp_final1-volum,

wa_likp-voleh TO wa_temp_final1-voleh.

APPEND wa_temp_final1 TO i_temp_final1.

ENDIF.

endloop.

[Former Member]

put all the required fields in final internal table.

loop at itab_final into wa_final.

read table i_vttk INTO wa_vttk with key tknum = wa_fianl-tknum.

if sy-subrc = 0.

MOVE: wa_vttk-tknum TO wa_temp_final-tknum,

wa_vttk-datbg TO wa_temp_final-datbg,

wa_vttk-tplst TO wa_temp_final-tplst,

wa_vttk-route TO wa_temp_final-route,

wa_vttk-tdlnr TO wa_temp_final-tdlnr,

wa_vttk-shtyp TO wa_temp_final-shtyp,

wa_vttk-vsart TO wa_temp_final-vsart,

wa_vttp-vbeln TO wa_temp_final-vbeln.

APPEND wa_temp_final TO i_temp_final.

ENDIF.

read table i_kna1 INTO wa_kna1 WITH KEY kunnr = wa_likp-kunnr.

if sy-subrc = 0.

MOVE : wa_kna1-name1 TO wa_temp_final-name1,

wa_likp-vbeln TO wa_temp_final-vbeln,

wa_likp-kunnr TO wa_temp_final-kunnr,

wa_likp-anzpk TO wa_temp_final-anzpk,

wa_likp-btgew TO wa_temp_final-btgew,

wa_likp-gewei TO wa_temp_final-gewei,

wa_likp-volum TO wa_temp_final-volum,

wa_likp-voleh TO wa_temp_final-voleh.

APPEND wa_temp_final TO i_temp_final.

ENDIF.

endloop.

if u r convinced with the answer please reward with points

[Former Member]

Hi Gupta

if u want to make two internal tables into one internal table then at the end of the program u CAN USE THESE COMMANDS

MODIFY itab [FROM wa] [INDEX idx] [ASSIGNING <fs>|REFERENCE INTO dref] [TRANSPORTING f1 ... fn].

or collect statement

Reward if helpfull

Regards

Pavan

[Former Member]

Hi,

Even i am not sure what you want, if i were you, i try to use 'SELECT'.

in your program, i can't find the Key to merge tables.

If the Key exist, I recommand you to "SELECT cluse".

<i><b>LEFT INNER JOIN or OUTER JOIN</b></i>

Regards,

SY Kim

What i mean is, when you select data first time from tables not internal table, you can use what i say above.

Message was edited by:

Se Young Kim

Message was edited by:

Se Young Kim