CMS_AST

Transparent Table Application Table
70 Fields 2 CDS Views

Asset Details

CMS_AST is an SAP database table in S/4HANA. Asset Details. It contains 70 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CollateralAssetData view_entity from BASIC Collateral Asset Details
I_ObjectAssetData view from BASIC Object Asset Details

Fields (70)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ast_guid CMS_DTE_AST_GUID AST_GUID
ast_id CMS_DTE_AST_ID Asset ID
ast_typ CMS_DTE_AST_TYP Asset Type
parent_guid CMS_DTE_SAS_PAR_GUID PARENT_GUID
subast_id CMS_DTE_SAS_ID Sub-asset ID
subast_typ CMS_DTE_SAS_TYP Sub-asset type
description CMS_DTE_AST_DESC Description
object_ref_id CMS_DTE_OBJ_REFID Obj referenceID
object_typ CMS_DTE_OBJ_TYP Ext Object Type
country_key CMS_DTE_AST_COUNTRY_KEY JurisCtryRegion
risk_code CMS_DTE_RISK_CODE Risk code
sfty_ind CMS_DTE_IND_SFTY_DISC Safety Discount
sfty_dscnt CMS_DTE_SAFETY_DSCNT Safety disc (%)
sfty_amount CMS_DTE_SAFETY_AMT Sfty disc (amt)
sfty_amt_curr CMS_DTE_SAFETY_AMT_CURR Currency
objsysid CMS_DTE_OBJ_SYSID Obj System ID
valuation_typ CMS_DTE_IND_VALN_TYP Valuation type
unit_valn_freq CMS_DTE_IND_AST_VALN_FREQ_UNIT Valuation unit
period_valn_freq CMS_DTE_AST_VALN_FREQ_PERIOD Valn period
past_valued_date CMS_DTE_VALN_DATE Last reval date
start_date CMS_DTE_START_DATE Reval strt date
end_date CMS_DTE_END_DATE Reval end date
lending_rate_ind CMS_DTE_IND_LND_RTE Lending Rate
lending_rate1 CMS_DTE_LRTE_PCT1 Rate 1
lending_rate2 CMS_DTE_LRTE_PCT2 Rate 2
lending_rate3 CMS_DTE_LRTE_PCT3 Rate 3
lending_rate4 CMS_DTE_LRTE_PCT4 Rate 4
lending_rate5 CMS_DTE_LRTE_PCT5 Rate 5
liqd_typ CMS_DTE_LIQD_TYP Liquidation typ
liqd_reason CMS_DTE_ATT_ID_TY_AST004 Liquidation Rsn
liqd_date CMS_DTE_LIQD_DATE Liquidation Dt
liqd_amt CMS_DTE_LIQD_VALUE Liquidation Amt
liqd_curr CMS_DTE_LIQD_CURR Currency
exp_prcd_amnt CMS_DTE_LIQ_EXP_PRCD_AMOUNT ExpPrcd
exp_prcd_curr CMS_DTE_LIQ_EXP_PRCD_CURR ExpPrcCurr
exp_acc_date CMS_DTE_LIQ_EXP_ACCRUAL_DATE AccrualDate
obj_exp_prc_time CMS_DTE_LIQ_OBJ_EXP_PRO_DATE Expected Time
acc_number_liq CMS_DTE_LIQ_ACC_NUMBER Acc. number
bank_cntry_liq CMS_DTE_LIQ_BNK_CTRY_KY Ctry/Region Key
bank_key_liq CMS_DTE_LIQ_BNK_KEY Bank key
bank_ctrlkey_liq BKONT Control Key
unit_verf_freq CMS_DTE_IND_AST_VERF_FREQ_UNIT VerifcationUnit
period_verf_freq CMS_DTE_AST_VERF_FREQ_PERIOD Verf. Period
last_verf_date CMS_DTE_AST_VERF_DATE Last Verf. Date
nom_value CMS_DTE_AST_NOMINAL_VALUE Nominal value
nom_value_curr CMS_DTE_AST_NOMINAL_VALUE_CURR Currency
ast_value CMS_DTE_AST_VALUE Value
ast_value_curr CMS_DTE_AST_VALUE_CURR Currency
quantity CMS_DTE_QTY Quantity
unit_of_measure CMS_DTE_UNIT Unit
rec_at CMS_DTE_REC_AT Recorded At
pur_price CMS_DTE_AST_PURCHASE_PRICE Purchase price
pur_price_curr CMS_DTE_AST_PUR_PRICE_CURR Pur Price crcy
pur_date CMS_DTE_AST_PUR_PRICE_DATE Pur price date
ori_value CMS_DTE_AST_ORIGINAL_VALUE Orig.Pro. Value
ori_value_curr CMS_DTE_ORI_VALUE_CURR Currency
admin_org_unit CMS_DTE_ADMINORG AdminOrg
bankarea CMS_DTE_BANKAREA Bankarea
org_unit1 CMS_DTE_AST_ORG_UNIT1 Org Unit 1
org_unit2 CMS_DTE_AST_ORG_UNIT2 Org Unit 2
org_unit3 CMS_DTE_AST_ORG_UNIT3 Org Unit 3
org_unit4 CMS_DTE_AST_ORG_UNIT4 Org Unit 4
org_unit5 CMS_DTE_AST_ORG_UNIT5 Org Unit 5
created_by CMS_DTE_USER Created by
created_at CMS_DTE_CREATED_AT Created At
changed_by CMS_DTE_LAST_CHNG_USER Last Changed by
changed_at CMS_DTE_CHANGED_AT Changed At
sourceofentry CMS_DTE_SOURCE_OF_ENTRY Source Of Entry
nxt_valued_date CMS_DTE_NXT_VALN_DATE Nxt Revaluation date

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.

