TCX00

Transparent Table Customizing Table

Scheduling: Planning Levels and Control Parameters

TCX00 is an SAP database table in S/4HANA. Scheduling: Planning Levels and Control Parameters. It contains 47 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
CXCV_DDL_TCX00 view from Compatibility View for TCX00
Pph_Ddl_Po_Tcx00 view left_outer Main scheduling parameters for planned order scheduling

Fields (47)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY werks werks_d Plant
KEY auftg auftg Order Group
KEY aufta aufta Order type
KEY vagrp fevor Prodn Supervisor
phori phori Sched. hor.det.
apls1 apls1 SelID: Detailed
term1 termx Scheduling
kapk1 kapkx Cap.reqmts
phori_2 phori_2 Sched. horizon
apls1_2 apls1_2 SelID:detailed
term1_2 termx_2 Scheduling
kapk1_2 kapkx_2 Cap.reqmts
phori_3 phori_3 Sched. horizon
apls1_3 apls1_3 SelID:detailed
kapk1_3 kapkx_3 Cap.reqmts
term1_3 termx_3 Scheduling
line_term line_term TaktTm-/rateSched.
rathr rathr Rate.plng horzn
apls2 apls2 SelID:rate plng
term2 termx_rate Scheduling
kapk2 kapkx_rate Cap.reqmts
grohr grohr RCutPlg horizon
apls3 apls3 SelID:roughPlng
term3 termx_grob Scheduling
kapk3 kapkx_grob Cap.reqmts
dadj1 dadj1 SchedLvlBD
dadj2 dadj2 Adjust dates
dadj3 dadj3 Dispch.pl.ords
termkz termkz Scheduling type
term_auto term_auto Autom.dates
prot_auto prot_auto Automatic log
stverg stverg Start in past
matfrueh lage_fr Latest staging
breaks breaks Exact breaks
prod_dates prod_dates frm ProdDates
auf_shift auf_shift Shift order
redst_max redst_max Max.redn. level
red_art red_art Reduction Type
redvs_s1 redvs_s1 %red. of floats
redvs_s2 redvs_s2 %red. of floats
redvs_s3 redvs_s3 %red. of floats
redvs_s4 redvs_s4 %red. of floats
redvs_s5 redvs_s5 %red. of floats
redvs_s6 redvs_s6 %red. of floats
term_kper term_kper ReschedWorkfPla
cmact cmact Segment

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.

-- Scheduling: Planning Levels and Control Parameters
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCX00 (
    MANDT,       -- Client [mandt]
    WERKS,       -- Plant [werks_d]
    AUFTG,       -- Order Group [auftg]
    AUFTA,       -- Order type [aufta]
    VAGRP,       -- Prodn Supervisor [fevor]
    PHORI,       -- Sched. hor.det. [phori]
    APLS1,       -- SelID: Detailed [apls1]
    TERM1,       -- Scheduling [termx]
    KAPK1,       -- Cap.reqmts [kapkx]
    PHORI_2,     -- Sched. horizon [phori_2]
    APLS1_2,     -- SelID:detailed [apls1_2]
    TERM1_2,     -- Scheduling [termx_2]
    KAPK1_2,     -- Cap.reqmts [kapkx_2]
    PHORI_3,     -- Sched. horizon [phori_3]
    APLS1_3,     -- SelID:detailed [apls1_3]
    KAPK1_3,     -- Cap.reqmts [kapkx_3]
    TERM1_3,     -- Scheduling [termx_3]
    LINE_TERM,   -- TaktTm-/rateSched. [line_term]
    RATHR,       -- Rate.plng horzn [rathr]
    APLS2,       -- SelID:rate plng [apls2]
    TERM2,       -- Scheduling [termx_rate]
    KAPK2,       -- Cap.reqmts [kapkx_rate]
    GROHR,       -- RCutPlg horizon [grohr]
    APLS3,       -- SelID:roughPlng [apls3]
    TERM3,       -- Scheduling [termx_grob]
    KAPK3,       -- Cap.reqmts [kapkx_grob]
    DADJ1,       -- SchedLvlBD [dadj1]
    DADJ2,       -- Adjust dates [dadj2]
    DADJ3,       -- Dispch.pl.ords [dadj3]
    TERMKZ,      -- Scheduling type [termkz]
    TERM_AUTO,   -- Autom.dates [term_auto]
    PROT_AUTO,   -- Automatic log [prot_auto]
    STVERG,      -- Start in past [stverg]
    MATFRUEH,    -- Latest staging [lage_fr]
    BREAKS,      -- Exact breaks [breaks]
    PROD_DATES,  -- frm ProdDates [prod_dates]
    AUF_SHIFT,   -- Shift order [auf_shift]
    REDST_MAX,   -- Max.redn. level [redst_max]
    RED_ART,     -- Reduction Type [red_art]
    REDVS_S1,    -- %red. of floats [redvs_s1]
    REDVS_S2,    -- %red. of floats [redvs_s2]
    REDVS_S3,    -- %red. of floats [redvs_s3]
    REDVS_S4,    -- %red. of floats [redvs_s4]
    REDVS_S5,    -- %red. of floats [redvs_s5]
    REDVS_S6,    -- %red. of floats [redvs_s6]
    TERM_KPER,   -- ReschedWorkfPla [term_kper]
    CMACT,       -- Segment [cmact]
    PRIMARY KEY (MANDT, WERKS, AUFTG, AUFTA, VAGRP)
);