topic Re: Problem with modify command.... in Application Development and Automation Discussions

Problem with modify command....

aarif_baig — Mon, 29 Jun 2009 05:43:38 GMT

Hi abapers,

loop at itab.

read table ifinal with key kunnr = itab-kunnr.

if sy-subrc = 0.

move: ifinal-dmbtr to itab-dmbtr.

modify itab index sy-tabix.

endif.

endloop.

Now the problem is that when i am using modify index sy-tabix it creating an additional entry

and when i am using only modify itab its working fine so wat could be the reason that modify index sy-tabix is

not working propertly.

Thanks

Re: Problem with modify command....

Former Member — Mon, 29 Jun 2009 05:47:45 GMT

Hi,

Try with the following code


Data: lv_index type sytabix.
loop at itab.
lv_index = sy-tabix.
read table ifinal with key kunnr = itab-kunnr.
if sy-subrc = 0.
move: ifinal-dmbtr to itab-dmbtr.
modify itab index lv_index .
endif.
endloop.

Regards,

Raju.

Re: Problem with modify command....

Former Member — Mon, 29 Jun 2009 05:48:18 GMT

Hi Arif,

try this..

loop at itab.

read table ifinal with key kunnr = itab-kunnr.

if sy-subrc = 0.

move: ifinal-dmbtr to itab-dmbtr.

modify itab transporting dmbtr.

endif.

endloop.

Re: Problem with modify command....

alex_m — Mon, 29 Jun 2009 05:50:34 GMT

Hi,

The problem with your code is the right sy-tabix not used.

Try out this.

loop at itab.

read table ifinal with key kunnr = itab-kunnr.

v_index = sy-tabix.

if sy-subrc = 0.

move: ifinal-dmbtr to itab-dmbtr.

modify itab index v_index.

endif.

endloop.

Re: Problem with modify command....

Former Member — Mon, 29 Jun 2009 05:50:39 GMT

Hi Aarif,

I am assuming there is one-to-one relationship between itab and ifinal.

Try using following code.

sort itab by kunnr.

sort ifinal by kunnr.

data: l_index like sy-tabix.

l_index = 1.

loop at itab.

loop at ifinal from l_index.

if ifinal-kunnr eq itab-kunnr.

move: ifinal-dmbtr to itab-dmbtr.

elseif ifinal-kunnr gt itab-kunnr.

move sy-tabix to l_index.

exit.

endif.

endloop.

modify itab transporting dmbtr.

endloop.

Regards,

Anil Salekar

Re: Problem with modify command....

aarif_baig — Mon, 29 Jun 2009 05:51:01 GMT

thanks all of u for ur quick response,

see actually i have already solved the problem,

the only thing that i wanted to know that why is this happening...

like any reason..

Re: Problem with modify command....

Former Member — Mon, 29 Jun 2009 05:51:33 GMT

assign sy-tabix value to one varaible and then use modify statement

regards,

Prajakta

Re: Problem with modify command....

Former Member — Mon, 29 Jun 2009 05:51:57 GMT

Hi,

Better to use TRANSPORTING addition also..

Re: Problem with modify command....

Former Member — Mon, 29 Jun 2009 05:53:20 GMT

Hi Aarif,

When you read the internal table your SY_TABIX changes and it takes the SY_TABIX of internal table(READ) and not the Loop one.

So, by assigning SY-tabix to lv_tabix after the Loop, solves your problem.

Hope this resolves your query.

Regards,

Manish

Re: Problem with modify command....

aarif_baig — Mon, 29 Jun 2009 05:56:16 GMT

Thanks manish..

u gave me the answer wat i was looking for..