Show TOC

 Detection Method: Changes to Customer Master Data

 

You can use this method to find customers whose address master data has changed more frequently within the last 12 months than the threshold that you specify for such changes.

Logic

The selection procedure PR_CUSTOMER_CHANGES_SELE selects all changes for each pair of customer and company code specified in the input parameter. Changes from tables CHDIR/CDPOS are taken into account; these are updates (field CHNGIND has the value U in table CDPOS). Also the field OBJCTCLAS must contain the value DEBI, and the FNAME field must have one of the following values: Name1, STRAS, PSTLZ, ORT0, or REGIO.

The execution procedure PR_CUSTOMER_CHANGES_EXEC counts the number of changes during the last 12 months, starting from the latest change selected in selection procedure. If this number is greater than or equal to the threshold specified in the input parameter NO_CUSTOMER_CHANGES, then the customer, customer name, company code, and number of changes are inserted into the result list.

Investigation and Detection Object Types

  • Investigation object type: FRA_CUST (Customer)

  • Detection object type: FRA_CUST (Customer Master Data)

ERP Tables Used

  • KNA1: General Data in Customer Master

  • KNB1: Customer Master (Company Code)

  • CDPOS: Change document items

  • CDHDR: Change document header

Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_CUSTOMER_CHANGES_SELE

SQLScript Procedure

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

Execution

PR_CUSTOMER_CHANGES_EXEC

SQLScript Procedure

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

Additional Information

PR_CUSTOMER_CHANGES_ADDINF

SQLScript Procedure

sap.hana-app.fra-suite.ord.dt.customer.masterdata.ai
Detection Method Parameters

  • NO_CUSTOMER_CHANGES: Specifies the threshold for the number of permissible changes to customer address data during the last 12 months.

Alert Messages

  • Message ID FRA_INTERNAL_AUDIT message number 087 Customer &1 changed name or location &2 times in 12 months.

    Variable &1 contains the customer name and variable &2 is the number of changes during the last 12 months.