TCX0L SAP (Scheduling long term planning: Levels and control parameters) Table details
Dictionary Type: Table
Description: Scheduling long term planning: Levels and control parameters
Description: Scheduling long term planning: Levels and control parameters
Table field list including key, data, relationships and ABAP select examples
TCX0L is a standard SAP Table which is used to store Scheduling long term planning: Levels and control parameters data and is available within R/3 SAP systems depending on the version and release level.
The TCX0L table consists of various fields, each holding specific information or linking keys about Scheduling long term 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 TCX0L 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 | ||
| PLSCN | Planning Scenario of Long-Term Planning | PLSCN | NUMC | 3 | PLSC | PLSCN | PLS | ||
| SCHED_TYPE | Scheduling level | SCHED_TYPE | CHAR | 1 | SCHED_TYPE | ||||
| APLS1_LTP | Selection ID for routing (long term planning) | APLS1_LTP | CHAR | 2 | TCA43 | CP_SEL_ID | |||
| KAPK1_LTP | Create capacity requirements (long term planning) | KAPKX_LTP | CHAR | 1 | XFELD | ||||
| TERM1_LTP | Lead time scheduling (long term planning) | TERMX_LTP | CHAR | 1 | XFELD | ||||
| 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 | |||
| 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 | ||||
| REDST_MAX | Maximum reduction level | REDST_MAX | NUMC | 1 | REDST_MAX | ||||
| 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 |
| Key field | Non-key field |
How do I retrieve data from SAP table TCX0L using ABAP code
The following ABAP code Example will allow you to do a basic selection on TCX0L to SELECT all data from the tableDATA: WA_TCX0L TYPE TCX0L.
SELECT SINGLE *
FROM TCX0L
INTO CORRESPONDING FIELDS OF WA_TCX0L
WHERE...
How to access SAP table TCX0L
Within an ECC or HANA version of SAP you can also view further information about TCX0L 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