Show TOC

 Detection Method: Duplicate Invoice with Same Approver 1

 

Use this detection method to determine if a document reference number (external invoice ID) has been used more than once for the same vendor and if it was approved by the same person.

Logic

Invoices are considered suspicious if the:

  • Vendor (field LIFNR in table BSEG) is the same

  • Reference number (field XBLNR in table BKPF) is the same

  • And if one of the following fields are different:

    • Company code (field BUKRS in table BKPF)

    • Document number (field BELNR in table BKPF)

    • Fiscal year (field GJAHR in table BKPF)

If the above conditions are met, the detection method returns a score of 50.

If the suspicious invoices were also approved by the same person (field WI_AAGENT in table SWWWIHEAD), then it returns a score of 100.

To determine the approver, only workflow items with task ID TS00407862, which is the standard payment release task (field WI_RH_TASK in table SWW_WI2OBJ), are considered. This information may need to be adapted for customer-specific workflow implementations.

Investigation and Detection Object Types

  • Investigation object type FRA_VEND (Vendor)

  • Detection object type FRA_VEINVH (Vendor Invoice Header)

ERP Tables Used

  • BKPF: Accounting Document Header

  • BSEG: Accounting Document Segment

  • SWOTIP: Index Parent Object Types

  • SWW_WI2OBJ: Workflow Runtime: Relation of Work Item to Object

  • SWWWIHEAD: Workflow Runtime: Header Table for All Work Item Types

  • T001: Company Codes

SAP HANA Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_INVOICE_REF_DOUBLES_SELE

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.vendor.invoiceheader.se

Execution

PR_INVOICE_REF_DOUBLES_EXEC

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.vendor.invoiceheader.ex

Additional Information

PR_INVOICE_REF_DOUBLES_ADDINF

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.vendor.invoiceheader.ai
Alert Messages

Message ID

Message Number

Message Text

FRA_INTERNAL_AUDIT

063

External document reference number &1 is also used with invoice &2/&3/&4

FRA_INTERNAL_AUDIT

064

Both invoices have been approved by the same person