CACS_CTBYTMEPERD

Transparent Table Application Table
19 Fields 1 CDS Views

Commission contract version link

CACS_CTBYTMEPERD is an SAP database table in S/4HANA. Commission contract version link. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CommsnContrCompByTimePeriod view_entity from BASIC Commsn Contract Component Sliced by Time

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY periodid sysuuid_c36 UUID
appl cacsappl Commission Appl
ctrtbu_id cacs_ctrtbu_id Contract Number
version cacs_contr_version Contract Version
component cacs_ctcomponent Contract Component
component_key1 cacs_agrmt_id Agreement No
component_key2 cacs_agr_rule_id FR Rem. Rule No
stcagr_id cacs_stcagr_id StdAgrmt No.
pa_ctrtpar_id cacsctrtpar_id Ind.Part. No
pa_high_participant cacssupwpartctrtbu Contr.No.HLPart
pa_roletype cacsclaimtype Entitlement Cat
cc_identnumber cacs_identnum_kk Corr. Type No.
component_version cacs_agrmt_version Agreement 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
con_curr cacsconcurr Contract Curr.

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 version link
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CACS_CTBYTMEPERD (
    MANDT,                -- Client [mandt]
    PERIODID,             -- UUID [sysuuid_c36]
    APPL,                 -- Commission Appl [cacsappl]
    CTRTBU_ID,            -- Contract Number [cacs_ctrtbu_id]
    VERSION,              -- Contract Version [cacs_contr_version]
    COMPONENT,            -- Contract Component [cacs_ctcomponent]
    COMPONENT_KEY1,       -- Agreement No [cacs_agrmt_id]
    COMPONENT_KEY2,       -- FR Rem. Rule No [cacs_agr_rule_id]
    STCAGR_ID,            -- StdAgrmt No. [cacs_stcagr_id]
    PA_CTRTPAR_ID,        -- Ind.Part. No [cacsctrtpar_id]
    PA_HIGH_PARTICIPANT,  -- Contr.No.HLPart [cacssupwpartctrtbu]
    PA_ROLETYPE,          -- Entitlement Cat [cacsclaimtype]
    CC_IDENTNUMBER,       -- Corr. Type No. [cacs_identnum_kk]
    COMPONENT_VERSION,    -- Agreement Version [cacs_agrmt_version]
    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]
    CON_CURR,             -- Contract Curr. [cacsconcurr]
    PRIMARY KEY (MANDT, PERIODID)
);

Learn More