{"id":68,"date":"2010-02-10T15:00:00","date_gmt":"2010-02-10T14:00:00","guid":{"rendered":"http:\/\/www.smartersoftware.de\/wordpress\/english\/specifying-dq-measurands-an-example.html"},"modified":"2010-03-29T06:53:49","modified_gmt":"2010-03-29T05:53:49","slug":"specifying-dq-measurands-an-example","status":"publish","type":"post","link":"http:\/\/www.smartersoftware.de\/wordpress\/2010\/02\/specifying-dq-measurands-an-example\/","title":{"rendered":"Specifying DQ Measurands: An Example"},"content":{"rendered":"
\n

For German readers: Es gibt eine deutsche Version dieses Artikels<\/a>.<\/p>\n<\/blockquote>\n

In the last blog post, the elements of a DQ Measurand specification were discussed. These elements will be illustrated with an example.  <\/p>\n

1. Name<\/h2>\n

The following DQ Measurand will be detailed:<\/p>\n

    \n
  • Measurand 1: Partners without a postal address <\/li>\n<\/ul>\n

    Some other, simple DQ Measurands could be the following:<\/p>\n

      \n
    • Measurand 2: Potential partner duplicates <\/li>\n
    • Measurand 3: Active home finance loans, where there is no property value for the real estate object used as collateral <\/li>\n<\/ul>\n

      2. DQ Rule<\/h2>\n

      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".) <\/p>\n

      3. Impact of Rule Violations<\/h2>\n
        \n
      • Partners without a valid address cannot be contacted via normal mail channels (e.g. for sales information, event invitations, etc.) \u2013 broken process. <\/li>\n
      • When a partner without an address is to be dunned[?], the address must be manually \u2013 broken process, resulting in additional effort\/cost. <\/li>\n
      • Location is an important part of rating a customer. The risk analysis of a partner without an address is therefore inaccurate \u2013 skewed performance indicator. <\/li>\n
      • 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. <\/li>\n<\/ul>\n

        4. Root Causes <\/h2>\n

        The following causes have been identified:<\/p>\n

          \n
        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 \u201cpostal address\u201d on the "Addresses" tab. Sometimes, when entering a new partner, users forget to assign a \u201cpostal address\u201d. <\/li>\n
        2. In addition, the use of an address as a \u201cpostal address\u201d 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 \u201cpostal address\u201d 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. <\/li>\n<\/ol>\n

          5. Correction<\/h2>\n

          Depending on the situation and causes as noted above, the following correction procedures shall be applied:<\/p>\n

            \n
          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. <\/li>\n
          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. <\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

            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 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[22,27],"class_list":["post-68","post","type-post","status-publish","format-standard","hentry","category-english","tag-dqmeasurand","tag-example"],"_links":{"self":[{"href":"http:\/\/www.smartersoftware.de\/wordpress\/wp-json\/wp\/v2\/posts\/68","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.smartersoftware.de\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.smartersoftware.de\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.smartersoftware.de\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.smartersoftware.de\/wordpress\/wp-json\/wp\/v2\/comments?post=68"}],"version-history":[{"count":1,"href":"http:\/\/www.smartersoftware.de\/wordpress\/wp-json\/wp\/v2\/posts\/68\/revisions"}],"predecessor-version":[{"id":133,"href":"http:\/\/www.smartersoftware.de\/wordpress\/wp-json\/wp\/v2\/posts\/68\/revisions\/133"}],"wp:attachment":[{"href":"http:\/\/www.smartersoftware.de\/wordpress\/wp-json\/wp\/v2\/media?parent=68"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.smartersoftware.de\/wordpress\/wp-json\/wp\/v2\/categories?post=68"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.smartersoftware.de\/wordpress\/wp-json\/wp\/v2\/tags?post=68"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}