CACS_CTRTBU

Transparent Table Application Table
40 Fields 1 CDS Views

Commission Contract

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CommissionContract view_entity from BASIC Commission Contract

Fields (40)

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
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
receiver CORR_PARTNER_KK Corresp. Recip.
receiver_dsc CACS_PARTNER_KK RecipientDescriptn
ind_receiv CORR_ACKEY_KK Activity
coprc COPRC_KK Corresp.Variant
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]
    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]
    RECEIVER,         -- Corresp. Recip. [CORR_PARTNER_KK]
    RECEIVER_DSC,     -- RecipientDescriptn [CACS_PARTNER_KK]
    IND_RECEIV,       -- Activity [CORR_ACKEY_KK]
    COPRC,            -- Corresp.Variant [COPRC_KK]
    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