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)
);