topic Re: moving 2 itabs data into Final table in Application Development and Automation Discussions

moving 2 itabs data into Final table

Former Member — Tue, 26 Aug 2008 06:55:12 GMT

Hi all,

I have ITAB1 with fields LIFNR, KTOKK, NAME1, LAND1.

ITAB2 WITH FIELDS LIFNR, AKONT, ZTERM.

I WANT TO MOVE ALL THE FIELDS INTO ONE FINAL TABLE.

i.e ITAB will have LIFNR, KTOKK, NMAE1, LAND, AKONT, ZTERM.

HOW TO DO THIS ?

Thanks

Krupali

Re: moving 2 itabs data into Final table

bpawanchand — Tue, 26 Aug 2008 06:56:35 GMT

Use MOVE-CORRESPONDING staement

regards

Pavan

Re: moving 2 itabs data into Final table

Former Member — Tue, 26 Aug 2008 06:57:08 GMT

Can you not even try. Is it to difficult.

This sort of question has been asked before. Try searching for answers before asking such a simple question.

Re: moving 2 itabs data into Final table

JozsefSzikszai — Tue, 26 Aug 2008 06:57:32 GMT

hi KR,

roughly:

LOOP AT itab1.
==> move fields of itab1 into itab_final
READ TABLE itab2 INTO ... WITH KEY lifnr = itab1-lifnr.
==> move fields of itab2 into itab_final.
APPEND itab_final.
ENDLOOP.

hope this helps

Re: moving 2 itabs data into Final table

Former Member — Tue, 26 Aug 2008 06:59:39 GMT

Hi ...

ITAB[] = ITAB1[]

Loop at ITAB2.

Read table ITAB with key field lifnr transport ......

IF subrc = 0.

move fields of ITAB2 to Itab.

Modify ITAB transport ......

ENDif.

ENDLOOP.

Thanks,

Gaurav.

Re: moving 2 itabs data into Final table

former_member386202 — Tue, 26 Aug 2008 06:59:44 GMT

Hi,

Refer Below code.

LOOP AT it_bsis INTO wa_bsis.

lv_index = sy-tabix.

CLEAR : wa_ekpo.

READ TABLE it_ekpo INTO wa_ekpo WITH KEY ebeln = wa_bsis-ebeln

ebelp = wa_bsis-ebelp

BINARY SEARCH.

IF sy-subrc EQ 0.

wa_bsis-txz01 = wa_ekpo-txz01.

ENDIF.

CLEAR : wa_ekbe.

READ TABLE it_ekbe INTO wa_ekbe WITH KEY ebeln = wa_bsis-ebeln

ebelp = wa_bsis-ebelp

belnr = wa_bsis-mblnr1

BINARY SEARCH.

IF sy-subrc EQ 0.

wa_bsis-menge = wa_ekbe-menge.

ENDIF.

MODIFY it_bsis FROM wa_bsis INDEX lv_index

TRANSPORTING txz01 menge.

CLEAR : wa_bsis,

wa_ekpo.

ENDLOOP.

ENDIF.

Regards,

Prashant

Re: moving 2 itabs data into Final table

Former Member — Tue, 26 Aug 2008 07:01:12 GMT

hiii

you can do it if same structure is there in your final internal table use like below first line then if you want to take data based on condition then use with READ statement.

i_output = i_marc.

  IF i_marc[] IS NOT INITIAL.

    SELECT matnr                       " Material Number
           werks                       " Plants
           lgort                       " Storage Location
      FROM mard
      INTO TABLE i_mard
       FOR ALL ENTRIES IN i_marc
     WHERE matnr EQ i_marc-matnr
       AND werks EQ i_marc-werks
       AND lgort IN s_lgort.

  ENDIF.                               " IF i_mara[] IS NOT INITIAL


  IF sy-subrc EQ 0.
    LOOP AT i_output INTO wa_output.
      READ TABLE i_mard INTO wa_mard WITH KEY matnr = wa_output-matnr.
      wa_output-lgort = wa_mard-lgort.
      MODIFY i_output FROM wa_output.
      CLEAR wa_output.
    ENDLOOP.                           " LOOP AT i_output
  ENDIF.                               " IF sy-subrc EQ 0

regards

twinkal

Re: moving 2 itabs data into Final table

Former Member — Tue, 26 Aug 2008 07:03:24 GMT

Hi,

Sort both the internal tables by lifnr.

1. For moving matching records only.

loop at itab1.

loop at itab2 with key lifnr eq itab1-lifnr.

endloop.

2. To move all records irrespective of the LIFNR value.

i_final[] = itab1[].

append i_final.

loop at itab2.

append i_final.

endloop.

Thanks,

Anita

Re: moving 2 itabs data into Final table

Former Member — Tue, 26 Aug 2008 07:03:31 GMT

sort itab1 by lifnr.

sort itab2 by lifnr.

loop at itab1.

read table itab2 with key lifnr = itab1-lifnr binarysearch.

if sy-subrc = 0.

move-correponding itab to itab.

endif.

move-corresponding itab1 to itab.

append itab.

endloop.

Regards

Murali Papana

Re: moving 2 itabs data into Final table

Former Member — Tue, 26 Aug 2008 07:03:44 GMT

Hi,

loop at itab1.

read table itab2 with key lifnr = itab1-lifnr.

itab-LIFNR = itab1-lifnr.

itab- KTOKK = itab1-ktokk.

itab-NMAE1 = itab1-name1.

itab-LAND = itab1-land1.

itab-AKONT = itab2-akont.

itab-ZTERM = itab2-zterm.

append itab.

endloop.

if itab2 contains one record for multiple records in itab1 do above else loop it on either way

Regaurds,

sree.

Re: moving 2 itabs data into Final table

Former Member — Tue, 26 Aug 2008 07:05:12 GMT

Hi,

loop at itab1.

read table itab2 with key lifnr = itab1-lifnr.

itab-LIFNR = itab1-lifnr.

itab- KTOKK = itab1-ktokk.

itab-NMAE1 = itab1-name1.

itab-LAND = itab1-land1.

itab-AKONT = itab2-akont.

itab-ZTERM = itab2-zterm.

append itab.

endloop.

if itab2 contains one record for multiple records in itab1 do above else loop it on either way

Regaurds,

sree.

Re: moving 2 itabs data into Final table

Former Member — Tue, 26 Aug 2008 07:08:14 GMT

Hello,

you have a common field LIFNR in both the table itab1 and itab2 based on the join get the data in a structure and use move corresponding in the main itab table.

Thanks and Regards,

Gunjan

Re: moving 2 itabs data into Final table

Former Member — Tue, 26 Aug 2008 07:15:28 GMT

Try it like this:

Loop at ITAB1 into WA1.
  Loop at ITAB2 into WA2 where LIFNR EQ WA1-LIFNR.

     WA3-LIFNR   = WA1-LIFNR.
     WA3-KTOKK = WA1-KTOKK. 
     WA3-NMAE1 = WA1-NMAE1.
     WA3-LAND1  = WA1-LAND1.
     WA3-AKONT = WA2-AKONT.
     WA3-ZTERM = WA2-ZTERM.

   Append WA3 to ITAB3.

  Endloop.
Endloop.

With luck,

Pritam.

Re: moving 2 itabs data into Final table

Subhankar — Tue, 26 Aug 2008 07:17:31 GMT

Hi...

Please try in this way

Loop at i_TAB1 into wa_ITAB1.

read table i_tab2 into wa_ITAB2 with key lifnr = wa_itab1-lifnr.

if sy-subrc = 0.

populate final work area using wa_itab1 and wa_itab2.

append it to final table.

endif.

endloop.