TCX00 SAP (Scheduling: Planning Levels and Control Parameters) Table details
Dictionary Type: Table
Description: Scheduling: Planning Levels and Control Parameters
Description: Scheduling: Planning Levels and Control Parameters
Table field list including key, data, relationships and ABAP select examples
TCX00 is a standard SAP Table which is used to store Scheduling: Planning Levels and Control Parameters data and is available within R/3 SAP systems depending on the version and release level.
The TCX00 table consists of various fields, each holding specific information or linking keys about Scheduling: Planning Levels and Control Parameters data available in SAP. These include WERKS (Plant), AUFTG (Order group for capacity planning), AUFTA (Order type in capacity planning), VAGRP (Production Supervisor).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TCX00 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
AUFTG | Order group for capacity planning | AUFTG | CHAR | 2 | AUFTG | ||||
AUFTA | Order type in capacity planning | AUFTA | CHAR | 4 | AUFTA | ||||
VAGRP | Production Supervisor | FEVOR | CHAR | 3 | T024F | FEVOR | CFV | ||
PHORI | Scheduling horizon (detailed planning) | PHORI | NUMC | 3 | NUMC3 | ||||
APLS1 | Selection ID (detailed planning) | APLS1 | CHAR | 2 | TCA43 | CP_SEL_ID | |||
TERM1 | Lead time scheduling (detailed planning) | TERMX | CHAR | 1 | XFELD | ||||
KAPK1 | Indicator: Generate capacity reqmts (detailed planning) | KAPKX | CHAR | 1 | XFELD | ||||
PHORI_2 | Scheduling horizon (detailed planning, medium term) | PHORI_2 | NUMC | 3 | NUMC3 | ||||
APLS1_2 | Selection ID for routing (detailed planning, medium term) | APLS1_2 | CHAR | 2 | Assigned to domain | CP_SEL_ID | |||
TERM1_2 | Lead time scheduling (detailed planning, medium term) | TERMX_2 | CHAR | 1 | XFELD | ||||
KAPK1_2 | Create capacity requirements (detailed planning,medium term) | KAPKX_2 | CHAR | 1 | XFELD | ||||
PHORI_3 | Scheduling horizon (detailed planning, long term) | PHORI_3 | NUMC | 3 | NUMC3 | ||||
APLS1_3 | Selection ID for routing (detailed planning, long term) | APLS1_3 | CHAR | 2 | Assigned to domain | CP_SEL_ID | |||
KAPK1_3 | Create capacity requirements (detailed planning, long term) | KAPKX_3 | CHAR | 1 | XFELD | ||||
TERM1_3 | Lead time scheduling (detailed planning, long term) | TERMX_3 | CHAR | 1 | XFELD | ||||
LINE_TERM | Takt time-/rate-based scheduling of planned order | LINE_TERM | CHAR | 1 | XFELD | ||||
RATHR | Rate-based planning horizon | RATHR | NUMC | 3 | NUMC3 | ||||
APLS2 | Selection ID (rate-based planning) | APLS2 | CHAR | 2 | TCA43 | CP_SEL_ID | |||
TERM2 | Lead time scheduling (rate-based planning) | TERMX_RATE | CHAR | 1 | XFELD | ||||
KAPK2 | Create capacity requirements (rate-based planning) | KAPKX_RATE | CHAR | 1 | XFELD | ||||
GROHR | Rough-cut planning horizon | GROHR | NUMC | 3 | NUMC3 | ||||
APLS3 | Selection ID (rough-cut planning) | APLS3 | CHAR | 2 | TCA43 | CP_SEL_ID | |||
TERM3 | Lead time scheduling (rough-cut planning) | TERMX_GROB | CHAR | 1 | XFELD | ||||
KAPK3 | Create capacity requirements (rough-cut planning) | KAPKX_GROB | CHAR | 1 | XFELD | ||||
DADJ1 | Scheduling level for adjusting basic dates | DADJ1 | CHAR | 1 | DADJ1 | ||||
DADJ2 | Adjust dates in lead time scheduling | DADJ2 | CHAR | 1 | DADJ2 | ||||
DADJ3 | Adjusting dates when dispatching planned orders | DADJ3 | CHAR | 1 | DADJ3 | ||||
TERMKZ | Scheduling type | TERMKZ | CHAR | 1 | T482 | TERART | |||
TERM_AUTO | Indicator: Calculate dates automatically during saving | TERM_AUTO | CHAR | 1 | FLAG | ||||
PROT_AUTO | Display scheduling log automatically | PROT_AUTO | CHAR | 1 | XFLAG | ||||
STVERG | Maximum number of days start date can be in the past | STVERG | NUMC | 3 | STVERG | ||||
MATFRUEH | Latest date for material staging | LAGE_FR | CHAR | 1 | LAGE_FR | ||||
BREAKS | Indicator: Scheduling allowing for breaks | BREAKS | CHAR | 1 | XFELD | ||||
PROD_DATES | Scheduling based on production dates | PROD_DATES | CHAR | 1 | XFELD | ||||
AUF_SHIFT | Indicator: Shift order/network | AUF_SHIFT | CHAR | 1 | XFELD | ||||
REDST_MAX | Maximum reduction level | REDST_MAX | NUMC | 1 | REDST_MAX | ||||
RED_ART | Reduction type | RED_ART | CHAR | 1 | RED_ART | ||||
REDVS_S1 | Red. of floats before and after production (%) | REDVS_S1 | DEC | 3 | CX_RPROZ | ||||
REDVS_S2 | Reduction level 2: Red. of floats bef./after prod. (in %) | REDVS_S2 | DEC | 3 | CX_RPROZ | ||||
REDVS_S3 | Reduction level 3: Red. of floats bef./aft. prod. (in %) | REDVS_S3 | DEC | 3 | CX_RPROZ | ||||
REDVS_S4 | Reduction level 4: Red. of floats bef./aft. prod. (in %) | REDVS_S4 | DEC | 3 | CX_RPROZ | ||||
REDVS_S5 | Reduction level 5: Red. of floats bef./aft. prod. (in %) | REDVS_S5 | DEC | 3 | CX_RPROZ | ||||
REDVS_S6 | Reduction level 6: Red. of floats bef./aft. prod. (in %) | REDVS_S6 | DEC | 3 | CX_RPROZ | ||||
TERM_KPER | Rescheduling in Workforce Planning | TERM_KPER | CHAR | 1 | TERM_KPER | ||||
CMACT | Assignment Material Staging Operation Segment | CMACT | CHAR | 1 | CMACT |
Key field | Non-key field |
How do I retrieve data from SAP table TCX00 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TCX00 to SELECT all data from the tableDATA: WA_TCX00 TYPE TCX00.
SELECT SINGLE *
FROM TCX00
INTO CORRESPONDING FIELDS OF WA_TCX00
WHERE...
How to access SAP table TCX00
Within an ECC or HANA version of SAP you can also view further information about TCX00 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects