Skip to Content

Duplicate IDOC is created - Database table update time

Hi SAP Experts,
We have an inbound interface which creates acc doc in SAP. We have placed a duplicate check in SAP to avoid posting duplicate if same file is received twice. There are some cases where the logic is not working since the Duplicate file comes even before the original idoc is update in database table
EXAMPLE:
Original File (ABC) = Creation Dt (12/1/17) Time Creation=5:00:00 Databse Updt time 5:00:10
Duplicte File (XYZ) = Creation Dt (12/1/17) Time Creation=5:00:03 Databse Updt time 5:00:10.

Here you will notice duplicate idoc is created before the database table is updated, hence the logic for duplicate check is not working just becuase Database table is updated later.

Can soemone guide me how I can fix this. The middleware is SAP PI I dont want any develpment at SAP PI side for this issue, how I can place a check in SAP side, as the lgoic works only if we have data in database table.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 04, 2017 at 07:56 PM

    Maybe no online processing of the idocs but logic which does batch processing (once every 15 minutes). First cross check the documents in the batch than process while checking against already posted documents.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2017 at 07:12 PM

    Thank you so much Bastiaan.

    Add comment
    10|10000 characters needed characters exceeded