CACS_BUCAGR

Transparent Table Application Table
19 Fields 1 CDS Views

Commission: Agreement Bundle

CACS_BUCAGR is an SAP database table in S/4HANA. Commission: Agreement Bundle. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CommsnPerfRmnrtnAgreement view_entity from BASIC Performance-Related Rmnrtn Agreement

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY appl CACSAPPL Commission Appl
KEY ctrtbu_id CACS_CTRTBU_ID Contract Number
KEY bucagr_id CACS_BUCAGR_ID Agreement No
KEY version CACSVERSION Version
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
agr_typ CACS_AGR_TYP Agreement Type
stcagr_id CACS_STCAGR_ID StdAgrmt No.

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.

-- Commission: Agreement Bundle
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CACS_BUCAGR (
    MANDT,            -- Client [MANDT]
    APPL,             -- Commission Appl [CACSAPPL]
    CTRTBU_ID,        -- Contract Number [CACS_CTRTBU_ID]
    BUCAGR_ID,        -- Agreement No [CACS_BUCAGR_ID]
    VERSION,          -- Version [CACSVERSION]
    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]
    AGR_TYP,          -- Agreement Type [CACS_AGR_TYP]
    STCAGR_ID,        -- StdAgrmt No. [CACS_STCAGR_ID]
    PRIMARY KEY (MANDT, APPL, CTRTBU_ID, BUCAGR_ID, VERSION)
);

Learn More