modulepool

[Former Member]

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

[Former Member]

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

[Former Member]

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

[former_member787646]

Hi

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

[Former Member]

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...