Application Development and Automation 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: 
Read only

Multiple update statement not updating the table

Former Member
0 Likes
944

Hi All,

I'm updating EKPO table using 2 update statements as follows.

1. If first update statement is successful ,COMMIT and WAIT.

then,

2.perform the next update.

This works when I'm creating the PO in but when im doing it using 4(send immediately) then I get a

dump " COMMIT IN POSTING'.

Please help.

Thanks,

Faiz

4 REPLIES 4
Read only

ThangaPrakash
Active Contributor
0 Likes
836

Hello Faiz,

Try with ENQUEUE, update the table and then DEQUEUE.

Regards,

Thanga

Read only

0 Likes
836

Try with lock objects below.

EMEKPOE                        Purchasing Document Item Exclusive

EWB2_EKPO                    Lock Object: Item In Purchasing Document

with function modules.

DEQUEUE_EMEKPOE

ENQUEUE_EMEKPOE

or

DEQUEUE_EWB2_EKPO

ENQUEUE_EWB2_EKPO

Regards,

Thanga

Read only

Former Member
0 Likes
836

Hi Faizur,

Rather using UPDATE statement  in EKPO standard table, Use BAPI_PO_CHANGE .

You can also implement BADI ME_PROCESS_PO_CUST depend upon your requirement.

Regards,

Pravin

Read only

RaymondGiuseppi
Active Contributor
0 Likes
836

Don't use open-sql statement on standard SAP tables, are you able to use ME23N/ME22N on those created objects, input GR/IR, etc, Better use BAPI_PO_CREATE1

In which context do you use those statements?

Regards,

Raymond