topic Re: modulepool in Application Development and Automation Discussions

modulepool

Former Member — Tue, 15 Jul 2008 17:14:05 GMT

hi,

iam developing a program in which iam using a z-table.

iam using the bapi for production order cancel and create goods movement....

after running those bapis i have to update few fields in z-table ie...cancel conf counter, mat doc number to the record from where i have taken the order for cancellation and material document for goods movement create.....so wat is the synatx i can use to update that particular row in z-table through my program.

please help me .This is urgent.. <= read [the rules|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement] here !

points will be rewarded. <= read [the rules|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement] here as well!

Regards,

Rohan.

Edited by: Julius Bussche on Jul 16, 2008 10:03 AM

Re: modulepool

Former Member — Tue, 15 Jul 2008 17:47:35 GMT

Hello,

You can use the modify statement to change the values or update the values:

MODIFY target FROM source.

Here Target would be the database table name.

Source would be the lines of an internal table for which the database table should be updated.

Explore the help on modify command.

Regards,

Sushil Joshi

Re: modulepool

Former Member — Tue, 15 Jul 2008 17:56:53 GMT

Hi,

UPDATE TABLE ITAB FROM <WA> where KEY <key of table> = value.

MODIFY TABLE ITAB FROM <WA> where KEY <key of table> = value.

One more thing...

Never Use word URGENT in the thread... Moderator will lock the thread as its against the Rules of Engagement...

Regards

Narin Nandivada

Re: modulepool

former_member787646 — Wed, 16 Jul 2008 06:44:22 GMT

Use the statement to update the record

UPDATE <ZTABLE> SET <field_name> = <value>

Where <Key_Field> = <key_field_value> [ AND <field2> = <field_value_2>, etc ]

Hope this would help you.

Murthy

Re: modulepool

Former Member — Wed, 16 Jul 2008 09:58:19 GMT

hi one doubt u have mentioned second field .so is that the field which is iam updating or it is the second field in where condition...