TCX00
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA