SAP MDSM_SYNC_HIST_F Selection Conditions for Load History Table data and field list

MDSM_SYNC_HIST_F is a standard SAP Table which is used to store Selection Conditions for Load History data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The MDSM_SYNC_HIST_F table consists of various fields, each holding specific information or linking keys about Selection Conditions for Load History data available in SAP. These include CLIENT (Client), SYNC_LOAD_GUID (Unique ID for Synchronization History), COUNTER (2 byte integer (signed)), SYNC_OBJECT (Synchronization Object)... 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. .

MDSM_SYNC_HIST_F table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP MDSM_SYNC_HIST_F 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 MDSM_SYNC_HIST_F 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
SYNC_LOAD_GUIDUnique ID for Synchronization History MDST_SYNC_LOAD_GUIDRAW16SYSUUID
COUNTER2 byte integer (signed) INT2INT25INT2
SYNC_OBJECTSynchronization Object MDS_CTRL_OBJECTCHAR10MDSE_SYNC_ID_FLMDS_CTRL_OBJECT
ID_SEL_TABLETable Name MDST_SEL_TABLE_IDCHAR30Assigned to domainAS4TAB
ID_SEL_FIELDField Name MDST_SEL_FIELD_IDCHAR30Assigned to domainFDNAME
SIGNABAP: ID: I/E (include/exclude values) TVARV_SIGNCHAR1SYCHAR01
OPTABAP: Selection option (EQ/BT/CP/...) TVARV_OPTICHAR2SYCHAR02
VALUE_LOW'Generic' SELECT-OPTION for Dynamic Selections RSDSSELOP_CHAR45RSDSSELOPT
VALUE_HIGH'Generic' SELECT-OPTION for Dynamic Selections RSDSSELOP_CHAR45RSDSSELOPT

Key field Non-key field



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

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

SELECT SINGLE *
FROM MDSM_SYNC_HIST_F
INTO CORRESPONDING FIELDS OF WA_MDSM_SYNC_HIST_F
WHERE...

How to access SAP table MDSM_SYNC_HIST_F

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

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