topic Re: BAPI commit without using Wait? need to get the data for created order in Application Development and Automation Discussions

BAPI commit without using Wait? need to get the data for created order

Former Member — Tue, 31 Aug 2010 06:13:38 GMT

I am using BAPI to create or change sales order and by using 'BAPI_TRANSACTION_COMMIT' updating the database.

Immediately after that there is some requirement to fetch VBAP with the created order number, but there is no data found.

If i use call function 'BAPI_TRANSACTION_COMMIT'

exporting

wait = 'X'.

then i am able to fetch data from VBAP, but its impacting the performance. Is there any alternative way to get data without fetching or without using wait.

Can i use ABAP memory or SAP memory to get the details?

Please help...........

Re: BAPI commit without using Wait? need to get the data for created order

JoffyJohn — Tue, 31 Aug 2010 06:21:55 GMT

call function 'BAPI_TRANSACTION_COMMIT'

exporting

wait = 'X'.

is actually synchronous update. The processing wait till data is written to database.

That is the right way. It is better to commit to database and then fetch the commited data with a select.

Re: BAPI commit without using Wait? need to get the data for created order

Former Member — Tue, 31 Aug 2010 17:44:29 GMT

Thanks for the reply...

yes i am using commit work...but i don't want the wait...its a performance issue for my case....i want some solution so that by exporting memory or some other way to avoid the "WAIT"..

Thankss....

Re: BAPI commit without using Wait? need to get the data for created order

Former Member — Tue, 31 Aug 2010 18:09:30 GMT

Hi Tapas379,

Yes technically you can:

set data before commit


 DATA memory_id(20) TYPE c.

  CONCATENATE 'VBAP_01_' sy-uname INTO memory_id.

  DELETE FROM DATABASE indx(as) ID memory_id.

  EXPORT vbap_tab = vbap_tab "<-input
    TO DATABASE indx(as)
    CLIENT sy-mandt
    ID memory_id.

Get data from anywhere after setting it.



  data memory_id(20) type c.

  concatenate 'VBAP_01_' sy-uname into memory_id.

  import vbap_tab = vbap_tab " ->output
    from database indx(as)
    client sy-mandt
    id memory_id.
  delete from database indx(as) id memory_id.

Thanks,

Duy

Re: BAPI commit without using Wait? need to get the data for created order

kesavadas_thekkillath — Tue, 31 Aug 2010 22:21:00 GMT

what if the commit fails ?

Re: BAPI commit without using Wait? need to get the data for created order

Former Member — Tue, 31 Aug 2010 22:51:20 GMT

That's why I said "technically".

Thanks,

Duy

Re: BAPI commit without using Wait? need to get the data for created order

Former Member — Wed, 01 Sep 2010 15:08:06 GMT

Hi Pham Duy,

Thanks for the reply......

Actually i am using BAPI, So those data i am passing to the BAPI that i know.

I want those data which are updated in VBAP after creation of the order(i.e. excluding the data i m passing to the BAPI)

So until commit work and wait i am not getting the data, which is a performance issue and i want to avoid it.