topic Re: solution 1 in Application Development and Automation Discussions

solution 1

Former Member — Thu, 10 Aug 2006 17:21:58 GMT

Guy's

i have asked these question in forum before,and

found soultion which i found to be temporary fix.kindly

find the issue below.

Scenario1

Table 😆 t_sdmat

fields 😆 matnr werks labst3 mvgr1 mvgr2

value 😆 53621 c01 cv

53621

Table 😆 t_lmw

fields 😆 matnr werks labst3

value 😆 53621 2001 20

53621 2002 30

final output required

Table 😆 t_sdmat

fields 😆 matnr werks labst3 mvgr1 mvgr2

value 😆 53621 2001 20 co1 cv

53621 2002 30

Sceanrio2

Table 😆 t_sdmat

fields 😆 matnr werks labst3 mvgr1 mvgr2

value 😆 53621 co1 cv

Table 😆 t_lmw

fields 😆 matnr werks labst3

value 😆 53621 2001 20

53621 2002 30

final output required

Table 😆 t_sdmat

fields 😆 matnr werks labst3 mvgr1 mvgr2

value 😆 53621 2001 20 c01 cv

53621 2002 30 c01 cv

i have tried following two option

but that didn't worked for both the scearion

option1

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.

<fs>-matnr = <fs_lmw>-matnr.

<fs>-werks = <fs_lmw>-werks.

<fs>-labst3 = <fs_lmw>-labst3.

DELETE t_lmw INDEX w_tabix.

ENDIF.

ENDLOOP.

delete t_sdmat where werks is initial.

option2

loop at t_lmw.

clear: t_sdmat.

read table t_sdmat with key matnr = t_lmw-matnr.

if sy-subrc eq 0.

w_tabix = sy-tabix.

t_sdmat-matnr = t_lmw-matnr.

t_sdmat-werks = t_lmw-werks.

t_sdmat-labst3 = t_lmw-labst3.

collect t_sdmat.

endif.

endloop.

delete t_sdmat where werks is initial.

Re: solution 1

Former Member — Thu, 10 Aug 2006 17:52:43 GMT

Hi,

Confirm the following data. As I am clear the internal table values.

Scenario1

Table 😆 t_sdmat

fields 😆

matnr werks labst3 mvgr1 mvgr2

53621 c01 cv

53621

Final output

Table 😆 t_sdmat

matnr werks labst3 mvgr1 mvgr2

53621 2001 20 co1 cv

53621 2002 30

Scenario2

Table 😆 t_sdmat

matnr werks labst3 mvgr1 mvgr2

53621 co1 cv

Final output

Table 😆 t_sdmat

matnr werks labst3 mvgr1 mvgr2

53621 2001 20 c01 cv

53621 2002 30 c01 cv

Thanks,

Naren

Message was edited by: Narendran Muthukumaran

Re: solution 1

Former Member — Thu, 10 Aug 2006 18:11:15 GMT

Hi,

Try the following code. I think this might work if the material number is unique in the internal table t_sdmat.

Create an internal table t_temp with the structure similar to t_sdmat.

loop at t_lmw.

v_tabix = sy-tabix.

read table t_sdmat index v_tabix.

if sy-subrc = 0.

move-corresponding t_sdmat to t_temp.

move-corresponding t_lmw to t_temp.

append t_temp.

else.

read table t_sdmat with key matnr = t_lmw-matnr.

if sy-subrc = 0.

move-corresponding t_sdmat to t_temp.

move-corresponding t_lmw to t_temp.

append t_temp.

endif.

endloop.

Thanks,

Naren

Message was edited by: Narendran Muthukumaran

Re: solution 1

Former Member — Thu, 10 Aug 2006 19:09:02 GMT

Sceanrio2

Table 😆 t_sdmat

fields 😆 matnr werks labst3 mvgr1 mvgr2

value 😆 53621 co1 cv

Table 😆 t_lmw

fields 😆 matnr werks labst3

value 😆 53621 2001 20

53621 2002 30

final output required

Table 😆 t_sdmat

fields 😆 matnr werks labst3 mvgr1 mvgr2

value 😆 53621 2001 20 c01 cv

53621 2002 30 c01 cv

Solution --

Loop at t_sdmat.

clear t_lmw.

loop at t_lmw where matnr = t_sdmat-matnr.

move t_lmw-werks to t_sdmat-werks.

move t_lmw-labst3 to t_sdmat-labst3.

modify t_sdmat.

endloop.

Re: solution 1

Former Member — Thu, 10 Aug 2006 19:13:59 GMT

Scenario1

Table 😆 t_sdmat

fields 😆

matnr werks labst3 mvgr1 mvgr2

53621 c01 cv

53621

Final output

Table 😆 t_sdmat

matnr werks labst3 mvgr1 mvgr2

53621 2001 20 co1 cv

53621 2002 30

Solution --

loop at t_sdmat.

loop at t_lmw where matnr = t_sdmat-matnr.

move t_lmw-werks to t_sdmat-werks.

move t_lmw-labst3 to t_sdmat-labst3.

modify t_sdmat.

delete t_lmw.

exit.

endloop.