SAP MDSE_CMP_MAP_FLD Existing field mapping for synchronized objects Table data and field list

MDSE_CMP_MAP_FLD is a standard SAP Table which is used to store Existing field mapping for synchronized objects data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The MDSE_CMP_MAP_FLD table consists of various fields, each holding specific information or linking keys about Existing field mapping for synchronized objects data available in SAP. These include CMP_ID (Compare Process), DATASET_ID (Datasets for Comparison), SOURCE_TABLE (Table Name), SOURCE_FIELD (Field Name)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

MDSE_CMP_MAP_FLD table Technical Details:

Delivery Class: E - Control table, SAP and customer have separate key areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP MDSE_CMP_MAP_FLD table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the MDSE_CMP_MAP_FLD table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
CLIENT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
CMP_ID	Compare Process	MDS_CMPT_PROCESS_ID	CHAR	10	MDSE_CMPT_PROC		CHAR10
DATASET_ID	Datasets for Comparison	MDS_CMPT_DATASET_ID	CHAR	40	MDSE_CMPT_DSET		TEXT40
SOURCE_TABLE	Table Name	MDST_SEL_TABLE_ID	CHAR	30	Assigned to domain		AS4TAB
SOURCE_FIELD	Field Name	MDST_SEL_FIELD_ID	CHAR	30	Assigned to domain		FDNAME
SOURCE_STR_FIELD	Complex structure field	MDS_CMPT_CHAR255	CHAR	255			TEXT255
TARGET_TABLE	Table Name	MDST_SEL_TABLE_ID	CHAR	30	Assigned to domain		AS4TAB
TARGET_FIELD	Field Name	MDST_SEL_FIELD_ID	CHAR	30	Assigned to domain		FDNAME
TARGET_STR_FIELD	Complex structure field	MDS_CMPT_CHAR255	CHAR	255			TEXT255

Key field

Non-key field

< MDSE_CMPT_PROC - Compare process MDSE_CMP_PREP_UI - Implementing class for preparing data to display on UI >

How do I retrieve data from SAP table MDSE_CMP_MAP_FLD using ABAP code

The following ABAP code Example will allow you to do a basic selection on MDSE_CMP_MAP_FLD to SELECT all data from the table
DATA: WA_MDSE_CMP_MAP_FLD TYPE MDSE_CMP_MAP_FLD.

SELECT SINGLE *
FROM MDSE_CMP_MAP_FLD
INTO CORRESPONDING FIELDS OF WA_MDSE_CMP_MAP_FLD
WHERE...

How to access SAP table MDSE_CMP_MAP_FLD

Within an ECC or HANA version of SAP you can also view further information about MDSE_CMP_MAP_FLD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).