topic Re: modify statement in Application Development and Automation Discussions

modify statement

Former Member — Thu, 21 Sep 2006 20:08:32 GMT

I want to modify one internal table from another internal table.

I have my code as below

it2_vbrk = it1_vbrk.

DELETE it2_vbrk WHERE aubel <> space.

SELECT vbelv

vbeln

INTO it_vbfa

FROM vbfa

FOR ALL ENTRIES IN it2_vbrk

WHERE vbeln EQ it2_vbrk-vbeln

AND vbtyp_v EQ 'C'.

ENDSELECT.

DELETE ADJACENT DUPLICATES FROM it_vbfa.

LOOP AT it_vbfa.

it1_vbrk-aubel = it_vbfa-vbelv. "sales order

MODIFY it1_vbrk WHERE vbeln = it_vbfa-vbeln

TRANSPORTING it_vbfa-vbelv.

ENDLOOP.

REFRESH : it2_vbrk.

CLEAR it2_vbrk.

I am having problems in the loop endloop of the table it_vbfa at the modify statement.

Shejal Shetty.

Re: modify statement

Former Member — Thu, 21 Sep 2006 20:11:46 GMT

Hi,

You have to give transporting vbelv instead of it_vbfa-vbelv

MODIFY it1_vbrk WHERE vbeln = it_vbfa-vbeln

TRANSPORTING <b>vbelv</b>.

Thanks,

naren

Re: modify statement

Former Member — Thu, 21 Sep 2006 20:16:34 GMT

Thanks Naren,

I tried it still has an error.

error-

"WHERE VBELN = IT_VBFA-VBELN" is not expected.

any suggestions.

shejal

Re: modify statement

Former Member — Thu, 21 Sep 2006 20:18:01 GMT

Hi,

I think transporting should come first and then the where condition..

MODIFY it1_vbrk TRANSPORTING aubel

WHERE vbeln = it_vbfa-vbeln.

It should be AUBEL instead of vbelv, since you are trying to modify aubel..

Thanks,

Naren

Re: modify statement

Former Member — Thu, 21 Sep 2006 20:21:58 GMT

Thanks Naren.

Shejal Shetty.

Re: modify statement

Former Member — Thu, 21 Sep 2006 20:22:44 GMT

hi,

try this..

MODIFY it1_vbrk TRANSPORTING vbelv WHERE vbeln = it_vbfa-vbeln.

LOOP AT it_vbfa.

it1_vbrk-aubel = it_vbfa-vbelv. "sales order

if it1_vbrk-vbeln = it_vbfa-vbeln.

MODIFY it1_vbrk TRANSPORTING vbelv.

endif.

ENDLOOP.

hope this helps