topic Re: BAPI_TRANSACTION_COMMIT is dumping the program. in Application Development and Automation Discussions

BAPI_TRANSACTION_COMMIT is dumping the program.

Former Member — Thu, 24 Oct 2013 12:01:16 GMT

I am Using BAPI "BAPI_ACC_DOCUMENT_POST" for FI Documents.

in return table, I am getting :

TYPE - S

ID - RW

MESSAGE - Document posted successfully: BKPFF 000030501310002013 STPCLNT600

After that when i am using BAPI_TRANSACTION_COMMIT, It cause a short dump.

I also tried Commit work and wait. But the response is same.

Please help me, this is really urgent.

--> It may be urgent for you, but it is not for other members

The Dump message is:

Long text of error message:

Diagnosis

The material document posting was terminated to maintain data

consistency. An expected COMMIT WORK or ROLLBACK WORK statement was

triggered which is in turn caught by this error.

Data has already been preselected for the UPDATE at the time of the

COMMIT or ROLLBACK. If a COMMIT WORK or ROLLBACK is initiated in an

enhancement, these are then written or rolled back into the

database. If another error occurs during subsequent processing

after a COMMIT, a complete ROLLBACK can no longer be performed,

since the data up until the point of the COMMIT has already been

written to the database. Otherwise, if no further errors occur

following a ROLLBACK statement, the part that is subsequently

entered into the posting is also written to the database.

This can result in an inconsistent status, for example a material

document without accounting document or an accounting document

without a material document, which can only be repaired with

considerable cost and effort.

Inconsistencies that were caused by an incorrect implementation

must be corrected by SAP in accordance with SAP Note 83020, subject

to charge.

System Response

Procedure

Remove the critical sections of code from your customer

enhancements, such as MB_DOCUMENT_BADI. For more information about

this error and how to avoid it, see SAP Note 1776835.

Procedure for System Administration

Message was edited by: Suhas Saha

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

nabheetscn — Thu, 24 Oct 2013 12:05:17 GMT

You must be calling this in a BADI or enhancement. Please dont do a commit. Let SAP standard does it for you.

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

PeterJonker — Thu, 24 Oct 2013 12:11:25 GMT

A very clear error message off what you have done wrong. It even tells you what to do and which note to read.

Normally SAP is not so clear in what it means.

Why did you post the question and why don't just read the error message and the note mentioned in the error message ? It explains everything you need to know.

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

deependra_shekhawat3 — Thu, 24 Oct 2013 12:11:40 GMT

Hi neeraj,

As per nabheet, there would be enhancement/BADI implementation which having commit/rollback statements or in other words LUW are getting free. As BAPI_TRANSACTION_COMMIT runs an update process in system.

Thanks

Deependra

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

Former Member — Thu, 24 Oct 2013 12:12:59 GMT

Hi, Nabheet,

Yes, i am calling this in a badi. Recently we moved from ecc 6.0 to ehp 5.

My code was working fine old development. But in new development. It cause a dump.

and i am not able to understand the reason of dump.

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

Former Member — Thu, 24 Oct 2013 12:16:21 GMT

Hi Peter,

If i will not commit this, how i suppose to work further.

Cause i am picking the recently posted BELNR from bkpf after that commit.

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

ronaldo_aparecido — Thu, 24 Oct 2013 12:17:37 GMT

Hi Neeraj.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

EXPORTING

wait = 'X'.

Did you use the option wait?

You can send the code?

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

Former Member — Thu, 24 Oct 2013 12:19:59 GMT

Hi Ronaldo,

Yes I did.

But still in the same position.

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

PeterJonker — Thu, 24 Oct 2013 12:20:07 GMT

Maybe use perform on commit or define an rfc wrapper function module to do the task and call this in background task (new LUW), but first read the suggestions and note from SAP

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

PeterJonker — Thu, 24 Oct 2013 12:24:33 GMT

You are doing something critically wrong which can cost the company you are working for a lot of money.

Did you read the passage in the error message:

Inconsistencies that were caused by an incorrect implementation

must be corrected by SAP in accordance with SAP Note 83020, subject

to charge. "

????????

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

Former Member — Thu, 24 Oct 2013 12:25:51 GMT

I think you should try to comment the bapi_commit and see what happens. Since it is in a BADI, there is normally a bapi_commit done by SAP some point further in your flow. Try this and let us know what happens.

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

deependra_shekhawat3 — Thu, 24 Oct 2013 12:26:33 GMT

Neeraj,

