Show TOC

 Detection Method: Employees with Same Bank Data as Vendor

 

In order to pay out travel expenses, some employees are also set up as vendors in the system. This detection method checks if any of these employees have the same bank account data as a regular vendor in the system. If an employee uses the same bank account data as a vendor, then this employee master data record is considered to be potentially fraudulent.

Employees can be identified in the vendor master by their Vendor Account Group. In the standard delivery, the vendor account group is HRTPfor reimbursing travel expenses to employees. This value is hard coded in the selection and execution procedures. If a different vendor account group must be used, then this value also must be added to the coding of these procedures.

Logic

For each employee record in the input data table, the execution procedure checks whether the corresponding bank account is already a regular vendor bank account. To make this check, the procedure first creates a list of the regular vendor bank accounts by joining the database table LFBK, LFA1 and LFB1 on the vendor account number (LIFNR), where the client equals the session client and the vendor account group (KTOKK) is unequal HRTP.

Afterwards the procedure compares the employee bank accounts with the regular vendor bank accounts by joining the two lists. In case identical bank account data is found for both a vendor and an employee, then the details of the employee as well as the connected regular vendor are returned. In addition, a detection result field with value 100 is returned.

Investigation and Detection Object Types

  • Investigation object type: FRA_VEND (Vendor)

  • Detection object type: FRA_VEND (Vendor Master Data)

ERP Tables Used

  • LFA1: Vendor Master (General Section)

  • LFB1: Vendor Master (Company Code)

  • LFBK: Vendor Master (Bank Details)

SAP HANA Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_VENDOR_BANK_DATA_DOUBLES_SELE

SQLScript Procedure

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

Execution

PR_VENDOR_BANK_DATA_DOUBLES_EXEC

SQLScript Procedure

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

Additional Information

PR_VENDOR_BANK_DATA_DOUBLES_ADDINF

SQLScript Procedure

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

  • Message ID FRA_INTERNAL_AUDIT, message number 079, Employee &1, &2 and vendor &3, &4 have same bank account data