Show TOC

 Detection Method: Customer and Bank Location Differ

 

Use this detection method to find customers whose bank account is located in a different country than the home country of the customer.

Logic

The execution procedure checks whether the bank location country from the bank account (Input field IT_DATA_FOR_RULE.BANK_COUNTRY_KEY) is different than the customer location country (database table field KNA1.LAND1). If the bank account location is identified as suspicious, the bank account is added to the result table with 100 as detection result.

Investigation and Detection Object Types
  • Investigation Object Type: FRA_CUST (Customer)

  • Detection Object Type: FRA_CUBANK (Customer Bank Account)

ERP Tables Used
  • KNA1: General Data in Customer Master

  • KNBK: Customer Master (Bank Details)

Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_BANK_ACCOUNT_SELE

SQLScript Procedure

sap.hana-app.fra.suite.ord.dt.customer.bankaccount.se

Execution

PR_BANK_ACCOUNT_EXEC

SQLScript Procedure

sap.hana-app.fra.suite.ord.dt.customer.bankaccount.ex

Additional Information

PR_BANK_ACCOUNT_ADDINF

SQLScript Procedure

sap.hana-app.fra.suite.ord.dt.customer.bankaccount.ai

Detection Method Parameters

None.

Alert Messages
  • Message ID FRA_INTERNAL_AUDIT, message number 083, The customer &1 is in &2, but the bank account is located in &3