CMS_CAG_RULES

Transparent Table Application Table
15 Fields 1 CDS Views

Rule Details

CMS_CAG_RULES is an SAP database table in S/4HANA. Rule Details. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AgreementPortionRules view from BASIC Agreement Rule Details

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cag_rules_guid CMS_DTE_CAG_RULES_GUID CAGRULESGUID
cag_por_guid CMS_DTE_CAG_POR_GUID CAGPORGUID
bu_partnerid CMS_DTE_BPID Bus. Partner ID
bpf CMS_DTE_BPF PartnerFunction
rbl_curr CMS_DTE_CAG_RBL_RBL_CURR Currency
rbl_org_unit CMS_DTE_RBL_ORG_UNIT Org. unit
product_set CMS_DTE_PRD_SET Productset
remarks CMS_DTE_REMARKS Remarks
bu_partnerid1 CMS_DTE_BPID Bus. Partner ID
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.

-- Rule Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_CAG_RULES (
    MANDT,           -- Client [MANDT]
    CAG_RULES_GUID,  -- CAGRULESGUID [CMS_DTE_CAG_RULES_GUID]
    CAG_POR_GUID,    -- CAGPORGUID [CMS_DTE_CAG_POR_GUID]
    BU_PARTNERID,    -- Bus. Partner ID [CMS_DTE_BPID]
    BPF,             -- PartnerFunction [CMS_DTE_BPF]
    RBL_CURR,        -- Currency [CMS_DTE_CAG_RBL_RBL_CURR]
    RBL_ORG_UNIT,    -- Org. unit [CMS_DTE_RBL_ORG_UNIT]
    PRODUCT_SET,     -- Productset [CMS_DTE_PRD_SET]
    REMARKS,         -- Remarks [CMS_DTE_REMARKS]
    BU_PARTNERID1,   -- Bus. Partner ID [CMS_DTE_BPID]
    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_RULES_GUID)
);

Learn More