-- Asset Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_AST (
    MANDT,             -- Client [MANDT]
    AST_GUID,          -- AST_GUID [CMS_DTE_AST_GUID]
    AST_ID,            -- Asset ID [CMS_DTE_AST_ID]
    AST_TYP,           -- Asset Type [CMS_DTE_AST_TYP]
    PARENT_GUID,       -- PARENT_GUID [CMS_DTE_SAS_PAR_GUID]
    SUBAST_ID,         -- Sub-asset ID [CMS_DTE_SAS_ID]
    SUBAST_TYP,        -- Sub-asset type [CMS_DTE_SAS_TYP]
    DESCRIPTION,       -- Description [CMS_DTE_AST_DESC]
    OBJECT_REF_ID,     -- Obj referenceID [CMS_DTE_OBJ_REFID]
    OBJECT_TYP,        -- Ext Object Type [CMS_DTE_OBJ_TYP]
    COUNTRY_KEY,       -- JurisCtryRegion [CMS_DTE_AST_COUNTRY_KEY]
    RISK_CODE,         -- Risk code [CMS_DTE_RISK_CODE]
    SFTY_IND,          -- Safety Discount [CMS_DTE_IND_SFTY_DISC]
    SFTY_DSCNT,        -- Safety disc (%) [CMS_DTE_SAFETY_DSCNT]
    SFTY_AMOUNT,       -- Sfty disc (amt) [CMS_DTE_SAFETY_AMT]
    SFTY_AMT_CURR,     -- Currency [CMS_DTE_SAFETY_AMT_CURR]
    OBJSYSID,          -- Obj System ID [CMS_DTE_OBJ_SYSID]
    VALUATION_TYP,     -- Valuation type [CMS_DTE_IND_VALN_TYP]
    UNIT_VALN_FREQ,    -- Valuation unit [CMS_DTE_IND_AST_VALN_FREQ_UNIT]
    PERIOD_VALN_FREQ,  -- Valn period [CMS_DTE_AST_VALN_FREQ_PERIOD]
    PAST_VALUED_DATE,  -- Last reval date [CMS_DTE_VALN_DATE]
    START_DATE,        -- Reval strt date [CMS_DTE_START_DATE]
    END_DATE,          -- Reval end date [CMS_DTE_END_DATE]
    LENDING_RATE_IND,  -- Lending Rate [CMS_DTE_IND_LND_RTE]
    LENDING_RATE1,     -- Rate 1 [CMS_DTE_LRTE_PCT1]
    LENDING_RATE2,     -- Rate 2 [CMS_DTE_LRTE_PCT2]
    LENDING_RATE3,     -- Rate 3 [CMS_DTE_LRTE_PCT3]
    LENDING_RATE4,     -- Rate 4 [CMS_DTE_LRTE_PCT4]
    LENDING_RATE5,     -- Rate 5 [CMS_DTE_LRTE_PCT5]
    LIQD_TYP,          -- Liquidation typ [CMS_DTE_LIQD_TYP]
    LIQD_REASON,       -- Liquidation Rsn [CMS_DTE_ATT_ID_TY_AST004]
    LIQD_DATE,         -- Liquidation Dt [CMS_DTE_LIQD_DATE]
    LIQD_AMT,          -- Liquidation Amt [CMS_DTE_LIQD_VALUE]
    LIQD_CURR,         -- Currency [CMS_DTE_LIQD_CURR]
    EXP_PRCD_AMNT,     -- ExpPrcd [CMS_DTE_LIQ_EXP_PRCD_AMOUNT]
    EXP_PRCD_CURR,     -- ExpPrcCurr [CMS_DTE_LIQ_EXP_PRCD_CURR]
    EXP_ACC_DATE,      -- AccrualDate [CMS_DTE_LIQ_EXP_ACCRUAL_DATE]
    OBJ_EXP_PRC_TIME,  -- Expected Time [CMS_DTE_LIQ_OBJ_EXP_PRO_DATE]
    ACC_NUMBER_LIQ,    -- Acc. number [CMS_DTE_LIQ_ACC_NUMBER]
    BANK_CNTRY_LIQ,    -- Ctry/Region Key [CMS_DTE_LIQ_BNK_CTRY_KY]
    BANK_KEY_LIQ,      -- Bank key [CMS_DTE_LIQ_BNK_KEY]
    BANK_CTRLKEY_LIQ,  -- Control Key [BKONT]
    UNIT_VERF_FREQ,    -- VerifcationUnit [CMS_DTE_IND_AST_VERF_FREQ_UNIT]
    PERIOD_VERF_FREQ,  -- Verf. Period [CMS_DTE_AST_VERF_FREQ_PERIOD]
    LAST_VERF_DATE,    -- Last Verf. Date [CMS_DTE_AST_VERF_DATE]
    NOM_VALUE,         -- Nominal value [CMS_DTE_AST_NOMINAL_VALUE]
    NOM_VALUE_CURR,    -- Currency [CMS_DTE_AST_NOMINAL_VALUE_CURR]
    AST_VALUE,         -- Value [CMS_DTE_AST_VALUE]
    AST_VALUE_CURR,    -- Currency [CMS_DTE_AST_VALUE_CURR]
    QUANTITY,          -- Quantity [CMS_DTE_QTY]
    UNIT_OF_MEASURE,   -- Unit [CMS_DTE_UNIT]
    REC_AT,            -- Recorded At [CMS_DTE_REC_AT]
    PUR_PRICE,         -- Purchase price [CMS_DTE_AST_PURCHASE_PRICE]
    PUR_PRICE_CURR,    -- Pur Price crcy [CMS_DTE_AST_PUR_PRICE_CURR]
    PUR_DATE,          -- Pur price date [CMS_DTE_AST_PUR_PRICE_DATE]
    ORI_VALUE,         -- Orig.Pro. Value [CMS_DTE_AST_ORIGINAL_VALUE]
    ORI_VALUE_CURR,    -- Currency [CMS_DTE_ORI_VALUE_CURR]
    ADMIN_ORG_UNIT,    -- AdminOrg [CMS_DTE_ADMINORG]
    BANKAREA,          -- Bankarea [CMS_DTE_BANKAREA]
    ORG_UNIT1,         -- Org Unit 1 [CMS_DTE_AST_ORG_UNIT1]
    ORG_UNIT2,         -- Org Unit 2 [CMS_DTE_AST_ORG_UNIT2]
    ORG_UNIT3,         -- Org Unit 3 [CMS_DTE_AST_ORG_UNIT3]
    ORG_UNIT4,         -- Org Unit 4 [CMS_DTE_AST_ORG_UNIT4]
    ORG_UNIT5,         -- Org Unit 5 [CMS_DTE_AST_ORG_UNIT5]
    CREATED_BY,        -- Created by [CMS_DTE_USER]
    CREATED_AT,        -- Created At [CMS_DTE_CREATED_AT]
    CHANGED_BY,        -- Last Changed by [CMS_DTE_LAST_CHNG_USER]
    CHANGED_AT,        -- Changed At [CMS_DTE_CHANGED_AT]
    SOURCEOFENTRY,     -- Source Of Entry [CMS_DTE_SOURCE_OF_ENTRY]
    NXT_VALUED_DATE,   -- Nxt Revaluation date [CMS_DTE_NXT_VALN_DATE]
    PRIMARY KEY (MANDT, AST_GUID)
);

Learn More