Detection Method: Vendors with Similar Bank Accounts

You can use this method to check for vendors that have similar bank accounts.

Note Note

The use of the method is currently supported in systems in which a vendor IBAN has been entered directly in the vendor master data.

This method may produce false alerts in systems where the vendor account numbers have been replaced with IBAN references using SAP's generic IBAN management feature. In this case, the actual IBANs are referenced in table TIBAN.

End of the note.

Logic

The execution procedure checks whether a vendor bank account is similar to bank accounts of other vendors. Two bank accounts are similar if both have the same BANK_COUNTRY_KEY and BANK_KEY. The BANK_ACCOUNT_NUMBER may be different in the last 3 digits, but must have the same length.

Investigation and Detection Object Types

Investigation object type: FRA_VEND (Vendor)
Detection object type: FRA_VEBANK (Vendor Bank Account)

ERP Tables Used

LFA1: Vendor Master (General Section)
LFBK: Vendor Master (Bank Details)

SAP HANA Procedures for Detection Methods

Procedure Category	Procedure Name	Procedure Type	Package
Selection	PR_SIMILAR_BANK_ACCOUNT_SELE	SQLScript Procedure	sap.hana-app.fra.suite.pur.dt.vendor.bankaccount.se
Execution	PR_SIMILAR_BANK_ACCOUNT_EXEC	SQLScript Procedure	sap.hana-app.fra.suite.pur.dt.vendor.bankaccount.ex
Additional Information	PR_SIMILAR_BANK_ACCOUNT_ADDINF	SQLScript Procedure	sap.hana-app.fra.suite.pur.dt.vendor.bankaccount.ai

Alert Messages

Message ID FRA_INTERNAL_AUDIT, message number 092, Vendor &1 &2 has a similar bank account