CMS_SEC_ACC_BP

Transparent Table Application Table
15 Fields 1 CDS Views

Link between securities account and BuPa is stored here

CMS_SEC_ACC_BP is an SAP database table in S/4HANA. Link between securities account and BuPa is stored here. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SecuritiesAccountPartner view from BASIC Securities Account Partner Details

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sec_acc_bp_guid CMS_DTE_SEC_ACC_BP_GUID BP GUID
sec_acc_guid CMS_DTE_SEC_ACC_GUID Account GUID
bupa_id CMS_DTE_BPID Bus. Partner ID
bpf CMS_DTE_BPF PartnerFunction
bupa_share_nr CMS_DTE_SEC_BUPA_NR Share Num
bupa_share_dr CMS_DTE_SEC_BUPA_DR Share Den
bp_valid_from CMS_RE_DTE_VAL_VALID_FROM Valid From
bp_valid_to CMS_RE_DTE_VAL_VALID_TO Valid To
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

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.

-- Link between securities account and BuPa is stored here
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_SEC_ACC_BP (
    MANDT,            -- Client [MANDT]
    SEC_ACC_BP_GUID,  -- BP GUID [CMS_DTE_SEC_ACC_BP_GUID]
    SEC_ACC_GUID,     -- Account GUID [CMS_DTE_SEC_ACC_GUID]
    BUPA_ID,          -- Bus. Partner ID [CMS_DTE_BPID]
    BPF,              -- PartnerFunction [CMS_DTE_BPF]
    BUPA_SHARE_NR,    -- Share Num [CMS_DTE_SEC_BUPA_NR]
    BUPA_SHARE_DR,    -- Share Den [CMS_DTE_SEC_BUPA_DR]
    BP_VALID_FROM,    -- Valid From [CMS_RE_DTE_VAL_VALID_FROM]
    BP_VALID_TO,      -- Valid To [CMS_RE_DTE_VAL_VALID_TO]
    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]
    PRIMARY KEY (MANDT, SEC_ACC_BP_GUID)
);

Learn More