topic Re: BAPI_ACC_GL_POSTING_POST in Application Development and Automation Discussions

BAPI_ACC_GL_POSTING_POST

Former Member — Mon, 29 May 2006 11:46:07 GMT

HI,

I Am using BAPI to upload G/L Account.

BAPI_ACC_GL_POSTING_POST

And

BAPI_TRANSACTION_COMMIT

It is getting Express message like,

Update was terminated

System ID.... DR3

Client....... 201

User..... SRAO

Transaction.. SE38

Update key... 895D42088D3840D89F9051892EC36A61

Generated.... 29.05.2006, 06:34:10

Completed.... 29.05.2006, 06:34:12

Error info... 00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

PLease provide the solution.

THanks,

Veerendra,.

Re: BAPI_ACC_GL_POSTING_POST

Former Member — Mon, 29 May 2006 11:50:09 GMT

HI,

Use an ABAP/4 Open SQL array insert only if you are sure that none of

the records passed already exists in the database.

The ABAP/4 Open SQL array insert results in duplicate database records.

records in the data base.

If you use an ABAP/4 Open SQL array insert to insert a record in

the database and that record already exists with the same key,

this results in a termination.

(With an ABAP/4 Open SQL single record insert in the same error

situation, processing does not terminate, but SY-SUBRC is set to 4.)

Regards,

Ravi

Re: BAPI_ACC_GL_POSTING_POST

Former Member — Mon, 29 May 2006 11:55:06 GMT

Hi,

and it is trying to create record i guess.

did you check any notes on this....

check it.

regards

vijay

Re: BAPI_ACC_GL_POSTING_POST

Former Member — Mon, 29 May 2006 14:56:35 GMT

There may be a config. problem. You can use transactions SM13 and SM14 to analyze the reasons for the update failure.

Rob

Re: BAPI_ACC_GL_POSTING_POST

nishanthbhandar — Mon, 29 May 2006 17:50:39 GMT

See the restrictions mentioned in the FM documentation for the FM BAPI_ACC_GL_POSTING_POST

Restrictions:

This object cannot be used to update business transactions which are normally posted to one of the subledgers which affects the balance sheet (such as a billing document; for this see the business object AcctngBilling).

This is especially applicable if the reason the relevant subledger cannot be updated is because it is an external system or is not in use.

<b>The update termination error occurs whenever you try to insert a duplicate record into the database table.</b>

Cheers

Nishanth

Message was edited by: Nishanth Bhandar