topic Re: solution in Application Development and Automation Discussions

solution

Former Member — Thu, 10 Aug 2006 12:28:40 GMT

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

Re: solution

Former Member — Thu, 10 Aug 2006 12:32:54 GMT

loop at t_sdmat.

loop at t_lmw where matnr = t_sdmat-matnr.

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

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

Re: solution

suresh_datti — Thu, 10 Aug 2006 12:33:22 GMT

if its just that try

t_sdmat[] = t_lmw[].

~Suresh

Re: solution

guillaume-hrc — Thu, 10 Aug 2006 12:33:52 GMT

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

Re: solution

Former Member — Thu, 10 Aug 2006 12:34:58 GMT

Refresh t_sdmat.

t_sdmat[] = t_lmw[].

Regards,

Ravi

Re: solution

Former Member — Thu, 10 Aug 2006 12:37:17 GMT

Hi,

simple

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

Regards

vijay

Re: solution

Former Member — Thu, 10 Aug 2006 12:39:34 GMT

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.

Re: solution

Former Member — Thu, 10 Aug 2006 12:41:41 GMT

Hi Sanju

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

refresh t_sdmat.

t_sdmat[] = t_lmw[].

regards,

varun sanghi

Re: solution

Former Member — Thu, 10 Aug 2006 12:57:06 GMT

Hi Guillaume

You got the point,that what i was looking for