SAP Master Data Synchronization Tables

Are you looking for the right table related to SAP Master Data Synchronization Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Master Data Synchronization (AP-MD-BF-SYN) module.

Top 10 tables in Master Data Synchronization

TableDescription
CVIC_CP1_LINKDepartment Nos of Contact Persons (Customer/Vendor-->BP)
BD001Business Partner: Assignment Customer - Partner
CVI_CUST_CT_LINKConnec. Between Relationship + Activity Partner for Customer
CVI_VEND_CT_LINKConnec. Between Relationship + Activity Partner for Vendor
MDSE_CMP_PREP_UIImplementing class for preparing data to display on UI
MDSE_SYNC_PROGPrograms for Initial Load
MDSC_PPO_WF_USERRecipient for Postprocessing Work Items
MDSM_SYNC_RUNTRuntime Status of Sync. Process
CVIC_MARST_LINKLink to Marital Status (Customer/Vendor-->BP)
MDSE_CTRL_OBJSynchronization Objects

List of tables in Master Data Synchronization

TableDescription
CVIC_CP1_LINKDepartment Nos of Contact Persons (Customer/Vendor-->BP)
BD001Business Partner: Assignment Customer - Partner
CVI_CUST_CT_LINKConnec. Between Relationship + Activity Partner for Customer
CVI_VEND_CT_LINKConnec. Between Relationship + Activity Partner for Vendor
MDSE_CMP_PREP_UIImplementing class for preparing data to display on UI
MDSE_SYNC_PROGPrograms for Initial Load
MDSC_PPO_WF_USERRecipient for Postprocessing Work Items
MDSM_SYNC_RUNTRuntime Status of Sync. Process
CVIC_MARST_LINKLink to Marital Status (Customer/Vendor-->BP)
MDSE_CTRL_OBJSynchronization Objects
MDSE_CMPT_DSETDataset for Comparison
CVIC_CP3_LINKAuthority of Contact Person (Customer/Vendor-->BP)
CVIC_CUST_TO_BP2Role Assignment for Customer According to BP
CVIC_LEGFORM_LNKAssign Legal Form to Legal Status for Customer Integration
MDSE_SYNC_PPOPPO Business Process
MDSE_CMPT_CTOBJTComparison Object - Texts
CVIC_CUST_TO_BP1Setting for Numbering for Customer According to BP
MDS_CMPT_DSET_UUser Datasets
MDSE_CTRL_EVENTEvents
BC001Business Partner: Assign Vendor - Partner
MDSE_CMPT_CTOBJCompare object
CVI_CUST_LINKAssignment Between Customer and Business Partner
MDSC_CMPT_DSET_AActive Datasets for Compare process
MDSE_CMPT_DSET_TDatasets for Comparison - Text
MDSC_CTRL_OPT_AActive Synchronization Options
MDSE_SYNC_SELTABTable Names for Selection
CVIC_VEND_TO_BP2Role Assignment for Vendor According to Business Partner
CVIC_CP2_LINKFunctions of Contact Person (Customer/Vendor-->BP)
CVIC_VEND_TO_BP1Setting for Numbering for Vendor According to BP
MDSE_CMPT_ID_FLField names for selection
MDSE_CTRL_OPTSynchronization Options
CVI_VEND_LINKAssignment Between Vendor and Business Partner
CVIC_MAP_CONTACTAssign Contact Persons in CVI
MDSM_SYNC_HIST_FSelection Conditions for Load History
CVIC_CP4_LINKVIP Indicator of Contact Person (Customer/Vendor-->BP)
MDSE_CMPT_PROCCompare process
MDSE_CMP_MAP_FLDExisting field mapping for synchronized objects
MDSC_CTRL_OBJPPOActivation of the PPOs in the Dialog for Platform Objects
CVIC_CCID_LINKLink Payment Cards ID (BP <--> Customer)
MDSE_SYNC_ID_FLField Names for Selection
MDSM_SYNC_HISTLoad History
MDSE_SYNC_PPOOBJPPO Objects for Synchronization Objects
MDSE_CTRL_OBJ_TSynchronization Objects - Texts
MDSC_CTRL_EVENTActive Events
MDSE_CMPT_DSET_MMap DataSet IDs to Dynpro IDs