Show TOC

Background documentationConfigure Standardization

 

Within the process step standardization, address data is enriched and normalized by the system. In addition a check ensures that a specific address really exist:

Example Example

  • Enrichment: A record only contains the postal code 69190. The corresponding city Walldorf is added.

  • Normalization: Baker Str, is converted to Baker Street

End of the example.

Activities

To configure the standardization for MDG, consolidation, run the Customizing activity under Start of the navigation path Master Data Governance Next navigation step Consolidation and Mass Processing Next navigation step Configure Standardization End of the navigation path:

  1. To configure the number of parallel processes run the Customizing activity Configure Parallelization for Standardization.

    Adapting the number of parallel processes can improve the performance of the consolidation process.

    Note Note

    To use parallelization in SAP MDG, consolidation you have to set up an RFC destination:

    • To create the bgRFC inbound destination manually, the authorization object S_BGRFC with activity 02 and type 07 has to be assigned to you.

      1. Run transaction SBGRFCCONF.

      2. On the Define Inbound Dest. tab choose Create.

      3. Enter a name in the Destination field.

      4. Enter MDC_QUEUE_ in the Prefixes field.

        If you use a queue prefix other than MDC_QUEUE_ this has to be entered in the corresponding field as described below.

      5. On the Scheduler: Destination tab select the destination by double clicking on it.

        If the destination does not exists, proceed as described:

        1. Choose Create and on the bgRFC Configuration dialog box select Inbound.

        2. Enter the destination name into the Destination field and leave all other values as defaulted.

      6. In the Open Connections field enter the number of allowed parallel processes or queues you wish to be managed by this destination. This number also specifies the maximum of parallel processes to be configured during the step configuration.

    • If you do not create the bgRFC inbound destination manually the very first consolidation process will trigger the automatic creation of the inbound destination under prerequisite that the authorization object S_BGRFC with full authorization is assigned to workflow system user.

    For more information see http://help.sap.com/saphelp_nw70ehp2/helpdata/de/f0/225c3c60065627e10000000a114084/content.htmInformation published on SAP site

    End of the note.

    1. Choose New Entries.

    2. Enter a Configuration ID and the corresponding description

    3. In the Number of Processes field enter the number of processes you want to be processed in parallel.

    4. If required enter the Prefix for Queue Name.

      Note Note

      If you use queue prefixes other than MDC_QUEUE_ these have to be entered in the Prefix for Queue Name field.

      End of the note.

  2. To configure the Business Objects Data Services for BAS Adapter, see the documentation of the Customizing activity Configure Business Objects Data Services for BAS Adapter.

    Check the Customizing settings under SAP BusinessObjects Data Quality Management and adapt if required.

  3. To import the predefined settings for SAP HANA smart data quality run the Customizing activity Import Predefined Settings for SAP HANA Smart Data Quality.

    In this Customizing activity, you can activate the BC Set CA-MDG-EE-BP_IMHANA_C01 MDG-BP Consolidation: IM in Hanacontaining predefined sets of table entries, that are required to run the process steps standardization and matching with the adapters for the SAP HANA smart data quality.

    The BC Set contains settings for the tables listed below. You can use transaction SM30 to configure some of these tables to fulfill your requirements. Be aware, that some settings are not to be changed. For details, see the description for each table.

    Standardization and Matching

    • SIMDQ_INP_FILTER IM in HANA Filter for input

      Settings to specify filters for standardization and matching. Records can be filtered out and do not take part in the corresponding process step.

      Note Note

      To ensure the correct processing of the consolidation process, the settings delivered by SAP are not to be changed.

      End of the note.

    Standardization

    • SIMDQ_ADDR_STG IM in HANA address related settings

      Settings to specify the address standardization, for example address formats such as Woodstr. versus Wood Street.

    • SIMDQ_OTHR_STG IM in HANA non-address settings

      Note Note

      The settings delivered by SAP are required for technical reasons. Changing these settings does not have any impact.

      End of the note.

    Matching

    • SIMDQ_CMPRSRC IM in HANA compare source settings for Match Policy

      Settings to specify the data sources to be considered for matching. The delivered settings compare process data with process and active data and do not compare active data with each other.

      Note Note

      To ensure the correct processing of the consolidation process, the settings delivered by SAP are not to be changed.

      End of the note.

    • SIMDQ_MTCADDRSTG IM in HANA address settings for the Match Policy

      Settings to specify the matching for addresses, such as the threshold.

    • SIMDQ_MTCFIRMSTG IM in HANA firm settings for the Match Policy

      Settings to specify the matching for firms, such as the threshold.

    • SIMDQ_MTCPERSTG IM in HANA person settings for the Match Policy

      Settings to specify the matching for persons, such as the threshold.

    • SIMDQ_MTCCSTMSTG IM in HANA custom component settings for Custom Match Policy

      Settings to specify the matching for ID numbers.

    1. To adapt the predefined settings, run transaction SM30.

    2. Enter the table in the Table/View field and choose Edit.