Value Mapping in SAP Master Data governance MDG-M

[ArunPonnuraj]

Introduction:

In SAP, value mapping refers to the process of mapping and transforming values from one system or set of values to another within the context of master data. This is particularly important when you are integrating SAP MDG with other systems or consolidating data from multiple sources.

In this example, we will see how a value mapping can be configured in SAP MDG with respect to Material master field – Division (MARA-SPART)

Let us consider that we have a source system (MDG Hub) and material master in the source system gets replicated via IDOC to transactional SAP system. As per the requirement, the Division value 30 in the source system needs to be converted to value 35 when data gets syndicated out to the target system. 

Details:

Step 1: Identify the Global Data type for the field SPART. For this you can go to below path

MDGIMG – Central governance for Material - Maintain Fields for IDOC Value Mapping.

As given in the below screenshot, the global data type for field SPART is MDGCO_DIVISION_CODE

Step 2: Maintain Value Mapping for the global data type. Go to path

MDGIMG – Data Replication settings – Value Mapping – Maintain Value mapping

Select the Navigation button and start assigning the ‘Assign Code list’ and values

In this ‘Assign code list’ Overview screen – add a list ID/mapping ID for the list of values for which you needed the conversion to happen.

Assign the list of values in the ‘Define Value Mapping’ that needs to be converted. Internal Code value is the value that will be sent by source system and External code value is the value that will be received by the target system.

In this example, I have added only one entry as Division Code 30 from MDG needs to be converted to Code 35 in the transactional SAP system.

Step 3: Now go to the below path

MDGIMG – Data Replication settings – Value Mapping – Assign Code Lists to Elements and Systems

Add a new entry by updating the Global Data type, Business system (target system), list ID, List agency id and version id

(Note the Global Data type, List ID, List Agency ID and version ID to the be the same as added in the previous screen)

Step 4:

Now update/replicate a material with Division '30' from MDG HUB and you can see that the material gets replicated out with '35' for the business system configured in the value mapping settings.

Conclusion:

Thus, the MDG value mapping configuration helps us to integrate the MDG system with other downstream/upstream systems by mapping and transforming values as per downstream/upstream requirements

[zfiori]

Hi Community,

" Assign the list of values in the ‘Define Value Mapping’ that needs to be converted. Internal Code value is the value that will be sent by source system and External code value is the value that will be received by the target system. "

Thanks for your selfless sharing, it really help us a lot.

🙂

Regards,

ZFiori.