CMS_CHG

Transparent Table Application Table
23 Fields 2 CDS Views

Asset - Collateral Agreement Relationship

CMS_CHG is an SAP database table in S/4HANA. Asset - Collateral Agreement Relationship. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AssetAgreementLinkData view from BASIC Asset Agreement Link Details
I_CollateralCharge view_entity from BASIC Collateral Charge Details

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY chg_guid CMS_DTE_CHG_GUID CHGGUID
ast_guid CMS_DTE_AST_GUID AST_GUID
cag_guid CMS_DTE_CAG_GUID CAG GUID
description CMS_DTE_CHG_DESC Description
ranking_order CMS_DTE_RANKING_ORDER Ranking order
sequence CMS_DTE_SEQUENCE Sequence
reg_entry_no CMS_DTE_CHG_REG_NO Register Number
reg_date CMS_DTE_CHG_REG_DATE Register date
ast_part_nr CMS_DTE_AST_PART_NR Share Num
ast_part_dn CMS_DTE_AST_PART_DN Share Dn.
ast_qty CMS_DTE_AST_PART_QTY Quantity
ast_value CMS_DTE_AST_PART_VAL Ast part amt
asmt_amt CMS_DTE_CHG_ASMT_AMT Charge asmt amt
asmt_curr CMS_DTE_CHG_ASMT_CURR Asmt currency
asmt_date CMS_DTE_CHG_ASMT_DATE Asmt date
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
valid_from CMS_DTE_CHG_VALID_FROM Valid From
valid_to CMS_DTE_CHG_VALID_TO Valid To

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 - Collateral Agreement Relationship
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_CHG (
    MANDT,          -- Client [MANDT]
    CHG_GUID,       -- CHGGUID [CMS_DTE_CHG_GUID]
    AST_GUID,       -- AST_GUID [CMS_DTE_AST_GUID]
    CAG_GUID,       -- CAG GUID [CMS_DTE_CAG_GUID]
    DESCRIPTION,    -- Description [CMS_DTE_CHG_DESC]
    RANKING_ORDER,  -- Ranking order [CMS_DTE_RANKING_ORDER]
    SEQUENCE,       -- Sequence [CMS_DTE_SEQUENCE]
    REG_ENTRY_NO,   -- Register Number [CMS_DTE_CHG_REG_NO]
    REG_DATE,       -- Register date [CMS_DTE_CHG_REG_DATE]
    AST_PART_NR,    -- Share Num [CMS_DTE_AST_PART_NR]
    AST_PART_DN,    -- Share Dn. [CMS_DTE_AST_PART_DN]
    AST_QTY,        -- Quantity [CMS_DTE_AST_PART_QTY]
    AST_VALUE,      -- Ast part amt [CMS_DTE_AST_PART_VAL]
    ASMT_AMT,       -- Charge asmt amt [CMS_DTE_CHG_ASMT_AMT]
    ASMT_CURR,      -- Asmt currency [CMS_DTE_CHG_ASMT_CURR]
    ASMT_DATE,      -- Asmt date [CMS_DTE_CHG_ASMT_DATE]
    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]
    VALID_FROM,     -- Valid From [CMS_DTE_CHG_VALID_FROM]
    VALID_TO,       -- Valid To [CMS_DTE_CHG_VALID_TO]
    PRIMARY KEY (MANDT, CHG_GUID)
);

Learn More