CACS_CTRTBU

Transparent Table Application Table
24 Fields 2 CDS Views

Commission Contract

CACS_CTRTBU is an SAP database table in S/4HANA. Commission Contract. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CommissionContract view_entity from BASIC Commission contract
I_CommsnContrCompByTimePeriod view_entity inner BASIC Commission components sliced by time

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY appl cacsappl Commission Appl
KEY ctrtbu_id cacs_ctrtbu_id Contract Number
KEY version cacsversion Version
ctrtst_id cacs_ctrtst_id Standard Ctrct
gpart cacs_gpart Com.Contr.Part.
ctrtbu_bdate cacs_ctrtbu_bd Contract Start
ctrtbu_edate cacs_ctrtbu_ed Contract End
entr_date cacs_entr_date Entry Date
leav_date cacs_leav_date Leaving Date
con_curr cacsconcurr Contract Curr.
chg_reason cacschgreason Change Reason
int_title cacs_ititle Internal Title
term_of_not cacs_term_of_not Notice period
term_date cacs_term_date Cancel Date
flg_stopcase cacs_flg_stopcase Obsolete
xdele cacs_xdele Archiving flag
filterid cacsactfilter Activity Filter
ctrtbu_id_ext cacs_ctrtbu_id_ext Ext.Contract No.
lvrsid cacslvrsid TerminateReason
adr_kind_ct bu_adrkind Address Type
addrnumber_ct ad_addrnum Address Number
apr_stat cacs_appr_stat Appr Status
rej_reason ctrtrejreason Reject Reason

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 Contract
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CACS_CTRTBU (
    MANDT,          -- Client [mandt]
    APPL,           -- Commission Appl [cacsappl]
    CTRTBU_ID,      -- Contract Number [cacs_ctrtbu_id]
    VERSION,        -- Version [cacsversion]
    CTRTST_ID,      -- Standard Ctrct [cacs_ctrtst_id]
    GPART,          -- Com.Contr.Part. [cacs_gpart]
    CTRTBU_BDATE,   -- Contract Start [cacs_ctrtbu_bd]
    CTRTBU_EDATE,   -- Contract End [cacs_ctrtbu_ed]
    ENTR_DATE,      -- Entry Date [cacs_entr_date]
    LEAV_DATE,      -- Leaving Date [cacs_leav_date]
    CON_CURR,       -- Contract Curr. [cacsconcurr]
    CHG_REASON,     -- Change Reason [cacschgreason]
    INT_TITLE,      -- Internal Title [cacs_ititle]
    TERM_OF_NOT,    -- Notice period [cacs_term_of_not]
    TERM_DATE,      -- Cancel Date [cacs_term_date]
    FLG_STOPCASE,   -- Obsolete [cacs_flg_stopcase]
    XDELE,          -- Archiving flag [cacs_xdele]
    FILTERID,       -- Activity Filter [cacsactfilter]
    CTRTBU_ID_EXT,  -- Ext.Contract No. [cacs_ctrtbu_id_ext]
    LVRSID,         -- TerminateReason [cacslvrsid]
    ADR_KIND_CT,    -- Address Type [bu_adrkind]
    ADDRNUMBER_CT,  -- Address Number [ad_addrnum]
    APR_STAT,       -- Appr Status [cacs_appr_stat]
    REJ_REASON,     -- Reject Reason [ctrtrejreason]
    PRIMARY KEY (MANDT, APPL, CTRTBU_ID, VERSION)
);

Learn More