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