topic BAPI_ACC_DOCUMENT_POST posting duplicate entries in Application Development and Automation Discussions

BAPI_ACC_DOCUMENT_POST posting duplicate entries

Former Member — Mon, 13 Jul 2015 18:45:06 GMT

Hi All,

Im using the BAPI_ACC_DOCUMENT_POST for posting a FI document.
However the issue that im facing is that it will allow duplicate entries to be posted for the same data.

How can we restrict that ???

I've checked SCN for the same and the only solution which I could see is using FI_DUPLICATE_INVOICE_CHECK.

But since its an unreleased FM we should ideally not use it.

Any other fix apart from this??

Thanks,

Faiz

Re: BAPI_ACC_DOCUMENT_POST posting duplicate entries

Former Member — Tue, 14 Jul 2015 07:07:14 GMT

Hi,

Please elaborate for what type of document you are posting through the said BAPI .

You can create your own logic and fetch the database table based on that. For eg let assume that the reference(XBLNR) field will be unique for all the document ( document types you are posting ) then you can fetch the Table BKPF and check of that Reference (XBLNR) is already given for any other document or not.

Please try and make the logic on header Table (BKPF) as it would be easy to fetch .

Hope this helps.

Re: BAPI_ACC_DOCUMENT_POST posting duplicate entries

Former Member — Fri, 05 Feb 2016 03:48:11 GMT

Hi,

I also use BKPF check in field AWKEY to prevent duplicate postings.

But it still generate double finance document in with same AWKEY in sequence running number(75000000001,75000000002).

This happen since we execute more than 10000 transaction in one loop.

It seems problem came from inside BAPI_ACC_DOCUMENT_POST.

Is there any duplicate check inside the bapi such as exit or enanchement spot, etc.

Re: BAPI_ACC_DOCUMENT_POST posting duplicate entries

RaymondGiuseppi — Fri, 05 Feb 2016 10:58:44 GMT

If you don't use a WAIT option in the commit, you won't be able to check for duplicates, nor will any SAP standard too. And even if you wait, some performance or buffer problem can prevent correct check.

TWO checks required

Use some SQL statement to check between yourdata and current values in database (this one can simulate FI_DUPLICATE_INVOICE_CHECK or some AWTYP/AWKEY logic)
Check in your program data (internal tables) to block/remove duplicates in the received data

Regards,

Raymond