solution

[Former Member]

Guy's i need solution for

following problem, i have two internal table t_sdmat

and t_lmw

Table:->t_sdmat

fields:->matnr werks labst3

value:-> 53621

53621

Table:->t_lmw

fields:->matnr werks labst3

value:-> 53621 2001 20

53621 2002 30

final output requried

Table:->t_sdmat

fields:->matnr werks labst3

value:-> 53621 2001 20

53621 2002 30

[Former Member]

loop at t_sdmat.

loop at t_lmw where matnr = t_sdmat-matnr.

write : / t_lmw-matnr, t_lmw-werks, t_lmw-labst3.

endloop.

endloop.

Surely, if you wish to save it in t_sdmat table than you can initialise the particular values in t_sdmat and modify the table.

Regards

Anurag

Message was edited by: Anurag Bankley

Message was edited by: Anurag Bankley

[suresh_datti]

if its just that try

t_sdmat[] = t_lmw[].

~Suresh

[guillaume-hrc]

Hi,

Something like that should solve the problem:

DATA: w_tabix  TYPE sy-tabix.
FIELD-SYMBOLS: <fs>      LIKE lINE OF t_sdmat,
               <fs_lmw>  LIKE LINE OF t_lmw.

LOOP AT t_sdmat ASSIGNING <fs>.
  READ TABLE t_lmw ASSIGNING <fs_lmw> WITH KEY matnr = <fs>-matnr.
  IF sy-subrc = 0.
    w_tabix = sy-tabix.
    MOVE-CORRESPONDING <fs_lmw> TO <fs>.
  
    DELETE t_lmw INDEX w_tabix.
  ENDIF.
ENDLOOP.

Best regards,

Guillaume

[Former Member]

Hi Guillaume

You got the point,that what i was looking for

[Former Member]

Refresh t_sdmat.

t_sdmat[] = t_lmw[].

Regards,

Ravi

[Former Member]

Hi,

simple

<b>append lines of t_lmw to t_sdmat.</b>

Regards

vijay

[Former Member]

Check if the below code helps you.

*** Assumption Final Output should exist basing on 
***   materials from t_sdmat
delete adjacent duplicates from: t_sdmat.
loop at t_lmw.
     clear: t_sdmat.
     read table t_sdmat with key matnr = t_lmw-matnr.
     if sy-subrc eq 0.
        move-corresponding t_lmw to t_sdmat.
        collect t_sdmat.
     endif.
endloop.
delete t_sdmat where werks is initial.

[Former Member]

Hi Sanju

The solution sample code could be like this:---

refresh t_sdmat.

t_sdmat[] = t_lmw[].

regards,

varun sanghi