CMS_CAG_POR

Transparent Table Application Table
22 Fields 1 CDS Views

Collateral Agreement Portion details

CMS_CAG_POR is an SAP database table in S/4HANA. Collateral Agreement Portion details. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AgreementPortion view from BASIC Agreement Portion Details

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cag_por_guid CMS_DTE_CAG_POR_GUID CAGPORGUID
cag_guid CMS_DTE_CAG_GUID CAG GUID
portionid CMS_DTE_PORTIONID Portion ID
portion_value CMS_DTE_PORTION_VAL Value
pct_cagmt_value CMS_DTE_PCT_CAG_VAL Portion Val (%)
ind_blocking_typ CMS_DTE_IND_CAG_POR_BLK_TYP Blk Category
blocking_reason CMS_DTE_CAG_POR_BLK_REASON Por Restriction
ref_cagmtid CMS_DTE_REF_CAGID Ref CAgmt ID
priority_portion CMS_DTE_PRIORITY Ranking Ratio
ind_rbl_typ CMS_DTE_IND_CAG_LNK_RBL_TYP Receivable Type
file_num CMS_DTE_CAG_POR_FILE_NUM File Number
ind_asgmt CMS_DTE_IND_CAG_POR_ASGMT Assignment
asgmt_date CMS_DTE_CAG_POR_ASGMT_DATE Asgmt Date
int_start_date CMS_DTE_CAG_LCHG_INT_START_DAT Start date
valid_from CMS_DTE_PORTION_VALID_FROM Valid From
valid_to CMS_DTE_PORTION_VALID_TO Valid To
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.

-- Collateral Agreement Portion details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_CAG_POR (
    MANDT,             -- Client [MANDT]
    CAG_POR_GUID,      -- CAGPORGUID [CMS_DTE_CAG_POR_GUID]
    CAG_GUID,          -- CAG GUID [CMS_DTE_CAG_GUID]
    PORTIONID,         -- Portion ID [CMS_DTE_PORTIONID]
    PORTION_VALUE,     -- Value [CMS_DTE_PORTION_VAL]
    PCT_CAGMT_VALUE,   -- Portion Val (%) [CMS_DTE_PCT_CAG_VAL]
    IND_BLOCKING_TYP,  -- Blk Category [CMS_DTE_IND_CAG_POR_BLK_TYP]
    BLOCKING_REASON,   -- Por Restriction [CMS_DTE_CAG_POR_BLK_REASON]
    REF_CAGMTID,       -- Ref CAgmt ID [CMS_DTE_REF_CAGID]
    PRIORITY_PORTION,  -- Ranking Ratio [CMS_DTE_PRIORITY]
    IND_RBL_TYP,       -- Receivable Type [CMS_DTE_IND_CAG_LNK_RBL_TYP]
    FILE_NUM,          -- File Number [CMS_DTE_CAG_POR_FILE_NUM]
    IND_ASGMT,         -- Assignment [CMS_DTE_IND_CAG_POR_ASGMT]
    ASGMT_DATE,        -- Asgmt Date [CMS_DTE_CAG_POR_ASGMT_DATE]
    INT_START_DATE,    -- Start date [CMS_DTE_CAG_LCHG_INT_START_DAT]
    VALID_FROM,        -- Valid From [CMS_DTE_PORTION_VALID_FROM]
    VALID_TO,          -- Valid To [CMS_DTE_PORTION_VALID_TO]
    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, CAG_POR_GUID)
);

Learn More