Where you are commit , Could you please paste your code ??

Deependra

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

Former Member — Thu, 24 Oct 2013 12:29:51 GMT

I think we need to hear more about the process being used. I use BAPI_TRANSACTION_COMMIT after BAPI_ACC_DOCUMENT_POST in my own code with perfect success. So it is the context in which the OP is calling these.

Neal

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

PeterJonker — Thu, 24 Oct 2013 12:33:35 GMT

Exactly therefore why not read the note. Extract from the note:

If you want to avoid this error, check all customer enhancements in the FORM

routine BUCHEN_AUSFUEHREN in the include MM07MFB9_BUCHEN_AUSFUEHREN and remove

the existing COMMIT or ROLLBACK statements. Also check the methods and functions

that are called in your implementation. An SAP function module that is called in

a customer enhancement may also trigger a critical COMMIT statement. This is

incorrect.

Experience has shown that the incorrect implementation is in most

cases located in the BAdI MB_DOCUMENT_BADI in the method

MB_DOCUMENT_BEFORE_UPDATE. See SAP Notes 1284654 and 92550 for further

information.

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

Former Member — Thu, 24 Oct 2013 12:37:05 GMT

Hi Neeraj,

The code that gets executed inside BAPI_TRANSACTION_COMMIT is again COMMIT WORK with wait or COMMIT WORK AND WAIT in case wait = 'X' is not provided.

Committing work inside a BADI or an EXIT may result in wrong execution of program if the roll back needs to happen outside of BADI/ User Exit and is done through standard program.

To commit only a BAPI, you have to branch out of the program loop and come back but it is not recommended at all.

Tejus.

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

venkateswaran_k — Thu, 24 Oct 2013 12:37:19 GMT

Dear Neeraj

I assume you have written this commit inside the badi MB_DOCUMENT_BADI.

Please romove this - BAPI_TRANSACTION_COMMIT statement.

Since you are trying to commit the database in between the whole process, the system is not allowing this because, if any further rollback occurs, it cannot rollback whole as you already committed in between thus chances of data inconstancy.

Please remove this commit statement and check your transaction is complete.

Regards,

Venkat

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

nabheetscn — Thu, 24 Oct 2013 12:51:08 GMT

Hi Neeraj

What are you suppose to do further with this document? Basically you are interdering with sAP LUW when you do a commit it is not a good approrach. What i suggest is please telll us what exactly do you want to achieve via this enhancement. Their are many ways as everyone suggested either you can create a wrapper around you whole code and call it in background task etc.

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

nabheetscn — Thu, 24 Oct 2013 12:51:10 GMT

Hi Neeraj

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

Former Member — Thu, 24 Oct 2013 12:53:43 GMT

Hello all,

If a won't commit,

How i get the belnr from bkpf.

Re: BAPI_TRANSACTION_COMMIT is dumping the program.

Former Member — Thu, 24 Oct 2013 12:56:11 GMT

Here is my code:

LWA_DOC_HDR-bus_act = 'test1'.	"new
*	LWA_DOC_HDR-ref_doc_no = 'test2'.	"new
*	LWA_DOC_HDR-header_txt = 'test3'.	"new
	LWA_DOC_HDR-USERNAME = SY-UNAME.
	LWA_DOC_HDR-REF_DOC_NO = ref_number.
	LWA_DOC_HDR-COMP_CODE = CCODE.	"'1900'.
	LWA_DOC_HDR-DOC_DATE = WA_XMKPF-BLDAT."SY-DATUM.
	LWA_DOC_HDR-PSTNG_DATE = WA_XMKPF-BUDAT."'20090101'.
	LWA_DOC_HDR-DOC_TYPE = 'KC' .
	LWA_DOC_HDR-FISC_YEAR = FYEAR.	"'2013'.
	LWA_DOC_HDR-FIS_PERIOD = FPERIOD.	"'03'.

	LWA_ACCPAY-ITEMNO_ACC = VEND.	"'0000000001'.
*	LWA_ACCPAY-VENDOR_NO = VENDOR.	"WA_XMSEG-WEMPF.
	LWA_ACCPAY-VENDOR_NO = VENDOR1.
	LWA_ACCPAY-GL_ACCOUNT = VACCT.
	LWA_ACCPAY-COMP_CODE = CCODE.
	LWA_ACCPAY-BUS_AREA = BAREA.
	LWA_ACCPAY-BUSINESSPLACE = CCODE.
	LWA_ACCPAY-SECTIONCODE = CCODE.
	LWA_ACCPAY-ALLOC_NMBR = WA_XMSEG-EBELN.
