TCX00 SAP (Scheduling: Planning Levels and Control Parameters) Table details

Dictionary Type: Table
Description: Scheduling: Planning Levels and Control Parameters




ABAP Code to SELECT data from TCX00
Related tables to TCX00
Access table TCX00




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 cust
Display/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
MANDTClient MANDTCLNT3T000MANDT
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
AUFTGOrder group for capacity planning AUFTGCHAR2AUFTG
AUFTAOrder type in capacity planning AUFTACHAR4AUFTA
VAGRPProduction Supervisor FEVORCHAR3T024FFEVORCFV
PHORIScheduling horizon (detailed planning) PHORINUMC3NUMC3
APLS1Selection ID (detailed planning) APLS1CHAR2TCA43CP_SEL_ID
TERM1Lead time scheduling (detailed planning) TERMXCHAR1XFELD
KAPK1Indicator: Generate capacity reqmts (detailed planning) KAPKXCHAR1XFELD
PHORI_2Scheduling horizon (detailed planning, medium term) PHORI_2NUMC3NUMC3
APLS1_2Selection ID for routing (detailed planning, medium term) APLS1_2CHAR2Assigned to domainCP_SEL_ID
TERM1_2Lead time scheduling (detailed planning, medium term) TERMX_2CHAR1XFELD
KAPK1_2Create capacity requirements (detailed planning,medium term) KAPKX_2CHAR1XFELD
PHORI_3Scheduling horizon (detailed planning, long term) PHORI_3NUMC3NUMC3
APLS1_3Selection ID for routing (detailed planning, long term) APLS1_3CHAR2Assigned to domainCP_SEL_ID
KAPK1_3Create capacity requirements (detailed planning, long term) KAPKX_3CHAR1XFELD
TERM1_3Lead time scheduling (detailed planning, long term) TERMX_3CHAR1XFELD
LINE_TERMTakt time-/rate-based scheduling of planned order LINE_TERMCHAR1XFELD
RATHRRate-based planning horizon RATHRNUMC3NUMC3
APLS2Selection ID (rate-based planning) APLS2CHAR2TCA43CP_SEL_ID
TERM2Lead time scheduling (rate-based planning) TERMX_RATECHAR1XFELD
KAPK2Create capacity requirements (rate-based planning) KAPKX_RATECHAR1XFELD
GROHRRough-cut planning horizon GROHRNUMC3NUMC3
APLS3Selection ID (rough-cut planning) APLS3CHAR2TCA43CP_SEL_ID
TERM3Lead time scheduling (rough-cut planning) TERMX_GROBCHAR1XFELD
KAPK3Create capacity requirements (rough-cut planning) KAPKX_GROBCHAR1XFELD
DADJ1Scheduling level for adjusting basic dates DADJ1CHAR1DADJ1
DADJ2Adjust dates in lead time scheduling DADJ2CHAR1DADJ2
DADJ3Adjusting dates when dispatching planned orders DADJ3CHAR1DADJ3
TERMKZScheduling type TERMKZCHAR1T482TERART
TERM_AUTOIndicator: Calculate dates automatically during saving TERM_AUTOCHAR1FLAG
PROT_AUTODisplay scheduling log automatically PROT_AUTOCHAR1XFLAG
STVERGMaximum number of days start date can be in the past STVERGNUMC3STVERG
MATFRUEHLatest date for material staging LAGE_FRCHAR1LAGE_FR
BREAKSIndicator: Scheduling allowing for breaks BREAKSCHAR1XFELD
PROD_DATESScheduling based on production dates PROD_DATESCHAR1XFELD
AUF_SHIFTIndicator: Shift order/network AUF_SHIFTCHAR1XFELD
REDST_MAXMaximum reduction level REDST_MAXNUMC1REDST_MAX
RED_ARTReduction type RED_ARTCHAR1RED_ART
REDVS_S1Red. of floats before and after production (%) REDVS_S1DEC3CX_RPROZ
REDVS_S2Reduction level 2: Red. of floats bef./after prod. (in %) REDVS_S2DEC3CX_RPROZ
REDVS_S3Reduction level 3: Red. of floats bef./aft. prod. (in %) REDVS_S3DEC3CX_RPROZ
REDVS_S4Reduction level 4: Red. of floats bef./aft. prod. (in %) REDVS_S4DEC3CX_RPROZ
REDVS_S5Reduction level 5: Red. of floats bef./aft. prod. (in %) REDVS_S5DEC3CX_RPROZ
REDVS_S6Reduction level 6: Red. of floats bef./aft. prod. (in %) REDVS_S6DEC3CX_RPROZ
TERM_KPERRescheduling in Workforce Planning TERM_KPERCHAR1TERM_KPER
CMACTAssignment Material Staging Operation Segment CMACTCHAR1CMACT

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!