The CMS_REL_CAL table in SAP ERP or S/4HANA stores Calculation Results related to Collateral Agreement Relation data. There are total 12 fields in CMS_REL_CAL table. The Calculation Results related to Collateral Agreement Relation table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CMS_REL_CAL table. It is in Calculation persistency (CMS_CALC_PERSISTENCY) ABAP package and is part of the Collateral Management System (FS-CMS) module.
SAP CMS_REL_CAL Table Fields
Following is the list of fields that are available in SAP CMS_REL_CAL table. The primary key fields of the table are CON_ID (Constellation GUID), REL_GUID (GUID for Table CMS_REL).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CON_ID | Constellation GUID | CMS_DTE_CON_GUID | RAW (16) | |
| REL_GUID | GUID for Table CMS_REL | CMS_DTE_REL_GUID | RAW (16) | |
| SOURCE_GUID | GUID for Table CMS_CAG | CMS_DTE_CAG_GUID | RAW (16) | |
| SRC_SEC_GUID | Relationship Source Secondary GUID | CMS_DTE_REL_SRC_SEC_GUID | RAW (16) | |
| DESTINATION_GUID | GUID for Table CMS_CAG | CMS_DTE_CAG_GUID | RAW (16) | |
| DIST_COL_VAL_C | Distributed Collateral value | CMS_DTE_CALC_DIST_CV | CURR (17) | |
| DIST_COL_VAL_M | Distributed Collateral value | CMS_DTE_CALC_DIST_CV | CURR (17) | |
| DIST_CV_PCT_C | Calculations Result as Pecentage | CMS_DTE_CALC_RES_PCT | DEC (10) | |
| DIST_CV_PCT_M | Calculations Result as Pecentage | CMS_DTE_CALC_RES_PCT | DEC (10) | |
| RESULT_CURR | Calculations Result Currency | CMS_DTE_CALC_RES_CURR | CUKY (5) | |
| RUN_ID | Run ID | CMS_DTE_RUN_ID | CHAR (40) | |
| TIMESTAMP | Change Timestamp | CMS_DTE_CHANGED_AT | DEC (15) |
