CMS_CALC_OBJ
Calculation Results related to CMS Objects
CMS_CALC_OBJ is an SAP database table in S/4HANA. Calculation Results related to CMS Objects. It contains 79 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CollateralObjectCalcData | view | from | BASIC | Calculation Result for CMS Object |
Fields (79)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | obj_guid | cms_dte_bii_obj_guid | OBJ_GUID | |||
| obj_typ | cms_dte_calc_obj_typ | Object Type | ||||
| con_guid | cms_dte_con_guid | CON GUID | ||||
| ast_typ | cms_dte_ast_typ | Asset Type | ||||
| parent_guid | cms_dte_sas_par_guid | PARENT_GUID | ||||
| result_curr | cms_dte_calc_res_curr | Result Currency | ||||
| asset_value | cms_dte_ast_value | Value | ||||
| lending_value | cms_dte_calc_lending_val_ast | Lending Val | ||||
| lending_limit1 | cms_dte_calc_lending_lmt_ast | Lending Lmt | ||||
| lending_limit2 | cms_dte_calc_lending_lmt_ast | Lending Lmt | ||||
| lending_limit3 | cms_dte_calc_lending_lmt_ast | Lending Lmt | ||||
| lending_limit4 | cms_dte_calc_lending_lmt_ast | Lending Lmt | ||||
| lending_limit5 | cms_dte_calc_lending_lmt_ast | Lending Lmt | ||||
| lending_range1 | cms_dte_calc_lending_range | Lending.Rng | ||||
| lending_range2 | cms_dte_calc_lending_range | Lending.Rng | ||||
| lending_range3 | cms_dte_calc_lending_range | Lending.Rng | ||||
| lending_range4 | cms_dte_calc_lending_range | Lending.Rng | ||||
| lending_range5 | cms_dte_calc_lending_range | Lending.Rng | ||||
| prt_len_val | cms_dte_calc_lending_val_ast | Lending Val | ||||
| prt_len_lim1 | cms_dte_calc_lending_lmt_ast | Lending Lmt | ||||
| prt_len_lim2 | cms_dte_calc_lending_lmt_ast | Lending Lmt | ||||
| prt_len_lim3 | cms_dte_calc_lending_lmt_ast | Lending Lmt | ||||
| prt_len_lim4 | cms_dte_calc_lending_lmt_ast | Lending Lmt | ||||
| prt_len_lim5 | cms_dte_calc_lending_lmt_ast | Lending Lmt | ||||
| prt_len_rng1 | cms_dte_calc_lending_range | Lending.Rng | ||||
| prt_len_rng2 | cms_dte_calc_lending_range | Lending.Rng | ||||
| prt_len_rng3 | cms_dte_calc_lending_range | Lending.Rng | ||||
| prt_len_rng4 | cms_dte_calc_lending_range | Lending.Rng | ||||
| prt_len_rng5 | cms_dte_calc_lending_range | Lending.Rng | ||||
| free_lending_limit_c | cms_dte_calc_lending_lmt_ast | Lending Lmt | ||||
| free_lending_limit_m | cms_dte_calc_lending_lmt_ast | Lending Lmt | ||||
| free_lending_limit_pct_c | cms_dte_calc_res_pct | Result Pct | ||||
| free_lending_limit_pct_m | cms_dte_calc_res_pct | Result Pct | ||||
| credit_system | cms_dte_rbl_crdsys | Credit system | ||||
| rbl_id | cms_dte_rbl_id | Rbl ID | ||||
| coverage_gap_c | cms_dte_calc_coverage_gap | Cov. Gap | ||||
| coverage_gap_m | cms_dte_calc_coverage_gap | Cov. Gap | ||||
| cov_gap_pct_c | cms_dte_calc_res_pct | Result Pct | ||||
| cov_gap_pct_m | cms_dte_calc_res_pct | Result Pct | ||||
| coll_ratio_pct_c | cms_dte_calc_col_ratio | Collat.Ratio | ||||
| coll_ratio_pct_m | cms_dte_calc_col_ratio | Collat.Ratio | ||||
| coll_value_c | cms_dte_calc_coll_value | Coll.Value | ||||
| coll_value_m | cms_dte_calc_coll_value | Coll.Value | ||||
| coll_value_pct_c | cms_dte_calc_res_pct | Result Pct | ||||
| coll_value_pct_m | cms_dte_calc_res_pct | Result Pct | ||||
| lend_val_grt_c | cms_dte_calc_lending_val_grt | Lending Val | ||||
| lend_val_grt_m | cms_dte_calc_lending_val_grt | Lending Val | ||||
| lnd_vl_grt_pct_c | cms_dte_calc_res_pct | Result Pct | ||||
| lnd_vl_grt_pct_m | cms_dte_calc_res_pct | Result Pct | ||||
| lend_lmt_grt_c | cms_dte_calc_lending_lmt_grt | Lending Lmt | ||||
| lend_lmt_grt_m | cms_dte_calc_lending_lmt_grt | Lending Lmt | ||||
| lend_lmt_grt_pct_c | cms_dte_calc_res_pct | Result Pct | ||||
| lend_lmt_grt_pct_m | cms_dte_calc_res_pct | Result Pct | ||||
| ltov_wrt_cag_c | cms_dte_calc_ltov_cag_amt | LTOV ratio | ||||
| ltov_wrt_cag_m | cms_dte_calc_ltov_cag_amt | LTOV ratio | ||||
| ltov_cag_pct_c | cms_dte_calc_ltov_cag_pct | LTOV ratio | ||||
| ltov_cag_pct_m | cms_dte_calc_ltov_cag_pct | LTOV ratio | ||||
| ltov_wrt_pr_c | cms_dte_calc_ltov_pr_amt | LTOV ratio | ||||
| ltov_wrt_pr_m | cms_dte_calc_ltov_pr_amt | LTOV ratio | ||||
| ltov_pr_pct_c | cms_dte_calc_ltov_pr_pct | LTOV ratio | ||||
| ltov_pr_pct_m | cms_dte_calc_ltov_pr_pct | LTOV ratio | ||||
| ltov_wrt_rbl_c | cms_dte_calc_ltov_rbl_amt | LTOV ratio | ||||
| ltov_wrt_rbl_m | cms_dte_calc_ltov_rbl_amt | LTOV ratio | ||||
| ltov_rbl_pct_c | cms_dte_calc_ltov_rbl_pct | LTOV ratio | ||||
| ltov_rbl_pct_m | cms_dte_calc_ltov_rbl_pct | LTOV ratio | ||||
| dist_cv_c | cms_dte_calc_dist_cv | Dist. Coll val | ||||
| dist_cv_m | cms_dte_calc_dist_cv | Dist. Coll val | ||||
| dist_cv_pct_c | cms_dte_calc_res_pct | Result Pct | ||||
| dist_cv_pct_m | cms_dte_calc_res_pct | Result Pct | ||||
| cov_ratio_pct_c | cms_dte_calc_cov_ratio_pct | Coverage ratio | ||||
| cov_ratio_pct_m | cms_dte_calc_cov_ratio_pct | Coverage ratio | ||||
| coll_right_c | cms_dte_calc_coll_right | Coll.Right | ||||
| coll_right_m | cms_dte_calc_coll_right | Coll.Right | ||||
| coll_rgt_pct_c | cms_dte_calc_res_pct | Result Pct | ||||
| coll_rgt_pct_m | cms_dte_calc_res_pct | Result Pct | ||||
| last_chg_by | cms_dte_last_chng_user | Last Changed by | ||||
| last_chg_date | cms_dte_last_chng_date | Last Changed on | ||||
| last_chg_time | cms_dte_last_chng_time | Last Changed at |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Calculation Results related to CMS Objects
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_CALC_OBJ (
MANDT, -- Client [mandt]
OBJ_GUID, -- OBJ_GUID [cms_dte_bii_obj_guid]
OBJ_TYP, -- Object Type [cms_dte_calc_obj_typ]
CON_GUID, -- CON GUID [cms_dte_con_guid]
AST_TYP, -- Asset Type [cms_dte_ast_typ]
PARENT_GUID, -- PARENT_GUID [cms_dte_sas_par_guid]
RESULT_CURR, -- Result Currency [cms_dte_calc_res_curr]
ASSET_VALUE, -- Value [cms_dte_ast_value]
LENDING_VALUE, -- Lending Val [cms_dte_calc_lending_val_ast]
LENDING_LIMIT1, -- Lending Lmt [cms_dte_calc_lending_lmt_ast]
LENDING_LIMIT2, -- Lending Lmt [cms_dte_calc_lending_lmt_ast]
LENDING_LIMIT3, -- Lending Lmt [cms_dte_calc_lending_lmt_ast]
LENDING_LIMIT4, -- Lending Lmt [cms_dte_calc_lending_lmt_ast]
LENDING_LIMIT5, -- Lending Lmt [cms_dte_calc_lending_lmt_ast]
LENDING_RANGE1, -- Lending.Rng [cms_dte_calc_lending_range]
LENDING_RANGE2, -- Lending.Rng [cms_dte_calc_lending_range]
LENDING_RANGE3, -- Lending.Rng [cms_dte_calc_lending_range]
LENDING_RANGE4, -- Lending.Rng [cms_dte_calc_lending_range]
LENDING_RANGE5, -- Lending.Rng [cms_dte_calc_lending_range]
PRT_LEN_VAL, -- Lending Val [cms_dte_calc_lending_val_ast]
PRT_LEN_LIM1, -- Lending Lmt [cms_dte_calc_lending_lmt_ast]
PRT_LEN_LIM2, -- Lending Lmt [cms_dte_calc_lending_lmt_ast]
PRT_LEN_LIM3, -- Lending Lmt [cms_dte_calc_lending_lmt_ast]
PRT_LEN_LIM4, -- Lending Lmt [cms_dte_calc_lending_lmt_ast]
PRT_LEN_LIM5, -- Lending Lmt [cms_dte_calc_lending_lmt_ast]
PRT_LEN_RNG1, -- Lending.Rng [cms_dte_calc_lending_range]
PRT_LEN_RNG2, -- Lending.Rng [cms_dte_calc_lending_range]
PRT_LEN_RNG3, -- Lending.Rng [cms_dte_calc_lending_range]
PRT_LEN_RNG4, -- Lending.Rng [cms_dte_calc_lending_range]
PRT_LEN_RNG5, -- Lending.Rng [cms_dte_calc_lending_range]
FREE_LENDING_LIMIT_C, -- Lending Lmt [cms_dte_calc_lending_lmt_ast]
FREE_LENDING_LIMIT_M, -- Lending Lmt [cms_dte_calc_lending_lmt_ast]
FREE_LENDING_LIMIT_PCT_C, -- Result Pct [cms_dte_calc_res_pct]
FREE_LENDING_LIMIT_PCT_M, -- Result Pct [cms_dte_calc_res_pct]
CREDIT_SYSTEM, -- Credit system [cms_dte_rbl_crdsys]
RBL_ID, -- Rbl ID [cms_dte_rbl_id]
COVERAGE_GAP_C, -- Cov. Gap [cms_dte_calc_coverage_gap]
COVERAGE_GAP_M, -- Cov. Gap [cms_dte_calc_coverage_gap]
COV_GAP_PCT_C, -- Result Pct [cms_dte_calc_res_pct]
COV_GAP_PCT_M, -- Result Pct [cms_dte_calc_res_pct]
COLL_RATIO_PCT_C, -- Collat.Ratio [cms_dte_calc_col_ratio]
COLL_RATIO_PCT_M, -- Collat.Ratio [cms_dte_calc_col_ratio]
COLL_VALUE_C, -- Coll.Value [cms_dte_calc_coll_value]
COLL_VALUE_M, -- Coll.Value [cms_dte_calc_coll_value]
COLL_VALUE_PCT_C, -- Result Pct [cms_dte_calc_res_pct]
COLL_VALUE_PCT_M, -- Result Pct [cms_dte_calc_res_pct]
LEND_VAL_GRT_C, -- Lending Val [cms_dte_calc_lending_val_grt]
LEND_VAL_GRT_M, -- Lending Val [cms_dte_calc_lending_val_grt]
LND_VL_GRT_PCT_C, -- Result Pct [cms_dte_calc_res_pct]
LND_VL_GRT_PCT_M, -- Result Pct [cms_dte_calc_res_pct]
LEND_LMT_GRT_C, -- Lending Lmt [cms_dte_calc_lending_lmt_grt]
LEND_LMT_GRT_M, -- Lending Lmt [cms_dte_calc_lending_lmt_grt]
LEND_LMT_GRT_PCT_C, -- Result Pct [cms_dte_calc_res_pct]
LEND_LMT_GRT_PCT_M, -- Result Pct [cms_dte_calc_res_pct]
LTOV_WRT_CAG_C, -- LTOV ratio [cms_dte_calc_ltov_cag_amt]
LTOV_WRT_CAG_M, -- LTOV ratio [cms_dte_calc_ltov_cag_amt]
LTOV_CAG_PCT_C, -- LTOV ratio [cms_dte_calc_ltov_cag_pct]
LTOV_CAG_PCT_M, -- LTOV ratio [cms_dte_calc_ltov_cag_pct]
LTOV_WRT_PR_C, -- LTOV ratio [cms_dte_calc_ltov_pr_amt]
LTOV_WRT_PR_M, -- LTOV ratio [cms_dte_calc_ltov_pr_amt]
LTOV_PR_PCT_C, -- LTOV ratio [cms_dte_calc_ltov_pr_pct]
LTOV_PR_PCT_M, -- LTOV ratio [cms_dte_calc_ltov_pr_pct]
LTOV_WRT_RBL_C, -- LTOV ratio [cms_dte_calc_ltov_rbl_amt]
LTOV_WRT_RBL_M, -- LTOV ratio [cms_dte_calc_ltov_rbl_amt]
LTOV_RBL_PCT_C, -- LTOV ratio [cms_dte_calc_ltov_rbl_pct]
LTOV_RBL_PCT_M, -- LTOV ratio [cms_dte_calc_ltov_rbl_pct]
DIST_CV_C, -- Dist. Coll val [cms_dte_calc_dist_cv]
DIST_CV_M, -- Dist. Coll val [cms_dte_calc_dist_cv]
DIST_CV_PCT_C, -- Result Pct [cms_dte_calc_res_pct]
DIST_CV_PCT_M, -- Result Pct [cms_dte_calc_res_pct]
COV_RATIO_PCT_C, -- Coverage ratio [cms_dte_calc_cov_ratio_pct]
COV_RATIO_PCT_M, -- Coverage ratio [cms_dte_calc_cov_ratio_pct]
COLL_RIGHT_C, -- Coll.Right [cms_dte_calc_coll_right]
COLL_RIGHT_M, -- Coll.Right [cms_dte_calc_coll_right]
COLL_RGT_PCT_C, -- Result Pct [cms_dte_calc_res_pct]
COLL_RGT_PCT_M, -- Result Pct [cms_dte_calc_res_pct]
LAST_CHG_BY, -- Last Changed by [cms_dte_last_chng_user]
LAST_CHG_DATE, -- Last Changed on [cms_dte_last_chng_date]
LAST_CHG_TIME, -- Last Changed at [cms_dte_last_chng_time]
PRIMARY KEY (MANDT, OBJ_GUID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA