CMS_SEC_ACC

Transparent Table Application Table
47 Fields 2 CDS Views

Securities account details

CMS_SEC_ACC is an SAP database table in S/4HANA. Securities account details. It contains 47 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SecuritiesAccountObjectData view from BASIC Securities Account Object Details
I_SecuritiesAcctObjMstrData view from BASIC Securities Account Object Details

Fields (47)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sec_acc_guid CMS_DTE_SEC_ACC_GUID Account GUID
depo_bank_id CMS_DTE_SEC_DEPO_BNK_ID Depository bank
account_number CMS_DTE_SEC_ACC_NUMBER Account number
sec_acc_desc CMS_DTE_SEC_ACC_DESC Description
acc_old_ref_no CMS_DTE_SEC_ACC_REF_NO External Ref No
sec_acc_val CMS_DTE_SEC_ACC_VAL_AMT Account Value
sec_acc_val_curr CMS_DTE_SEC_ACC_VAL_CURR Acc Currency
val_date CMS_DTE_SEC_ACC_VAL_DATE Valuation Date
admin_org_unit CMS_DTE_ADMINORG AdminOrg
bankarea CMS_DTE_BANKAREA Bankarea
risk_code CMS_DTE_SEC_RISK_CODE Risk Code
sfty_ind CMS_DTE_SEC_IND_SFTY_DISC Def Safety disc
sfty_dscnt CMS_DTE_SEC_SAFETY_DSCNT Safety disc (%)
sfty_amount CMS_DTE_SEC_SAFETY_AMT Sfty disc (amt)
sfty_amt_curr CMS_DTE_SEC_SAFETY_AMT_CURR Currency
unit_valn_freq CMS_DTE_SEC_IND_FREQUENCY Reval Frequency
period_valn_freq CMS_DTE_SEC_VALN_FREQ_PERIOD Valuation freq
start_date CMS_DTE_SEC_START_DATE Valn start date
end_date CMS_DTE_SEC_END_DATE Valn End date
lending_rate_ind CMS_DTE_SEC_IND_LND_RTE Default rate
lending_rate1 CMS_DTE_SEC_LRTE_PCT1 Rate 1
liqd_typ CMS_DTE_SEC_LIQD_TYP Liquidation typ
liqd_reason CMS_DTE_ATT_ID_TY_AST004 Liquidation Rsn
liqd_date CMS_DTE_SEC_LIQD_DATE Liqd Date
liqd_amt CMS_DTE_SEC_LIQD_VALUE Liqd Value
liqd_curr CMS_DTE_SEC_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
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
org_unit1 CMS_DTE_SEC_ORG_UNIT1 Org. Unit 1
org_unit2 CMS_DTE_SEC_ORG_UNIT2 Org. Unit 2
org_unit3 CMS_DTE_SEC_ORG_UNIT3 Org. Unit 3
org_unit4 CMS_DTE_SEC_ORG_UNIT4 Org. Unit 4
org_unit5 CMS_DTE_SEC_ORG_UNIT5 Org. Unit 5
created_by CMS_DTE_SEC_CR_BY Created By
created_date CMS_DTE_SEC_CR_ON Created On
created_time CMS_DTE_SEC_CR_AT Created At
last_chg_by CMS_DTE_SEC_CH_BY Last Changed By
last_chg_date CMS_DTE_SEC_CH_ON Last Changed On
last_chg_time CMS_DTE_SEC_CH_AT Last Changed At
bupr_id CMS_DTE_BUPR_ID Bus. Process ID
bupr_type_code CMS_DTE_BUPR_TYP_CODE BusProcess Code

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.

-- Securities account details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_SEC_ACC (
    MANDT,             -- Client [MANDT]
    SEC_ACC_GUID,      -- Account GUID [CMS_DTE_SEC_ACC_GUID]
    DEPO_BANK_ID,      -- Depository bank [CMS_DTE_SEC_DEPO_BNK_ID]
    ACCOUNT_NUMBER,    -- Account number [CMS_DTE_SEC_ACC_NUMBER]
    SEC_ACC_DESC,      -- Description [CMS_DTE_SEC_ACC_DESC]
    ACC_OLD_REF_NO,    -- External Ref No [CMS_DTE_SEC_ACC_REF_NO]
    SEC_ACC_VAL,       -- Account Value [CMS_DTE_SEC_ACC_VAL_AMT]
    SEC_ACC_VAL_CURR,  -- Acc Currency [CMS_DTE_SEC_ACC_VAL_CURR]
    VAL_DATE,          -- Valuation Date [CMS_DTE_SEC_ACC_VAL_DATE]
    ADMIN_ORG_UNIT,    -- AdminOrg [CMS_DTE_ADMINORG]
    BANKAREA,          -- Bankarea [CMS_DTE_BANKAREA]
    RISK_CODE,         -- Risk Code [CMS_DTE_SEC_RISK_CODE]
    SFTY_IND,          -- Def Safety disc [CMS_DTE_SEC_IND_SFTY_DISC]
    SFTY_DSCNT,        -- Safety disc (%) [CMS_DTE_SEC_SAFETY_DSCNT]
    SFTY_AMOUNT,       -- Sfty disc (amt) [CMS_DTE_SEC_SAFETY_AMT]
    SFTY_AMT_CURR,     -- Currency [CMS_DTE_SEC_SAFETY_AMT_CURR]
    UNIT_VALN_FREQ,    -- Reval Frequency [CMS_DTE_SEC_IND_FREQUENCY]
    PERIOD_VALN_FREQ,  -- Valuation freq [CMS_DTE_SEC_VALN_FREQ_PERIOD]
    START_DATE,        -- Valn start date [CMS_DTE_SEC_START_DATE]
    END_DATE,          -- Valn End date [CMS_DTE_SEC_END_DATE]
    LENDING_RATE_IND,  -- Default rate [CMS_DTE_SEC_IND_LND_RTE]
    LENDING_RATE1,     -- Rate 1 [CMS_DTE_SEC_LRTE_PCT1]
    LIQD_TYP,          -- Liquidation typ [CMS_DTE_SEC_LIQD_TYP]
    LIQD_REASON,       -- Liquidation Rsn [CMS_DTE_ATT_ID_TY_AST004]
    LIQD_DATE,         -- Liqd Date [CMS_DTE_SEC_LIQD_DATE]
    LIQD_AMT,          -- Liqd Value [CMS_DTE_SEC_LIQD_VALUE]
    LIQD_CURR,         -- Currency [CMS_DTE_SEC_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]
    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]
    ORG_UNIT1,         -- Org. Unit 1 [CMS_DTE_SEC_ORG_UNIT1]
    ORG_UNIT2,         -- Org. Unit 2 [CMS_DTE_SEC_ORG_UNIT2]
    ORG_UNIT3,         -- Org. Unit 3 [CMS_DTE_SEC_ORG_UNIT3]
    ORG_UNIT4,         -- Org. Unit 4 [CMS_DTE_SEC_ORG_UNIT4]
    ORG_UNIT5,         -- Org. Unit 5 [CMS_DTE_SEC_ORG_UNIT5]
    CREATED_BY,        -- Created By [CMS_DTE_SEC_CR_BY]
    CREATED_DATE,      -- Created On [CMS_DTE_SEC_CR_ON]
    CREATED_TIME,      -- Created At [CMS_DTE_SEC_CR_AT]
    LAST_CHG_BY,       -- Last Changed By [CMS_DTE_SEC_CH_BY]
    LAST_CHG_DATE,     -- Last Changed On [CMS_DTE_SEC_CH_ON]
    LAST_CHG_TIME,     -- Last Changed At [CMS_DTE_SEC_CH_AT]
    BUPR_ID,           -- Bus. Process ID [CMS_DTE_BUPR_ID]
    BUPR_TYPE_CODE,    -- BusProcess Code [CMS_DTE_BUPR_TYP_CODE]
    PRIMARY KEY (MANDT, SEC_ACC_GUID)
);

Learn More