topic Re: error in modify statement in Application Development and Automation Discussions

error in modify statement

Former Member — Tue, 04 Nov 2008 10:18:19 GMT

hi,

i have to modify the table.my coding is

form update_table.

clear it_header.

loop at gi_header_temp into it_header.

vekp-brgew = it_header-brgew.

modify vekp from it_header where exidv = it_header-exidv.

endloop.

endform.

but i am getting syntax error'. expected after it_header'.

i have to update the data using where condition

Re: error in modify statement

former_member404244 — Tue, 04 Nov 2008 10:21:38 GMT

Hi,

u r passing value to vekp ,so directly u can modify it.

form update_table.

clear it_header.

loop at gi_header_temp into it_header.

vekp-brgew = it_header-brgew.

modify vekp index sy-tabix

endloop.

endform.

Regards,

Nagaraj

Re: error in modify statement

Former Member — Tue, 04 Nov 2008 10:23:30 GMT

Check if structure of vekp and it_header are same.They must be similar.

whats the use of following statement


vekp-brgew = it_header-brgew

You have not used that

Re: error in modify statement

Former Member — Tue, 04 Nov 2008 10:33:36 GMT

Try this .

clear it_header.

loop at gi_header_temp into it_header.

vekp-brgew = it_header-brgew.

modify vekp from it_header TRANSPORTING brgew

where exidv = it_header-exidv.

End Loop

From SAP help for Modify statement "

. The WHERE addition can only be specified together with the TRANSPORTING addition. After WHERE, any logical expression can be specified in which the first operand of each individual comparison is a component of the internal table"

Regards

Beena

Edited by: Beena Prabha on Nov 4, 2008 5:35 AM

Re: error in modify statement

Former Member — Tue, 04 Nov 2008 10:41:59 GMT

Hi,

You cannot use 'WHERE' clause with MODIFY statment ( when you updating database tables). I would suggest you to use Update instead of modify. Modify statment is dangerous. Unless you want that If an entry is not found in the table VEKP for that EXIDV then it should be created.

regards,

Advait

Edited by: Advait Gode on Nov 4, 2008 11:42 AM

Re: error in modify statement

Former Member — Tue, 04 Nov 2008 10:44:12 GMT

You cannot use WHERE condition while modifying a database table.

Re: error in modify statement

Former Member — Tue, 04 Nov 2008 10:58:20 GMT

Hi,

Use 'Transporting' option with modify statement.

Thanks & Regards,

Sudheer