BAPI_ACC_GL_POSTING_POST

[Former Member]

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,.

[Former Member]

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

[Former Member]

Hi,

and it is trying to create record i guess.

did you check any notes on this....

check it.

regards

vijay

[Former Member]

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

Rob

[nishanthbhandar]

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