Specifying DQ Measurands: An Example

February 10, 2010 by · 1 Comment
Filed under: English 

For German readers: Es gibt eine deutsche Version dieses Artikels.

In the last blog post, the elements of a DQ Measurand specification were discussed. These elements will be illustrated with an example. 

1. Name

The following DQ Measurand will be detailed:

  • Measurand 1: Partners without a postal address

Some other, simple DQ Measurands could be the following:

  • Measurand 2: Potential partner duplicates
  • Measurand 3: Active home finance loans, where there is no property value for the real estate object used as collateral

2. DQ Rule

Business partners (records in the table BUT000) should be connected to an address (table ADRC) using the table BUT021_FS (using address kind BUT021_FS-ADRVERW = "Postal"). This measurand consists of partners without a link in the BUT021_FS or without a valid record in BUT021_FS (current date and between DATE_FROM and DATE_TO). This rule is only valid for partners that have taken out a loan. (For these partners, there is a record in the table VDGPO with SNUMOBJ = ‘VD’ and ROLETYP = "TR0100".)

3. Impact of Rule Violations

  • Partners without a valid address cannot be contacted via normal mail channels (e.g. for sales information, event invitations, etc.) – broken process.
  • When a partner without an address is to be dunned[?], the address must be manually – broken process, resulting in additional effort/cost.
  • Location is an important part of rating a customer. The risk analysis of a partner without an address is therefore inaccurate – skewed performance indicator.
  • In Germany (as probably in most countries), money transfers out of the country are highly regulated and must be reported to the authorities. Without a valid address this cannot be properly determined – violation of regulation.

4. Root Causes

The following causes have been identified:

  1. Addresses for a partner are entered in the SAP Business Partner (transactions BUP1 and BUP2). One address for a partner has to be assigned as a “postal address” on the "Addresses" tab. Sometimes, when entering a new partner, users forget to assign a “postal address”.
  2. In addition, the use of an address as a “postal address” is time dependent, i.e. you can enter a start and end date. When it is known that a partner will move in the near future (which is normal when a customer takes out a real estate loan), the “postal address” is assigned with an end date, but without entering the new address which is valid after the end date. When the end date is reached and no new postal address is assigned, the partner will not have a valid postal address.

5. Correction

Depending on the situation and causes as noted above, the following correction procedures shall be applied:

  1. When there is no postal address at all, then a user in Division shall use the SAP transaction BUP2 to assign the default address on the tab "Address list" of a partner as a postal address without a specific end date.
  2. If a postal address was entered but lost its validity, the user shall check whether a new default address has been entered. If that is the case this new default address shall be assigned as a postal address as well.
    If no new default address was entered, the customer shall be contacted to determine the new address and entered as described above. If necessary, the default address shall be changed as well.