TCMS_CAG_TYP

Transparent Table Customizing Table
17 Fields 1 CDS Views

Collateral Agreement type Description

TCMS_CAG_TYP is an SAP database table in S/4HANA. Collateral Agreement type Description. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AgreementType view from BASIC Agreement Type

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cagmt_type CMS_DTE_CAG_TYP CAgmt type
categoryid CMS_DTE_CAG_CAT Category
flg_global CMS_DTE_FLG_CAG_GLOBAL Global Cagmt
ind_org_role CMS_DTE_IND_ORG_RL Role
flg_mlt_assets CMS_DTE_FLG_MLT_ASTS Multiple Assets
bpf_set CMS_DTE_BPF_SET BPF set
doc_set CMS_DTE_DOC_SET Doc typ Set
fstat_var CMS_DTE_FSTAT_VAR Object Screen
proc_cky CMS_DTE_PCN_PROC_CKY Proc Cntrl Key
value_typ CMS_DTE_IND_CAG_VAL_TYP Value Type
sa_set CMS_DTE_CAG_SA_SET Spl Arngmt Set
free_col_rel CMS_DTE_FLG_FREE_COL Free Collateral
num_range_number CMS_DTE_CAG_NR_INT Internal Num Range
num_assign_typ CMS_DTE_NUM_ASSIGNMENT Number Assignment
cor_grp CMS_DTE_COR_GRP Corr Group.
cor_role CMS_DTE_COR_ROLE Corresp. Role

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.

-- Collateral Agreement type Description
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCMS_CAG_TYP (
    MANDT,             -- Client [MANDT]
    CAGMT_TYPE,        -- CAgmt type [CMS_DTE_CAG_TYP]
    CATEGORYID,        -- Category [CMS_DTE_CAG_CAT]
    FLG_GLOBAL,        -- Global Cagmt [CMS_DTE_FLG_CAG_GLOBAL]
    IND_ORG_ROLE,      -- Role [CMS_DTE_IND_ORG_RL]
    FLG_MLT_ASSETS,    -- Multiple Assets [CMS_DTE_FLG_MLT_ASTS]
    BPF_SET,           -- BPF set [CMS_DTE_BPF_SET]
    DOC_SET,           -- Doc typ Set [CMS_DTE_DOC_SET]
    FSTAT_VAR,         -- Object Screen [CMS_DTE_FSTAT_VAR]
    PROC_CKY,          -- Proc Cntrl Key [CMS_DTE_PCN_PROC_CKY]
    VALUE_TYP,         -- Value Type [CMS_DTE_IND_CAG_VAL_TYP]
    SA_SET,            -- Spl Arngmt Set [CMS_DTE_CAG_SA_SET]
    FREE_COL_REL,      -- Free Collateral [CMS_DTE_FLG_FREE_COL]
    NUM_RANGE_NUMBER,  -- Internal Num Range [CMS_DTE_CAG_NR_INT]
    NUM_ASSIGN_TYP,    -- Number Assignment [CMS_DTE_NUM_ASSIGNMENT]
    COR_GRP,           -- Corr Group. [CMS_DTE_COR_GRP]
    COR_ROLE,          -- Corresp. Role [CMS_DTE_COR_ROLE]
    PRIMARY KEY (MANDT, CAGMT_TYPE)
);

Learn More