Show TOC

 Detection Method: Duplicate Travel Expense Claim Made by One Employee

 

Use this detection method to find cases in which an employee has submitted a similar or duplicate receipt for different travel expense claims.

Logic

In order to determine if an employee has submitted and reused receipts on more than one travel expense, the fields Personnel Number, Travel Expense Type, Amount, and Currency are compared. As well, the field Trip Number must be different. Only the last 180 days are selected as relevant. In order not to create too many alert items, only one record with the latest date for these fields is selected. Only receipts that have the same currency as defined in the currency parameter are considered. The risk amount will be the sum of all the reused receipts (plus the original one).

Investigation and Detection Object Types

  • Investigation object type: FRA_EMPL (Employee)

  • Detection object type: FRA_TERCPT (Travel Expense Receipt)

ERP Tables Used

  • PTRV_SREC: Trip Statistics - Receipts

  • PTRV_HEAD: General Trip Data

  • PA0001: HR Master Record: Infotype 0001 (Org. Assignment)

  • PA0002: HR Master Record: Infotype 0002 (Personal Data)

SAP HANA Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_SAME_RECEIPT_SELE

SQLScript Procedure

sap.hana-app.fra.suite.hr.dt.employee.travexpreceipt.se

Execution

PR_SAME_RECEIPT_EXEC

SQLScript Procedure

sap.hana-app.fra.suite.hr.dt.employee.travexpreceipt.ex

Additional Information

PR_SAME_RECEIPT_ADDINF

SQLScript Procedure

sap.hana-app.fra.suite.hr.dt.employee.travexpreceipt.ai
Detection Method Parameters

Technical Name

Description

Definition

NO_OF_SAME_RECEIPT

Minimum or equal match

Determines the minimum or equal number of receipts which are classified as the same receipt

AMOUNT

Minimum match

Determines the minimum amount a receipt must have in order to be evaluated

AMOUNT_CURRENCY

Exact match

The currency for parameter AMOUNT
Alert Messages

  • Message ID FRA_INTERNAL_AUDIT, message number 133, Receipt &1 for &2 and &3 &4

  • Message ID FRA_INTERNAL_AUDIT, message number 140, In trip &1 was already used for trip &2 and receipt &3