Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

query on SQL

Former Member
0 Kudos

hi,

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

please help.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

just add after update command commit work.

5 REPLIES 5

sridharreddy_kondam
Active Contributor
0 Kudos

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
0 Kudos

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

just add after update command commit work.

Former Member
0 Kudos

Hi Surendrakumar,

After Update use the statement commit work.

Regards,

Mukesh Kumar

santhosh_patil
Contributor
0 Kudos

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
0 Kudos

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