CMS_CAG_TRMCST

Transparent Table Application Table
18 Fields 1 CDS Views

Termination and Cost details for Agreement/Agreement BP

CMS_CAG_TRMCST is an SAP database table in S/4HANA. Termination and Cost details for Agreement/Agreement BP. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AgreementTerminationAndCost view from BASIC Agreement Termination and Cost Details

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY trmcst_guid CMS_DTE_CAG_TRMCST_GUID CAG GUID
link_guid CMS_DTE_CAG_CAG_BP_GUID AST_GUID
cost_typ CMS_DTE_CAG_COST_TYP Cost type
cost_due_date CMS_DTE_CAG_COST_DUE_DATE Due Date
term_right_typ CMS_DTE_TERM_RIGHT_TYP Right Type
term_reason CMS_DTE_CAG_ATT_ID_TY_CAG002 Termn Type
first_term_date CMS_DTE_CAG_BP_TRM_FSTPOS_DATE Termn Date
term_notice_date CMS_DTE_CAG_BP_TRM_NOTICE_DATE Notice Date
amount CMS_DTE_AMOUNT Possible Default
currency CMS_DTE_CURRENCY Currency
unit_freq CMS_DTE_IND_FREQ_UNIT Unit Term Freq
period_freq CMS_DTE_FREQ_PERIOD Term FreqPeriod
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

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.

-- Termination and Cost details for Agreement/Agreement BP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_CAG_TRMCST (
    MANDT,             -- Client [MANDT]
    TRMCST_GUID,       -- CAG GUID [CMS_DTE_CAG_TRMCST_GUID]
    LINK_GUID,         -- AST_GUID [CMS_DTE_CAG_CAG_BP_GUID]
    COST_TYP,          -- Cost type [CMS_DTE_CAG_COST_TYP]
    COST_DUE_DATE,     -- Due Date [CMS_DTE_CAG_COST_DUE_DATE]
    TERM_RIGHT_TYP,    -- Right Type [CMS_DTE_TERM_RIGHT_TYP]
    TERM_REASON,       -- Termn Type [CMS_DTE_CAG_ATT_ID_TY_CAG002]
    FIRST_TERM_DATE,   -- Termn Date [CMS_DTE_CAG_BP_TRM_FSTPOS_DATE]
    TERM_NOTICE_DATE,  -- Notice Date [CMS_DTE_CAG_BP_TRM_NOTICE_DATE]
    AMOUNT,            -- Possible Default [CMS_DTE_AMOUNT]
    CURRENCY,          -- Currency [CMS_DTE_CURRENCY]
    UNIT_FREQ,         -- Unit Term Freq [CMS_DTE_IND_FREQ_UNIT]
    PERIOD_FREQ,       -- Term FreqPeriod [CMS_DTE_FREQ_PERIOD]
    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]
    PRIMARY KEY (MANDT, TRMCST_GUID)
);

Learn More