CACS_SESAGR

Transparent Table Application Table
21 Fields 1 CDS Views

(Individual) Settlement Schedule Agreement in CommnContract

CACS_SESAGR is an SAP database table in S/4HANA. (Individual) Settlement Schedule Agreement in CommnContract. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CommsnSchedulingAgreement view_entity from BASIC Settlement Scheduling Agreement

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY appl CACSAPPL Commission Appl
KEY ctrtbu_id CACS_CTRTBU_ID Contract Number
KEY sesagr_id CACS_SESAGR_ID No.SchedAgr
KEY version CACSVERSION Version
sesru_id CACSSESRUID Scheduling Rule
sesru_begin CACS_SESRU_BEGIN St.ValiditySchedAgrt
sesru_end CACS_SESRU_END EndValiditySchedAgm
priority CACSPRIORITY Priority
busi_begin CACS_BUSITIME_B Effective from
busi_end CACS_BUSITIME_E Effective Until
tech_begin CACS_TECHTIME_B Tech. Valid Fr.
tech_end CACS_TECHTIME_E Techn. Valid To
flg_cancel_obj CACSCANCOBJ Invalid object
flg_cancel_vers CACSCANCVERS Invalid Version
chg_tcode CACSCDTC Transaction
chg_usr CACSCHUSR Changed By
tri_meth_typ CACSTRIMETHTYP Method
tri_meth_target CACSTRIMETHTAR Processng Targ.
status_version CACSSTATUSVERS Version status
status_work CACSSTATUSWORK Process status

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.

-- (Individual) Settlement Schedule Agreement in CommnContract
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CACS_SESAGR (
    MANDT,            -- Client [MANDT]
    APPL,             -- Commission Appl [CACSAPPL]
    CTRTBU_ID,        -- Contract Number [CACS_CTRTBU_ID]
    SESAGR_ID,        -- No.SchedAgr [CACS_SESAGR_ID]
    VERSION,          -- Version [CACSVERSION]
    SESRU_ID,         -- Scheduling Rule [CACSSESRUID]
    SESRU_BEGIN,      -- St.ValiditySchedAgrt [CACS_SESRU_BEGIN]
    SESRU_END,        -- EndValiditySchedAgm [CACS_SESRU_END]
    PRIORITY,         -- Priority [CACSPRIORITY]
    BUSI_BEGIN,       -- Effective from [CACS_BUSITIME_B]
    BUSI_END,         -- Effective Until [CACS_BUSITIME_E]
    TECH_BEGIN,       -- Tech. Valid Fr. [CACS_TECHTIME_B]
    TECH_END,         -- Techn. Valid To [CACS_TECHTIME_E]
    FLG_CANCEL_OBJ,   -- Invalid object [CACSCANCOBJ]
    FLG_CANCEL_VERS,  -- Invalid Version [CACSCANCVERS]
    CHG_TCODE,        -- Transaction [CACSCDTC]
    CHG_USR,          -- Changed By [CACSCHUSR]
    TRI_METH_TYP,     -- Method [CACSTRIMETHTYP]
    TRI_METH_TARGET,  -- Processng Targ. [CACSTRIMETHTAR]
    STATUS_VERSION,   -- Version status [CACSSTATUSVERS]
    STATUS_WORK,      -- Process status [CACSSTATUSWORK]
    PRIMARY KEY (MANDT, APPL, CTRTBU_ID, SESAGR_ID, VERSION)
);

Learn More