query on SQL

[Former Member]

hi,

an UPDATE statement i coded for MARA updates one material, but does not update another material what could be the reason.

please help.

[sridharreddy_kondam]

Hi Surendar,

Can u give the code in detail...

r u using the Update statement once without a loop or ?

And also after Update use commit work.

Update updates the record if the record exists...

Modify modifies the record if exists else creates a new record...

Regards,

Sridhar

[Former Member]

avoid to use update(insert,delete) command in sap standard table.

just add after update command commit work.

[Former Member]

Hi Surendrakumar,

After Update use the statement commit work.

Regards,

Mukesh Kumar

[santhosh_patil]

hi,

better you lock the table before update and unlock the table after update, this may help.

you can use this FM :

DEQUEUE_E_TABLEE

ENQUEUE_E_TABLEE

[Former Member]

Hi,

Use conversion exit FM for numeric materials

Try using modify and also check whether your

where condition value matches with mara-matnr.

Regards,

Amole