SAP Collateral Management System Tables

Are you looking for the right table related to SAP Collateral Management System 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 Collateral Management System (FS-CMS) module.

Top 10 tables in Collateral Management System

TableDescription
CMS_ARC_RIGRightsArchiving table: Includes claims and patents also
TCMS_CTRLCMS: UI Controller
CMS_SYN_PACK_HDRPackage Parameter Header for RBL Synchronization Report
TCMS_LIQD_MODE_TLiquidation Mode(Text Table)
TCMS_PCN_CR_TYChange Request Type
TCMS_PCN_PLPRC_TPlausibility processor texts
CMS_ADORG_STSDefine Status Mapping
CMS_BLK_APPL_PARTemporaray table for application parameters of Blocking
TCMS_REL_CATRelationship category details
TCMS_PCN_PLPlausibility Check

List of tables in Collateral Management System

TableDescription
CMS_ARC_RIGRightsArchiving table: Includes claims and patents also
TCMS_CTRLCMS: UI Controller
CMS_SYN_PACK_HDRPackage Parameter Header for RBL Synchronization Report
TCMS_LIQD_MODE_TLiquidation Mode(Text Table)
TCMS_PCN_CR_TYChange Request Type
TCMS_PCN_PLPRC_TPlausibility processor texts
CMS_ADORG_STSDefine Status Mapping
CMS_BLK_APPL_PARTemporaray table for application parameters of Blocking
TCMS_REL_CATRelationship category details
TCMS_PCN_PLPlausibility Check
TCMS_TSK_PRTY_TTask Priroity Text
TCMS_REL_GRPRelationship Group Table
CMS_ARC_RBLReceivables Archiving Table
TCMS_PCN_PLPRCProcess Object and Plausibility Processor relation
TCMS_PCN_OBJ_SProcess Control Object: Mode Attributes
TCMS_CPY_GRPData group ID to be defined by SAP
TCMS_DOC_SET_TDocument set (text table)
TCMS_ATT_ID_CT_TAttribute Indicator category -text table
TCMS_CPY_GRP_TText table for the Data group ID table
TCMS_PCN_A_MSGMessage sverity change for business activity
TCMS_LOC_SORTSorting order table for Locator Search Applications
TCMS_PCN_CR_STChange Request Type: Status Transition
TCMS_PCN_PLMSGMessages associated to Plausibility
TCMS_PCN_PLSET_TPlausibility Set definition texts
TCMS_DOC_SETDefine Document Sets
TCMS_FSBP_APPL_TText table for TCMS_EXT_APPL
CMS_ADORG_OBJObject Details Of Admin Org Unit Change Process
TCMS_IFL_MCLASSMapping of product category and classes
TCMS_REL_TYPRelationship type description
TCMS_PCN_ACTVTBusiness activity definition
TCMS_PCN_ACTVT_TBusiness activity definition texts
TCMS_BPF_SET_TBusiness Partner Function Sets
CMS_BUS_PROCES_TText Table for CMS_BUS_PROCESS
TCMS_FSBP_APPLApplication that interface with CMS and passes FSBP-data
CMS_RBL_CALCalculation Results related to Receivables in Constellation
TCMS_COR_TYP_GRPCorrespondence type grouping
TCMS_PCN_SSTTRActivity categories for a Process object
TCMS_IFL_MPRODCMS-CML product linking
TCMS_RFC_APPL_TRFC Applications
TCMS_TSK_TYPTask Type
TCMS_TSK_STAT_TTask Status Text
CMS_TSKTasks
CMS_ARC_RE_OBJReal Estate Archiving Table
TCMS_APL_SRVApplication Services
TCMS_BDT_VARBDT Variant
CMS_BP_CALBusiness Partners in Constellation
CMS_ARC_SHPShip Archiving Table
TCMS_PCN_A_CAT_TActivity Category texts
TCMS_BPFBusiness Partner Functions ( Customizing)
TCMS_PCN_A_CATActivity category
TCMS_FSBP_MROLEInvalid / Replaced in Rel3.0 by TCMS_FSBP_R2F
TCMS_COR_GRPCorrespondence group definition(customizing)
CMS_SYN_APPL_PARTemporaray table for application parameters of RBL Sync.
CMS_AST_CALCalculation Results related to Collateral Object
CMS_BUS_PROCESSSystem Customizing for Business Process
TCMS_REL_TYP_GRPRelationship Type - Group Mapping
TCMS_PCN_A_SSTTRSystem Status Transition for an Activity
CMS_CON_CALCCalculation results of CMS Constellation
CMS_RELRelationship details
TCMS_RFC_DESTRFC Destinations
TCMS_TSK_STATTask Status
TCMS_CPY_GRP_APLData groups associated with Application
TCMS_ATT_ID_CTAttribute Indicator category
CMS_MY_OBJMy Objects (Favorites and Recent Objects)
TCMS_ATT_ID_TYAttribute Indicator type
TCMS_COR_GRP_TCorrespondence group(text table)
CMS_CAG_RBL_CALCalculation Results relatedto CAG_RBL Link in Constellation
CMS_PROC_RUNRun ID of a CMS Constellation in a process
TCMS_PCN_USTTRUser status transition definition
TCMS_PCN_CKYProcess control key
TCMS_CALC_PROCCalculation results types used by Business Processes
TCMS_BDT_VR_APApplications for a BDT variant
TCMS_LOC_SASearch Application Details
TCMS_BPF_SETBusiness Partner Function Sets
TCMS_IFL_MORGOrganisation units and company codes
CMS_AGRMT_CALCalculation Results related to Collateral Agreement
CMS_ADORG_MAPAssign Status Mapping To Process Control Areas
TCMS_IFL_MORGUOrganisation units and company codes
TCMS_MSG_CATCustomizing table for message category.
TCMS_PCN_CKY_TProcess control key texts
CMS_RBL_SYNCRBL Sync Data
TCMS_ADORG_MAPAssign Status Mapping To Process Control Areas
TCMS_BPF_CAT_TBusiness Partner Function Category (Text table)
CMS_ARC_SEC_ACCSecurities Account Archiving Table
TCMS_BDT_FC_PLPlausibility checks on FCODE
CMS_ARC_MIG_CHKTable to check of data migration from DB to Arc DB table
TCMS_DOC_TYPDocument type Description
TCMS_BPF_BPF_SETBusiness Partner Function Sets
TCMS_PCN_OBJ_TProcess object category texts
TCMS_FSBP_ADRTYPFSBP: Address type for use in correspondence
CMS_REL_CALCalculation Results related to Collateral Agreement Relation
TCMS_VAL_MAPCustomizing table for value mapping
TCMS_PCN_PLSETPlauisbility set definition
CMS_ARC_CAGCAG Archiving table
TCMS_DOC_TYP_TDocument type text elements
TCMS_PCN_FCODEFCODE exclusion set definition for activity
TCMS_RFC_APPLRFC Applications
CMS_CHG_CALCalculation Results related to Charge in Constellation
TCMS_PCN_A_CTMActivity Categories for Process Mode
TCMS_BPF_TBusiness Partner Function Texts
TCMS_REL_GRP_TRealtionship Group (Text Table)
TCMS_PCN_A_GRP_TBusiness activity group text definition
TCMS_FSBP_R2FMapping FSBP-Role to CMS-Partner Function
TCMS_REL_OBJ_TRelationship Object (Text Table)
TCMS_CLNTCMS: Clientdependent Customizing Data
TCMS_ORG_PROCCMS: Attributes of Administrative OrgUnit
TCMS_BDT_FSTATField Status Variant
CMS_SYN_PACK_ITMPackage Parameter Item for RBL Synchronization report
TCMS_PCN_AREACMS: Process Control Area
TCMS_BDT_V_PLPlausibility checks for view
TCMS_PCN_OBJ_MProcess Control Object: Mode Attributes
TCMS_IF_FIELDCustomizing table for Interface fields
TCMS_BDT_FSTAT_TField Status Variant (Text Table)
CMS_ADORG_ADMAdmin data of Admin Org Unit Change process
TCMS_PCN_PL_TPlausibility definition texts
TCMS_PCN_PLSPLPlausibility set- Plausibility relation
TCMS_REL_OBJRelationship Object
TCMS_DOC_TYP_SETDefine relationship between Document sets and types
TCMS_CD_BUSINFOClassification of a change to a business object - internal
TCMS_TSK_TYP_TTask Type Text
CMS_PCN_CRChange Requests
TCMS_ATT_ID_TY_TAttribute Indicator type - Text Table
TCMS_BDT_VAR_TText Table for BDT Variant
TCMS_PCN_CKY_BProcess control key Behavior
TCMS_REL_TYP_TRelationship type (Text table)
TCMS_ADORG_STSDefine Status Mapping
CMS_ARC_INSInsurance Archiving table
TCMS_PCN_OBJProcess Object
TCMS_PCN_CR_TY_TTexts for Change Request Type
TCMS_BPF_CATBusiness Partner Function Category
TCMS_PCN_AREA_TProcess Control Area Texts
CMS_BLK_PACK_HDRPackage Parameter Header for Blocking Report
CMS_ARC_MOVABLESMovables Archiving Table
TCMS_REL_CAT_TRelationship Category (Text table)
TCMS_PCN_CR_CTChange Request Category
CMS_BLK_PACK_ITMPackage Parameter Item for Blocking report
TCMS_SCHEME_CRMSchema
TCMS_TSK_PRTYTask Priroity
CMS_CON_OBJAgreements in a constellation
TCMS_PCN_CR_CT_TTexts for Change Request Category
CMS_CON_VERSIONVersion of CMS constellation