SAP Master Data Governance, SAP S/4HANA Finance

SAP Central Finance – MDG Mapping via CDS Views

Introduction:

In Central Finance S/4 HANA, MDG mapping plays an important role in replication process. Mapping helps in defining the relation of different identifiers or objects like GL Account, Cost Centre, Company Code, etc. between source ECC systems and Central Finance. Mapping is read via Standard SAP functionality during replication. However, there is always requirement to read mapping in BADI during replication. There are different standard MDG classes used in Central Finance to read the MDG Mappings. This blog will focus on how to create ABAP CDS Views to read different types of MDG Mapping, for better performance and can be utilized for different integrations.

Approach:

Central Finance: MDG Mapping via CDS Views

There are two categories of MDG Mapping:

  1. Value Mapping
  2. Key Mapping

How to create ABAP CDS Views for Value Mapping?

A common CDS Views can be created to read the Value Mapping for all objects. Following tables can be used:

  • FINS_CFIN_MDGME – CFIN: Definition of Mapping Entities (ID / Code)
  • MDGD_CCODEMAP – Client-dependent Code Mapping
  • MDGD_CMAPCONTEXT – Specifies Mapping Contexts of code-mapping(client dependent)
  • MDG_BUS_SYS_TECH – Technical information of a Business System

Fields Usage:

MAPPING_ENTITY: MDG Mapping entity Name

LIST_AGENCY_ID: Business System

LOGSYS: Source Logical System

SRC_VAL: Source Value

TRG_VAL: Target Value

This CDS View can help in getting the mapping of all Standard and Custom Value Mappings, which are available in FINS_CFIN_MAP_MANAGE.

How to create ABAP CDS Views for Key Mapping?

In MDG Framework, key mapping tables are different for different mapping entities. In this case, we need to create CDS views per mapping entity.

Below is example of GL Account Key Mapping. Following tables can be used to get the GL Account Key Mapping:

  • UKMDB_AGCGLAM0 – UKM: Key Agency (Business System Details with reference to Mapping entity)
  • UKMDB_MGPGLAM0 – UKM: Positive Mapping Groups (Mapping key between source and target value
  • UKMDB_KEYGLAM0 – UKM: Key (Stores the actual source and target values)
  • UKMDB_SCHGLAM0 – Schema ID
  • MDG_BUS_SYS_TECH – Business System to Logical System Mapping

GLAM0 is key which is identifier for GL Account Key Mapping. Prefix of table remain same and identifier varies from one mapping entity to other. For eg, Business Partner mapping table UKMDB_AGCBNSS0, UKMDB_MGPBNSS0, UKMDB_KEYBNSS0, UKMDB_SCHBNSS0. In this case, schema table UKMDB_SCHBNSS0 helps in identifying whether mapping is for vendors, customers, etc.

Below is an example CDS View creation of Key Mapping for GL Account:

Hidden Field in above screen is Central Finance Business System and 907 is Identifier type for GL Account Mapping

Hidden Field in above screen is Central Finance Business System and 907 is Identifier type for GL Account Mapping

Fields Usage:

BUSINESS_SYSTEM: Business System

LOGSYS: Source Logical System

KOKRS_SRC: Source Controlling Area

SAKNR_SRC: Source GL Account

BUKRS_SRC: Source Company Code

KOKRS_TRG: Target Controlling Area

SAKNR_TRG: Target GL Account

BUKRS_TRG: Target Company Code

Leave a Reply

Your email address will not be published.