topic Re: query on SQL in Application Development and Automation Discussions

query on SQL

Former Member — Wed, 21 Jun 2006 10:54:48 GMT

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 — Wed, 21 Jun 2006 10:55:53 GMT

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 — Wed, 21 Jun 2006 10:55:57 GMT

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

just add after update command commit work.

Former Member — Wed, 21 Jun 2006 10:57:35 GMT

Hi Surendrakumar,

After Update use the statement commit work.

Regards,

Mukesh Kumar

santhosh_patil — Wed, 21 Jun 2006 11:07:49 GMT

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 — Wed, 21 Jun 2006 11:22:10 GMT

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