*	LWA_ACCPAY-ITEM_TEXT = VEND_GL.	"'TEST_VENDOR'.
	LWA_ACCPAY-ITEM_TEXT = VEND_GL1.
	APPEND LWA_ACCPAY TO IT_ACC_PAY.
	CLEAR LWA_ACCPAY.

	LWA_ACCNTGL-ITEMNO_ACC = GL.	"'0000000002'.
	LWA_ACCNTGL-GL_ACCOUNT = '0004105001'.
	LWA_ACCNTGL-COMP_CODE = CCODE.	"'1900' .
	LWA_ACCNTGL-DOC_TYPE = 'KC'.
	LWA_ACCNTGL-COSTCENTER = CCENTRE."'0001000891'.
	LWA_ACCNTGL-BUS_AREA = BAREA."'0001000891'.
*	LWA_ACCNTGL-ITEM_TEXT = VEND_GL.
	LWA_ACCNTGL-ITEM_TEXT = VEND_GL1.
*	LWA_ACCNTGL-VENDOR_NO = VENDOR.	"WA_XMSEG-WEMPF.
	LWA_ACCNTGL-VENDOR_NO = VENDOR1.
	LWA_ACCNTGL-PSTNG_DATE = WA_XMKPF-BUDAT."VENDOR."'0001000891'.
	LWA_ACCNTGL-FISC_YEAR = FYEAR.	"'2013'.
	LWA_ACCNTGL-FIS_PERIOD = FPERIOD.	"'02'.
	LWA_ACCNTGL-TAXJURCODE = '9000'.
	LWA_ACCNTGL-ALLOC_NMBR = WA_XMSEG-EBELN.
	APPEND LWA_ACCNTGL TO IT_ACC_GL.
	CLEAR LWA_ACCNTGL.

LWA_CURRAMNT-ITEMNO_ACC = VEND.	"VENDOR
LWA_CURRAMNT-CURR_TYPE = '00'.
LWA_CURRAMNT-CURRENCY = 'INR' .
LWA_CURRAMNT-AMT_DOCCUR = PRICE1.	"'-10.00'.	"
LWA_CURRAMNT-DISC_BASE = PRICE1.
APPEND LWA_CURRAMNT TO IT_CURR_AMT.
CLEAR LWA_CURRAMNT.

	LWA_CURRAMNT-ITEMNO_ACC = GL.	"GL
	LWA_CURRAMNT-CURR_TYPE = '00'.
	LWA_CURRAMNT-CURRENCY = 'INR' .
	LWA_CURRAMNT-AMT_DOCCUR = 0 - PRICE1. "'10.00' . "
	LWA_CURRAMNT-DISC_BASE = 0 - PRICE1. "'10.00' .
	APPEND LWA_CURRAMNT TO IT_CURR_AMT.
	CLEAR LWA_CURRAMNT.

*************************************************************************************************

	AT LAST.
	CALL FUNCTION 'BAPI_ACC_DOCUMENT_POST' IN BACKGROUND TASK AS SEPARATE UNIT
	EXPORTING
	DOCUMENTHEADER	= LWA_DOC_HDR

**IMPORTING

** OBJ_TYPE	=
** OBJ_KEY	=
** OBJ_SYS	=
	TABLES
	ACCOUNTGL	= IT_ACC_GL
	ACCOUNTPAYABLE	= IT_ACC_PAY
	CURRENCYAMOUNT	= IT_CURR_AMT
	RETURN	= IT_RETURN
*	extension1	= lt_extn.
	EXCEPTIONS
	OTHERS	= 1.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

	EXPORTING
	WAIT = 'X'
	IMPORTING
	RETURN	= RETURN .

WAIT UP TO 10 SECONDS.

SELECT BELNR INTO CORRESPONDING FIELDS OF TABLE IT_BKPF FROM BKPF

WHERE BUKRS = CCODE

AND BUDAT = WA_XMKPF-BUDAT

AND GJAHR = FYEAR

AND BLART = 'KC'.

SORT IT_BKPF DESCENDING BY BELNR.

READ TABLE IT_BKPF INTO WA_BKPF INDEX 1.

WA_MIGO-PO_NO = WA_BKPF-BELNR.

WA_MIGO-MBLNR = WA_XMKPF-MBLNR.

MODIFY ZSCH_MIGO FROM WA_MIGO.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

EXPORTING

WAIT = 'X'.