TCACS_PRD

Transparent Table Application Table
19 Fields 2 CDS Views

Period

TCACS_PRD is an SAP database table in S/4HANA. Period. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CommissionRulePeriodBegin view_entity from BASIC Commsn Rule ID Period Begin Date
I_CommissionRulePeriodEnd view_entity from BASIC Commsn Rule ID Period End Date

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY appl CACSAPPL Commission Appl
KEY rule_id CACSPRDRULE Period Rule
KEY rule_version CACSVERSION Version
KEY period_no CACSPRDNUMBER Period
KEY version CACSVERSION Version
period_begin CACSPRDSTART Period Start
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

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.

-- Period
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCACS_PRD (
    MANDT,            -- Client [MANDT]
    APPL,             -- Commission Appl [CACSAPPL]
    RULE_ID,          -- Period Rule [CACSPRDRULE]
    RULE_VERSION,     -- Version [CACSVERSION]
    PERIOD_NO,        -- Period [CACSPRDNUMBER]
    VERSION,          -- Version [CACSVERSION]
    PERIOD_BEGIN,     -- Period Start [CACSPRDSTART]
    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]
    PRIMARY KEY (MANDT, APPL, RULE_ID, RULE_VERSION, PERIOD_NO, VERSION)
);

Learn More