Detection Method: Vendor Bank Data Change (Flip-Flop Vendor)

This detection method lets you find vendors for which the master data – especially bank account information – has changed often within a specified period of time.

Logic

This detection method reads changes to the bank data of vendors and checks whether each change reverses a previous change to the same bank data. The previous change must occur within the interval specified in the input parameters to the detection method. If these conditions are met, then the detection method determines whether invoices were paid to the vendor during the specified period of time.

The detection result is 50 if there was a master data change without payments. The detection result is 100 if payments are found while the master data was changed. The risk value is the aggregated payment amount in investigation currency.

Investigation and Detection Object Types

Investigation object type: FRA_VMDCHG (Vendor Master Data Change)
Detection object type: FRA_VMDCHG (Vendor Master Data Change)

ERP Tables Used

CDHDR: Change document header
LFB1: Vendor Master (Company Code)

SAP HANA Procedures for Detection Methods

Procedure Category	Procedure Name	Procedure Type	Package
Selection	PR_BB_VENDOR_BANK_DATA_CHANGED_SELE	SQLScript Procedure	sap.hana-app.fra.suite.pur.dt.vendormasterchng.se
Execution	PR_BB_VENDOR_BANK_DATA_CHANGED_EXEC	SQLScript Procedure	sap.hana-app.fra.suite.pur.dt.vendormasterchng.ex
Additional Information	PR_BB_VENDOR_BANK_DATA_CHANGED_ADDINF	SQLScript Procedure	sap.hana-app.fra.suite.pur.dt.vendormasterchng.ai

Detection Method Parameters

REVIEW_PERIOD_IN_DAYS: Period in days in which changes to previous changes to the alternative payee are to be sought.

Alert Messages

Message ID	Message Number	Message Text
FRA_INTERNAL_AUDIT	041	No payment available
FRA_INTERNAL_AUDIT	042	Date and time when the new bank account was active the last time: &1, &2
FRA_INTERNAL_AUDIT	043	The document number of the payment is &1