The CMS_AST_CAL table in SAP ERP or S/4HANA stores Calculation Results related to Collateral Object data. There are total 15 fields in CMS_AST_CAL table. The Calculation Results related to Collateral Object 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_AST_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_AST_CAL Table Fields
Following is the list of fields that are available in SAP CMS_AST_CAL table. The primary key fields of the table are CON_ID (Constellation GUID), AST_GUID (GUID for Table CMS_AST).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CON_ID | Constellation GUID | CMS_DTE_CON_GUID | RAW (16) | |
| AST_GUID | GUID for Table CMS_AST | CMS_DTE_AST_GUID | CMS_AST | RAW (16) |
| PARENT_GUID | Asset Guid as a parent GUID for a sub-asset | CMS_DTE_SAS_PAR_GUID | RAW (16) | |
| PARENT_ID | Asset ID | CMS_DTE_AST_ID | CHAR (40) | |
| LENDING_VALUE | Lending value Calculation for Asset | CMS_DTE_CALC_LENDING_VAL_AST | CURR (17) | |
| LENDING_VAL_PCT | Calculations Result as Pecentage | CMS_DTE_CALC_RES_PCT | DEC (10) | |
| LENDING_LIMIT | Lending Limit Calculation for Asset | CMS_DTE_CALC_LENDING_LMT_AST | CURR (17) | |
| LENDING_LMT_PCT | Calculations Result as Pecentage | CMS_DTE_CALC_RES_PCT | DEC (10) | |
| LENDING_RANGE | Lending Range calculation for Asset | CMS_DTE_CALC_LENDING_RANGE | CURR (17) | |
| LENDING_RNG_PCT | Calculations Result as Pecentage | CMS_DTE_CALC_RES_PCT | DEC (10) | |
| LIMIT_RANGE_TYP | Calcualtions Result Type | CMS_DTE_RESULT_TYP | CHAR (15) | |
| AST_DISP_DATA | Asset IF : Screen Data for Object ID | CMS_DTE_AST_IF_OBJ_ID_SCR | CHAR (90) | |
| 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) |
