SAP Master Data Tables
Are you looking for the right table related to SAP Master Data 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 (FS-CMS-MD) module.
Top 10 tables in Master Data
| Table | Description |
|---|---|
| TCMS_AST_CAT | Asset Category Details |
| CMS_AST_DOC | Asset Documents |
| TCMS_CAG_MQEXP | Exceptions for minimum risk weight |
| TCMS_AST_LTYP_T | Liquidation type (Text table) |
| TCMS_CAG_GRP | Agreement type - Relationship Group mapping |
| CMS_CAG_RBL | Collateral Agreement - Receivable Link Details |
| CMS_AST | Asset Details |
| TCMS_CAG_SA_CT_T | Special Arrangement Category Text |
| TCMS_SAS_TYP | Sub-asset type details |
| CMS_CAG_DOC | Collateral Agreement Documents |
List of tables in Master Data
| Table | Description |
|---|---|
| TCMS_AST_CAT | Asset Category Details |
| CMS_AST_DOC | Asset Documents |
| TCMS_CAG_MQEXP | Exceptions for minimum risk weight |
| TCMS_AST_LTYP_T | Liquidation type (Text table) |
| TCMS_CAG_GRP | Agreement type - Relationship Group mapping |
| CMS_CAG_RBL | Collateral Agreement - Receivable Link Details |
| CMS_AST | Asset Details |
| TCMS_CAG_SA_CT_T | Special Arrangement Category Text |
| TCMS_SAS_TYP | Sub-asset type details |
| CMS_CAG_DOC | Collateral Agreement Documents |
| CMS_ACG_PROPOSAL | Approved Coverage Gap: Proposal Details |
| CMS_PRD_BP | Product- Business Partner Relationship |
| TCMS_CAG_TYP_T | Collateral Agreement type text elements |
| TCMS_OMS_FEAT_T | Object Classification - Text |
| CMS_DEL_APPL_PAR | Temporaray table for application parameters of Deleted Links |
| CMS_ACG_CRITERIA | Approved Coverage Gap: Criteria Details |
| TCMS_CAG_RNPER | Min notice period reqd before exercising termination rights |
| TCMS_RBL_CRDSYS | name of receivable implementation |
| TCMS_CAG_SA_CT | Special Arrangement Categories |
| TCMS_CAG_ORG_T | Text table for number range group element |
| TCMS_OMS_CAT | Object Categories |
| TCMS_SAS_TYP_T | Sub-asset type (text table) |
| TCMS_CHG_TYP | Asset - Collateral agreement type relationship |
| TCMS_OMS_CAT_T | Object Category - Text Table |
| TCMS_OMS_VALTY_T | Value type texts |
| TCMS_RBL_CRDSY_T | text: name of receivable implementation |
| CMS_CAG_RULES | Rule Details |
| TCMS_AST_LTYP | Liquidation type |
| TCMS_INS_PRIOR | Insurance priority |
| TCMS_ENF_TITLE_T | Enforceable title text |
| CMS_CAG | Collateral Agreement Details |
| TCMS_PRD_CAT_T | Product Category (Text Table) |
| TCMS_INS_TYP_SET | Insurance Types-> Insurance Sets |
| TCMS_CAG_ORG | Group table for Collateral Agreement Number ranges |
| CMS_LNK_PACK_ITM | Package Parameter Item for Deleted Links report |
| TCMS_CAG_SA_ST_T | Special Arrangement Set Text |
| TCMS_AST_CAT_T | Asset Category (Text Table) |
| TCMS_TRANSACTION | Details for the CMS programs to start |
| TCMS_RBL_PROD | Receivable Product |
| TCMS_CAG_TRTYP | Termination right type |
| TCMS_COST_TYP | Cost type table |
| TCMS_CAG_BLKRS | Reason for the portion being blocked |
| TCMS_CAG_CAT_T | Collateral Agreement Category Text Elements |
| TCMS_PRD_PRD_SET | Product set table for product combinations |
| TCMS_RBL_ORG | Receivable OrgUnit |
| TCMS_OBJ_SYS_T | Object System ID (Text Elements) |
| CMS_AST_BP | Asset -Business Partner Relationship |
| CMS_CHG | Asset - Collateral Agreement Relationship |
| TCMS_RBL_SYS_A | Creditsystem attributes |
| TCMS_AST_FLDS | Table for Asset field names |
| TCMS_CAG_BREAS | Reason for the portion being blocked |
| TCMS_ACKN_DEBT_T | Abstarct acknowledgement of Debt Text |
| TCMS_OMS_FLDS | Table for Object field names |
| TCMS_CAG_CAT | Collateral Agreement Category Details |
| TCMS_ACKN_DEBT | Details for Abstract Acknowledgement of Debt |
| TCMS_BANKAREA | CMS: Bankarea |
| CMS_CAG_POR | Collateral Agreement Portion details |
| CMS_CAG_BP | Collateral Agreement-Business Partner Relationship |
| TCMS_PRD_T | Product(Text Table) |
| TCMS_OMS_FLDS_T | Text Table for Object field names |
| CMS_LNK_PACK_HDR | Package Parameter Header for Deleted Links Report |
| CMS_OMS_INS_LNK | Object - Insurance Link Data |
| TCMS_RISKCODE | Asset type RiskCode definitions |
| CMS_ACG | Approved Coverage Gap Details |
| TCMS_CAG_MQCRT_T | Minimum Qualitative Criterion (Text table) |
| TCMS_OMS_VALTY | Value type (customizing) |
| TCMS_RBL_PROD_T | Receivable product (Text table) |
| CMS_OMS_VAL_LNK | Value Link |
| TCMS_DEF_PRI_RAN | Default Values for Priority and Ranking Class |
| TCMS_COST_TYP_T | Cost type Text table |
| TCMS_AST_ORG | Group table for Asset Number ranges |
| TCMS_CAG_RNPER_T | Required notice period (Text table) |
| TCMS_PRI_RANK | Default Values for Priority and Ranking Class |
| TCMS_CAG_TR_AC | Customizing table for accessories liability |
| TCMS_CAG_SA_STTY | Special Arrangement Types in a Set |
| TCMS_CAG_SA_TY | Special Arrangement Types |
| TCMS_CRD_SYS_T | Credit System ID (Text Elements) |
| TCMS_AST_TYP | Asset Type Details |
| TCMS_LIQD_MODE | Liquidation Mode |
| TCMS_CAG_TYP | Collateral Agreement type Description |
| TCMS_CAG_MQEXP_T | Exceptions for minimum risk weight (Text table) |
| TCMS_INS_SET | Insurance Set |
| CMS_OMS_DOC_LNK | Documents Link |
| TCMS_PRD_SET_T | Product combinations (Text Table) |
| CMS_AST_HIST | Asset Value History |
| TCMS_CAG_SA_TY_T | Special Arrangement Type Text |
| TCMS_OMS_VL_VLST | Value sets |
| TCMS_CAG_GBCLN_T | Customizing table for GBC Lien |
| TCMS_CAG_MQCRT | Minimum Qualitative Criterion |
| TCMS_AST_FLIST | Table for Asset field names |
| TCMS_AST_FLDS_T | Text Table for Asset field names |
| TCMS_CAG_LSRLN_T | Customizing table for lessor lien on Collateral Agreement |
| TCMS_ENF_TITLE | Enforceable title details |
| CMS_CAG_SA | Special Arrangements |
| TCMS_CAG_GBCLN | Customizing table for GBC Lien |
| TCMS_OBJ_SYS | Object System ID - BTE Relationship |
| TCMS_AST_TYP_T | Asset Type (Text Table) |
| TCMS_PRD_CAT | Product Category Details |
| TCMS_CAG_HBRWV | Customizing table for Waiver of HBR Enforcement |
| TCMS_INS_SET_T | Insurance Set- Text Table |
| TCMS_CAG_SA_ST | Special Arrangement Set |
| TCMS_BANKAREA_T | Text: Bankarea |
| TCMS_RISKCODE_T | Risk Code(Text Table) |
| TCMS_CAG_TR_AC_T | Customizing table for accessories liability |
| TCMS_APPLICATION | Application-Transactions |
| TCMS_CAG_TRTYP_T | Termination right type |
| TCMS_PRD | Product description |
| TCMS_PRD_SET | Product Sets |
| TCMS_CRD_SYS | Credit System ID - BTE Relationship |
| TCMS_AST_ORG_T | Text table for number range group element |
| CMS_CAG_TRMCST | Termination and Cost details for Agreement/Agreement BP |
| TCMS_OMS_FEAT | Object Classification |
| TCMS_OMS_VALST | Value set |
| CMS_DEL_LNK | Deleted links for receivables and charges |
| TCMS_PRD_CAG | Product type -Collateral Agreement type Relationship |
| TCMS_CAG_BLKRS_T | Reason for portion being blocked (text table) |
| CMS_DUMMY_D_LINK | Table to indicate Migration of previously deactivated links |
| TCMS_CAG_HBRWV_T | Customizing table for Waiver of HBR Enforcement |
| CMS_OMS_BP_LNK | Business Partner Link |
| TCMS_RBL_ORG_T | Text: Receivable OrgUnit |
| TCMS_OMS_VALST_T | Value set texts |
| TCMS_CAG_LSRLN | Customizing table for lessor lien on Collateral Agreement |