topic Re: Multiple update statement not updating the table in Application Development and Automation Discussions

Multiple update statement not updating the table

Former Member — Thu, 25 Feb 2016 17:49:22 GMT

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

Re: Multiple update statement not updating the table

ThangaPrakash — Fri, 26 Feb 2016 06:22:11 GMT

Hello Faiz,

Try with ENQUEUE, update the table and then DEQUEUE.

Regards,

Thanga

Re: Multiple update statement not updating the table

ThangaPrakash — Fri, 26 Feb 2016 06:25:59 GMT

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

DEQUEUE_EWB2_EKPO

ENQUEUE_EWB2_EKPO

Regards,

Thanga

Re: Multiple update statement not updating the table

Former Member — Fri, 26 Feb 2016 07:27:34 GMT

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

Re: Multiple update statement not updating the table

RaymondGiuseppi — Fri, 26 Feb 2016 07:28:42 GMT

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