How to use MDC_HDB_MTC_CONFIG - Fuzzy Match Configuration

SAP Transaction Code - Details

• Transaction Code: MDC_HDB_MTC_CONFIG

  Description: Fuzzy Match Configuration

  Release: S/4HANA and ECC 6

• • Program:

    Screen: 0

    Authorization Object:

  • Development Package: MDC_ADAPTER_FUZZY_OP

    Package Description: Master Data Consolidation: Adapter for On Premise Delivery

    Parent Package: MDC_ADAPTER

  • Module/Component: CA-MDG-CMP-AF

    Description: Application Framework.

Smart SAP Assistant

• SAP Tcode: MDC_HDB_MTC_CONFIG - Fuzzy Match Configuration

  
  Overview:
  MDC_HDB_MTC_CONFIG is a SAP transaction code used to configure fuzzy matching in the SAP HANA database. Fuzzy matching is a process of finding similar strings in a database, even if they are not exact matches. This transaction code allows users to set up fuzzy matching parameters and rules for the SAP HANA database. 
  
  Functionality:
  The MDC_HDB_MTC_CONFIG transaction code allows users to configure fuzzy matching parameters and rules for the SAP HANA database. This includes setting up the minimum and maximum string length, the minimum and maximum number of characters that must match, and the type of fuzzy matching algorithm to be used. Additionally, users can specify which columns in the database should be included in the fuzzy matching process. 
  
  Step-by-step How to Use:
  1. Enter the MDC_HDB_MTC_CONFIG transaction code into the command field. 
  2. Select the “Fuzzy Match Configuration” option from the menu. 
  3. Enter the desired parameters and rules for fuzzy matching in the SAP HANA database. 
  4. Select which columns should be included in the fuzzy matching process. 
  5. Save your changes and exit the transaction code. 
  
  Other Recommendations:
  It is important to note that fuzzy matching can be a time-consuming process, so it is recommended that users only enable it when absolutely necessary. Additionally, it is important to ensure that all parameters and rules are set correctly before enabling fuzzy matching, as incorrect settings can lead to inaccurate results or even data loss.