SAP ABAP Table EXEC_TASKLISTS (Executable Task Lists for Order Simulation/Creation)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PLM (Application Component) Product Lifecycle Management
     ⤷ DIWPS (Package) DI: Work Packaging and Sequencing

Basic Data

Table Category	INTTAB	Structure
Structure	EXEC_TASKLISTS	Table Relationship Diagram
Short Description	Executable Task Lists for Order Simulation/Creation

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Task list - header
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
4	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
5	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
6	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
7	DATUV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
8	TECHV	☐	TECHV	TECHS	CHAR	12	0	Technical status from
9	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
10	LOEKZ	☐	LKENZ	XFELD	CHAR	1	0	Deletion Indicator
11	PARKZ	☐	PARKZ	XFELD	CHAR	1	0	Indicator: inactive changes
12	ANDAT	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
13	ANNAM	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
14	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
15	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
16	VERWE	☐	PLN_VERWE	PLN_VERWE	CHAR	3	0	Task list usage	T411
17	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
18	STATU	☐	PLNST	PLNST	CHAR	3	0	Status	T412
19	PLNME	☐	PLNME	MEINS	UNIT	3	0	Task list unit of measure	T006
20	LOSVN	☐	LOSGRVON	MENG13	QUAN	13	3	From Lot Size
21	LOSBS	☐	LOSGRBIS	MENG13	QUAN	13	3	To lot size
22	VAGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	T024A
23	AESZN	☐	AESZN	AENUM	CHAR	6	0	Document change number (without document management system)
24	KTEXT	☐	PLANTEXT	TEXT40	CHAR	40	0	Task list description
25	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
26	ABDAT	☐	ABRUFDAT	DATUM	DATS	8	0	Date of the last call
27	ABANZ	☐	ABRUFANZ	ABRUFANZ	DEC	4	0	Number of calls
28	PROFIDNETZ	☐	PROFID_STD	PROFID	CHAR	7	0	Profile	TCA41
29	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
30	QVEWERKS	☐	QVEWERKS	WERKS	CHAR	4	0	Plant of Selected Set for Automatic Usage Decision	T001W
31	QVEMENGE	☐	QVEMENGE	QAUSWAHLMG	CHAR	8	0	Selected Set for Usage Decision	*
32	QVEVERSION	☐	QVEVERSION	QVERSNR	CHAR	6	0	Code Version Used for an Automatic Usage Decision
33	QVEDATUM	☐	QVEDATUM	DATUM	DATS	8	0	Date of Code Used for Usage Decision
34	QVEGRUPPE	☐	QVEGRUPPE	QCODEGRP	CHAR	8	0	Code Group for Automatic Usage Decision	*
35	QVECODE	☐	QVECODE	QCODE	CHAR	4	0	Code for Automatic Usage Decision	*
36	QDYNREGEL	☐	QDYNREGEL	QDYNREGEL	CHAR	3	0	Dynamic Modification Rule	QDDR
37	QDYNHEAD	☐	QDYNHEAD	QDYNHEAD	CHAR	1	0	Level at Which Dynamic Modification Parameters Are Defined	TQ39A
38	QPRZIEHVER	☐	QPRZIEHVER	QPRZIEHVER	CHAR	8	0	Sample-Drawing Procedure	QPRVK
39	QVERSNPRZV	☐	QVERSNPRZV	QVERSNR	CHAR	6	0	Version No. of the Sample-Drawing Procedure
40	QKZRASTER	☐	QKZRASTER	QKZ	CHAR	1	0	Inspection Point
41	QDYNSTRING	☐	QDYNSTRING	QDYNSTRING	CHAR	10	0	String for Dynamic Modification Criteria (Database Relevant)
42	STRAT	☐	STRAT	WSTRA	CHAR	6	0	Maintenance strategy	T351
43	PPOOL	☐	PPOOL	PPOOL	CHAR	6	0	Maintenance package pool
44	ISTRU	☐	ISTRU	MATNR	CHAR	18	0	Assembly	MARA
45	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	*
46	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	T357M
47	ARBID	☐	IGEWERK	NUM08	NUMC	8	0	Work center group with planning function
48	EXTNUM	☐	QEXTNUM	QEXTNUM	CHAR	1	0	External Numbering of Units to be Inspected	TQ12
49	DELKZ	☐	CP_DELKZ	FLAG	CHAR	1	0	Indicator: Delete completely in reorganization run
50	ARBTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
51	STUPR	☐	STUPR	PLNNR	CHAR	8	0	Setup recipe
52	CLNDR	☐	CLNDR	PLNNR	CHAR	8	0	Clean-out recipe
53	PRTYP	☐	C2_PRTYP	C2_PRTYP	NUMC	1	0	Process type
54	REODAT	☐	REODAT	DATS	DATS	8	0	Archive date
55	NETID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
56	FLG_CHK	☐	FLG_CHKED	XFELD	CHAR	1	0	Ind: Task list was submitted for consistency check
57	PSPNR	☐	PS_SPS_ELE	PS_SPSNR	NUMC	8	0	Standard WBS element	PRPSS
58	TTRAS	☐	CP_TTRAS	CP_TTRAS	NUMC	6	0	Task lists: Internal representation of the period pattern
59	KZKFG	☐	CP_KZKFG	XFELD	CHAR	1	0	Ind: Configurable object
60	PLNNR_ALT	☐	CP_PLNNR_A	CP_PLNNR_A	CHAR	20	0	Old number
61	FLG_CAPO	☐	FLG_CAPO	FLG_CAPO	CHAR	1	0	Recalculate standard values at order creation using CAPP
62	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
63	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
64	STLAL	☐	STLAL	ALTNR	CHAR	2	0	Alternative BOM
65	SLWBEZ	☐	QSLWBEZ	QSLWBEZ	CHAR	3	0	Identification for the Inspection Point Field Combination	TQ79
66	PPKZTLZU	☐	QPPKZTLZU	QPPKZTLZU	CHAR	1	0	Partial Lot Assignment in an Inspection During Production
67	CHRULE	☐	R_CHRULE	R_CHRULE	CHAR	1	0	Change rule
68	CCOAA	☐	CCOAA	CCOAA	NUMC	3	0	Change Type for Object	TCC13
69	ST_ARBID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
70	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	*
71	UMREZ	☐	CP_UMREZ	UMBSZ	DEC	5	0	Numerator for converting task list and oper. un. of measure
72	UMREN	☐	CP_UMREN	UMBSN	DEC	5	0	Denominator for converting rtg and op units of measure
73	BMSCH	☐	BMSCH	BMSCH	QUAN	13	3	Base Quantity
74	ADPSP	☐	ADDCOMPARE_CORE	ADDCOMPARE_CORE	CHAR	40	0	Reference Element PM/PS	*
75	.INCLUDE	☐				0	0
76	.INCLUDE	☐				0	0
77	MS_FLAG	☐	Q_MS_FLG	Q_MS_FLG	CHAR	1	0	Indicator: Multiple Specifications
78	TSTMP_BW	☐	TSTMP_BW_EXT	RKE_TSTMP	DEC	16	0	Time Stamp for BI Delta Extraction
79	MES_ROUTINGID	☐	CO_MES_INT_ROUTINGID	CHAR64	CHAR	64	0	Key of a Routing from an ME System
80	.INCLU--AP	☐				0	0	PLKO: Enhancements A&D
81	XHIERTL	☐	XHIERTL	XFELD	CHAR	1	0	Sign: Task List Contains Hierarchical Operations
82	TL_EXTID	☐	TL_EXTID		CHAR	40	0	A&D: External ID of Task List
83	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
84	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	*
85	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
86	HELP_FLAG_1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
87	HELP_FLAG_2	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
88	HELP_FLAG_3	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
89	HELP_FLAG_4	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
90	HELP_FLAG_5	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EXEC_TASKLISTS	AENNR	AENR	AENNR	REF	1	CN
2	EXEC_TASKLISTS	ANLZU	T357M	ANLZU	REF	1	CN
3	EXEC_TASKLISTS	CCOAA	TCC13	CCOAA	REF	C	CN
4	EXEC_TASKLISTS	EXTNUM	TQ12	EXTNUM	REF	1	CN
5	EXEC_TASKLISTS	ISTRU	MARA	MATNR	KEY	1	CN
6	EXEC_TASKLISTS	KOKRS	TKA01	KOKRS	REF	1	CN
7	EXEC_TASKLISTS	MANDT	T000	MANDT	KEY	1	CN
8	EXEC_TASKLISTS	NETID	CRID	OBJID	REF	1	CN
9	EXEC_TASKLISTS	PLNME	T006	MSEHI	REF	1	CN
10	EXEC_TASKLISTS	PLNTY	TCA01	PLNTY	KEY	1	CN
11	EXEC_TASKLISTS	PROFIDNETZ	TCA41	PROFIDNETZ	KEY	1	CN
12	EXEC_TASKLISTS	PSPNR	PRPSS	PSPNR	REF	1	CN
13	EXEC_TASKLISTS	QDYNHEAD	TQ39A	DYNLEVEL	REF	C	CN
14	EXEC_TASKLISTS	QDYNREGEL	QDDR	DYNREGEL	REF	C	CN
15	EXEC_TASKLISTS	QPRZIEHVER	QPRVK	PRZIEHVERF	REF	C	CN
16	EXEC_TASKLISTS	QVEWERKS	T001W	WERKS	KEY	1	CN
17	EXEC_TASKLISTS	SLWBEZ	TQ79	SLWBEZ		C	CN
18	EXEC_TASKLISTS	STATU	T412	PLNST	REF	1	CN
19	EXEC_TASKLISTS	STRAT	T351	STRAT	REF	1	CN
20	EXEC_TASKLISTS	TXTSP	T002	SPRAS	REF	1	CN
21	EXEC_TASKLISTS	VAGRP	T024A	FEVOR	REF	1	CN
22	EXEC_TASKLISTS	VERWE	T411	VERWE	REF	1	CN
23	EXEC_TASKLISTS	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C2