EXEC_TASKLISTS SAP (Executable Task Lists for Order Simulation/Creation) Structure details
Description: Executable Task Lists for Order Simulation/Creation
Related tables to EXEC_TASKLISTS
Access table EXEC_TASKLISTS
Structure field list including key, data, relationships and ABAP select examples
EXEC_TASKLISTS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Executable Task Lists for Order Simulation/Creation" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_EXEC_TASKLISTS TYPE EXEC_TASKLISTS.
The EXEC_TASKLISTS table consists of various fields, each holding specific information or linking keys about Executable Task Lists for Order Simulation/Creation data available in SAP. These include MANDT (Client), PLNTY (Task List Type), PLNNR (Key for Task List Group), PLNAL (Group Counter).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP EXEC_TASKLISTS structure 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 | |||
PLNTY | Task List Type | PLNTY | CHAR | 1 | TCA01 | PLNTY | PTY | H_TCA01 | |
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
DATUV | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
TECHV | Technical status from | TECHV | CHAR | 12 | TECHS | ||||
AENNR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
LOEKZ | Deletion Indicator | LKENZ | CHAR | 1 | XFELD | ||||
PARKZ | Indicator: inactive changes | PARKZ | CHAR | 1 | XFELD | ||||
ANDAT | Date record created on | ANDAT | DATS | 8 | DATUM | ||||
ANNAM | User who created record | ANNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
VERWE | Task list usage | PLN_VERWE | CHAR | 3 | T411 | PLN_VERWE | H_T411 | ||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
STATU | Status | PLNST | CHAR | 3 | T412 | PLNST | H_T412 | ||
PLNME | Task list unit of measure | PLNME | UNIT | 3 | T006 | CUNIT | MEINS | ||
LOSVN | From Lot Size | LOSGRVON | QUAN | 13(3) | MENG13 | ||||
LOSBS | To lot size | LOSGRBIS | QUAN | 13(3) | MENG13 | ||||
VAGRP | Responsible planner group/department | VAGRP | CHAR | 3 | T024A | VAGRP | H_T024A | ||
AESZN | Document change number (without document management system) | AESZN | CHAR | 6 | AENUM | ||||
KTEXT | Task list description | PLANTEXT | CHAR | 40 | TEXT40 | ||||
TXTSP | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
ABDAT | Date of the last call | ABRUFDAT | DATS | 8 | DATUM | ||||
ABANZ | Number of calls | ABRUFANZ | DEC | 4 | ABRUFANZ | ||||
PROFIDNETZ | Profile | PROFID_STD | CHAR | 7 | TCA41 | PROFID | PIN | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
QVEWERKS | Plant of Selected Set for Automatic Usage Decision | QVEWERKS | CHAR | 4 | T001W | WERKS | WRK | ||
QVEMENGE | Selected Set for Usage Decision | QVEMENGE | CHAR | 8 | Assigned to domain | QAUSWAHLMG | AWM | ||
QVEVERSION | Code Version Used for an Automatic Usage Decision | QVEVERSION | CHAR | 6 | ALPHA | QVERSNR | |||
QVEDATUM | Date of Code Used for Usage Decision | QVEDATUM | DATS | 8 | DATUM | ||||
QVEGRUPPE | Code Group for Automatic Usage Decision | QVEGRUPPE | CHAR | 8 | Assigned to domain | QCODEGRP | CGP | ||
QVECODE | Code for Automatic Usage Decision | QVECODE | CHAR | 4 | Assigned to domain | QCODE | |||
QDYNREGEL | Dynamic Modification Rule | QDYNREGEL | CHAR | 3 | QDDR | QDYNREGEL | QDR | ||
QDYNHEAD | Level at Which Dynamic Modification Parameters Are Defined | QDYNHEAD | CHAR | 1 | TQ39A | QDYNHEAD | |||
QPRZIEHVER | Sample-Drawing Procedure | QPRZIEHVER | CHAR | 8 | QPRVK | QPRZIEHVER | QPV | ||
QVERSNPRZV | Version No. of the Sample-Drawing Procedure | QVERSNPRZV | CHAR | 6 | ALPHA | QVERSNR | |||
QKZRASTER | Inspection Point | QKZRASTER | CHAR | 1 | QKZ | ||||
QDYNSTRING | String for Dynamic Modification Criteria (Database Relevant) | QDYNSTRING | CHAR | 10 | QDYNSTRING | ||||
STRAT | Maintenance strategy | STRAT | CHAR | 6 | T351 | WSTRA | STR | STRAA | |
PPOOL | Maintenance package pool | PPOOL | CHAR | 6 | PPOOL | ||||
ISTRU | Assembly | ISTRU | CHAR | 18 | MARA | MATN1 | MATNR | ||
IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | Assigned to domain | WERKS | IWK | ||
ANLZU | Syst.Condition | ANLZU | CHAR | 1 | T357M | ANLZU | |||
ARBID | Work center group with planning function | IGEWERK | NUMC | 8 | NUM08 | ||||
EXTNUM | External Numbering of Units to be Inspected | QEXTNUM | CHAR | 1 | TQ12 | QEXTNUM | |||
DELKZ | Indicator: Delete completely in reorganization run | CP_DELKZ | CHAR | 1 | FLAG | ||||
ARBTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
STUPR | Setup recipe | STUPR | CHAR | 8 | ALPHA | PLNNR | |||
CLNDR | Clean-out recipe | CLNDR | CHAR | 8 | ALPHA | PLNNR | |||
PRTYP | Process type | C2_PRTYP | NUMC | 1 | C2_PRTYP | ||||
REODAT | Archive date | REODAT | DATS | 8 | DATS | ||||
NETID | Object ID of the resource | CR_OBJID | NUMC | 8 | CRID | CR_OBJID | |||
FLG_CHK | Ind: Task list was submitted for consistency check | FLG_CHKED | CHAR | 1 | XFELD | ||||
PSPNR | Standard WBS element | PS_SPS_ELE | NUMC | 8 | PRPSS | KONPT | PS_SPSNR | ||
TTRAS | Task lists: Internal representation of the period pattern | CP_TTRAS | NUMC | 6 | CP_TTRAS | ||||
KZKFG | Ind: Configurable object | CP_KZKFG | CHAR | 1 | XFELD | ||||
PLNNR_ALT | Old number | CP_PLNNR_A | CHAR | 20 | CP_PLNNR_A | ||||
FLG_CAPO | Recalculate standard values at order creation using CAPP | FLG_CAPO | CHAR | 1 | FLG_CAPO | ||||
STLTY | BOM category | STLTY | CHAR | 1 | STLTY | ||||
STLNR | Bill of material | STNUM | CHAR | 8 | NUMCV | STNUM | STLNR | ||
STLAL | Alternative BOM | STLAL | CHAR | 2 | ALPHA | ALTNR | |||
SLWBEZ | Identification for the Inspection Point Field Combination | QSLWBEZ | CHAR | 3 | TQ79 | QSLWBEZ | QBK | ||
PPKZTLZU | Partial Lot Assignment in an Inspection During Production | QPPKZTLZU | CHAR | 1 | QPPKZTLZU | ||||
CHRULE | Change rule | R_CHRULE | CHAR | 1 | R_CHRULE | ||||
CCOAA | Change Type for Object | CCOAA | NUMC | 3 | TCC13 | CCOAA | |||
ST_ARBID | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
MEINH | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMREZ | Numerator for converting task list and oper. un. of measure | CP_UMREZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for converting rtg and op units of measure | CP_UMREN | DEC | 5 | UMBSN | ||||
BMSCH | Base Quantity | BMSCH | QUAN | 13(3) | BMSCH | ||||
ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | CHAR | 40 | Assigned to domain | ADDCOMPARE_CORE | ADCP | ||
MS_FLAG | Indicator: Multiple Specifications | Q_MS_FLG | CHAR | 1 | Q_MS_FLG | ||||
TSTMP_BW | Time Stamp for BI Delta Extraction | TSTMP_BW_EXT | DEC | 16 | RKE_TSTMP | ||||
MES_ROUTINGID | Key of a Routing from an ME System | CO_MES_INT_ROUTINGID | CHAR | 64 | CHAR64 | ||||
.INCLU--AP | 0 | ||||||||
XHIERTL | Sign: Task List Contains Hierarchical Operations | XHIERTL | CHAR | 1 | XFELD | ||||
TL_EXTID | A&D: External ID of Task List | TL_EXTID | CHAR | 40 | |||||
QMNUM | Notification No | QMNUM | CHAR | 12 | Assigned to domain | ALPHA | QMNUM | IQM | |
QMART | Notification Type | QMART | CHAR | 2 | Assigned to domain | QMART | QMR | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
HELP_FLAG_1 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HELP_FLAG_2 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HELP_FLAG_3 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HELP_FLAG_4 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HELP_FLAG_5 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 |
Key field | Non-key field |
How do I retrieve data from SAP structure EXEC_TASKLISTS using ABAP code?
As EXEC_TASKLISTS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on EXEC_TASKLISTS as there is no data to select.How to access SAP table EXEC_TASKLISTS
Within an ECC or HANA version of SAP you can also view further information about EXEC_TASKLISTS 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