SAP table TSK_CLASS_DATA (Data for the class of task lists)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PLNTY Task List Type CHAR 1 0 TCA01 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNAL Group Counter CHAR 2 0 PLNAL
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
DATUV Valid-From Date DATS 8 0 DATUV
TECHV Technical status from CHAR 12 0 TECHV
AENNR Change Number CHAR 12 0 AENR AENNR
LOEKZ Deletion Indicator CHAR 1 0 LKENZ
PARKZ Indicator: inactive changes CHAR 1 0 PARKZ
ANDAT Date Record Created On DATS 8 0 ANDAT
ANNAM User who created record CHAR 12 0 ANNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
VERWE Task List Usage CHAR 3 0 T411 PLN_VERWE
WERKS Plant CHAR 4 0 T001W WERKS_D
STATU Status CHAR 3 0 T412 PLNST
PLNME Task List Unit of Measure UNIT 3 0 T006 PLNME
LOSVN Minimum Lot Size QUAN 13 3 LOSGRVON
LOSBS Maximum Lot Size QUAN 13 3 LOSGRBIS
VAGRP Responsible Planner Group or Department CHAR 3 0 T024A VAGRP
AESZN Document change number (without document management system) CHAR 6 0 AESZN
KTEXT Routing Description CHAR 40 0 PLANTEXT
TXTSP Language Key LANG 1 0 T002 SPRAS
ABDAT Date of the Last Call DATS 8 0 ABRUFDAT
ABANZ Number of Calls DEC 4 0 ABRUFANZ
PROFIDNETZ Profile CHAR 7 0 TCA41 PROFID_STD
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
QVEWERKS Plant of Selected Set for Automatic Usage Decision CHAR 4 0 T001W QVEWERKS
QVEMENGE Selected Set for Usage Decision CHAR 8 0 * QVEMENGE
QVEVERSION Code Version Used for an Automatic Usage Decision CHAR 6 0 QVEVERSION
QVEDATUM System Date When Usage Decision Was Recorded DATS 8 0 QVEDATUM
QVEGRUPPE Code Group for Automatic Usage Decision CHAR 8 0 * QVEGRUPPE
QVECODE Code for Automatic Usage Decision CHAR 4 0 * QVECODE
QDYNREGEL Dynamic Modification Rule CHAR 3 0 QDDR QDYNREGEL
QDYNHEAD Level at Which Dynamic Modification Parameters Are Defined CHAR 1 0 TQ39A QDYNHEAD
QPRZIEHVER Sample-Drawing Procedure CHAR 8 0 QPRVK QPRZIEHVER
QVERSNPRZV Version No. of the Sample-Drawing Procedure CHAR 6 0 QVERSNPRZV
QKZRASTER Inspection Point CHAR 1 0 QKZRASTER
QDYNSTRING String for Dynamic Modification Criteria (Database Relevant) CHAR 10 0 QDYNSTRING
STRAT Maintenance Strategy CHAR 6 0 T351 STRAT
PPOOL Maintenance package pool CHAR 6 0 PPOOL
ISTRU Assembly CHAR 40 0 MARA ISTRU
IWERK Maintenance Planning Plant CHAR 4 0 * IWERK
ANLZU System Condition CHAR 1 0 T357M ANLZU
ARBID Work center group with planning function NUMC 8 0 IGEWERK
EXTNUM External Numbering of Units to Be Inspected CHAR 1 0 TQ12 QEXTNUM
DELKZ Indicator: Delete completely in reorganization run CHAR 1 0 CP_DELKZ
ARBTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
STUPR Setup recipe CHAR 8 0 STUPR
CLNDR Clean-out recipe CHAR 8 0 CLNDR
PRTYP Process type NUMC 1 0 C2_PRTYP
0 Batch and continuous
1 Background
2 Continuous
REODAT Archive date DATS 8 0 REODAT
NETID Object ID of the resource NUMC 8 0 CRID CR_OBJID
FLG_CHK Ind: Task list was submitted for consistency check CHAR 1 0 FLG_CHKED
PSPNR Standard WBS element NUMC 8 0 PRPSS PS_SPS_ELE
TTRAS Task lists: Internal representation of the period pattern NUMC 6 0 CP_TTRAS
KZKFG Configurable Material CHAR 1 0 CP_KZKFG
PLNNR_ALT Old Number CHAR 20 0 CP_PLNNR_A
FLG_CAPO Recalculate standard values at order creation using CAPP CHAR 1 0 FLG_CAPO
1 Planned order
2 Production order
3 Recalculation
9 Always
STLTY BOM category CHAR 1 0 STLTY
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
P Work Breakdown Structure BOM
S Standard BOM
T Functional Location BOM
STLNR Bill of Material CHAR 8 0 STNUM
STLAL Alternative BOM CHAR 2 0 STLAL
SLWBEZ Identifier for Inspection Point Field Combination CHAR 3 0 TQ79 QSLWBEZ
PPKZTLZU Partial Lot Assignment in an Inspection During Production CHAR 1 0 QPPKZTLZU
Partial lot assignment according to plant default values
0 Partial lots not supported
1 Partial lot for each inspection point
2 Partial lot and batch for each inspection point
3 Partial lot for inspection points of 'last' inspection oper.
4 Partial lot and batch for insp. points of 'last' operation
CHRULE Change Rule CHAR 1 0 R_CHRULE
No
1 With change number
2 With engineering change order (without change type)
3 With engineering change order (with change type)
4 With change record (without change record type)
5 With change record (with specified change record type)
CCOAA Change Type for Object NUMC 3 0 TCC13 CCOAA
ST_ARBID Object ID NUMC 8 0 OBJEKTID
MEINH Unit of measure for activity UNIT 3 0 * VORME
UMREZ Numerator for Converting Routing and Operation UoM DEC 5 0 CP_UMREZ
UMREN Denominator for Converting Routing and Operation UoM DEC 5 0 CP_UMREN
BMSCH Base Quantity QUAN 13 3 BMSCH
ADPSP Reference Element PM/PS CHAR 40 0 ADDCOMPARE_CORE
VALID_TO Valid-to date DATS 8 0 DATUB
LOEKZ_INHERITED Deletion Indicator CHAR 1 0 LKENZ
DUMMY_PLKO_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
MS_FLAG Indicator: Multiple Specifications CHAR 1 0 Q_MS_FLG
Insp. Plan/Assignment for Dependent Char. Specifications
X Inspection Plan/Assignment for Multiple Specifications
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
TSTMP_BW Time Stamp for BI Delta Extraction DEC 16 0 TSTMP_BW_EXT
MES_ROUTINGID Key of a Routing from an ME System CHAR 64 0 CO_MES_INT_ROUTINGID
VERSN Routing Version CHAR 4 0 PLNVERSN
CRTYPE Change Record Type CHAR 3 0 * CHANGE_RECORD_TYPE
EFFTYP Effectivity Type CHAR 10 0 CC_EFFT
XHIERTL Sign: Task List Contains Hierarchical Operations CHAR 1 0 XHIERTL
TL_EXTID A&D: External ID of Task List CHAR 40 0 TL_EXTID
DATUB Valid-to date DATS 8 0 DATUB
AENNR_AUS To change number CHAR 12 0 * CPCS_ECN_TO
KAP_ARBPL Work Center for Capacity Planning CHAR 8 0 KAP_ARBPL
ST_ARBPL Work center for a work center operation set CHAR 8 0 ST_ARBPL
STAUFG Indicator: Work center operation set CHAR 1 0 STAUFG
LINE Line Hierarchy CHAR 8 0 LD_LINE
AEUZEIT Time of last change made to the task list TIMS 6 0 AEUZEIT
QM_IP_TYPE_ALLOWED QM: Allowed Insp. Point Cats (for Search Help and Check) CHAR 1 0 QM_INSP_POINT_SH01
SUBTYPE Version Profile CHAR 1 0 PLNSUBTYPE
ALTEXT Describes a task list group counter CHAR 40 0 PLANALTEXT
REWORK Rework Routing CHAR 1 0 MPE_REWORK_ROUTING
FLG_ECM Task list with change number CHAR 1 0 RTG_ECM
FLG_ECM_PAR Task list with parameter effectivity CHAR 1 0 RTG_ECM_PARAMETER
RELAXED Flexible Processing CHAR 1 0 MPE_FLEXIBLE_PROCESSING
EXECUTION_IN_ME Order Execution for this Routing to be Performed in SAP ME CHAR 1 0 MPE_EXECUTION_IN_ME
ERP_INTEGRATION Planning for this Routing to be Performed in SAP ERP CHAR 1 0 MPE_ERP_INTEGRATION
REFERENCE_TEMPLATE_TYPE Template Type CHAR 1 0 MPE_RTG_REF_TEMPLATE_TYPE
A Operation Activity
G Operation Activity Group
O Operation
S Operation Set
REFERENCE_TEMPLATE_CATEGORY Template Category CHAR 1 0 MPE_RTG_REF_TEMPLATE_CATEGORY
Reference Template
C Common Copy Template
P Private Copy Template
REFERENCE_TEMPLATE_OWNER Owner CHAR 12 0 MPE_OWNER
VORNR_LOCAL_CHG_NOT_ALLWD Specifies that Operation Numbers Cannot be Changed Locally CHAR 1 0 MPE_VORNR_LOCAL_CHG_NOT_ALLWD
ARBPL Line CHAR 8 0 C2_ARBPL
NNAME Resource network name CHAR 10 0 CR_NNAME
FLG_LOCK Header is locked CHAR 1 0 TSK_LOCK
HANDLE Internal ID of an object INT4 10 0 HANDLE
MATKZ Material Considered for Dynamic Modification CHAR 1 0 QMATKZ
LIEFKZ Supplier Considered for Dynamic Modification CHAR 1 0 QLIFKZ
HERSTKZ Manufacturer Considered for Dynamic Modification CHAR 1 0 QHERSTKZ
KUNDKZ Customer Considered for Dynamic Modification CHAR 1 0 QKUNDKZ
MASCHKZ Machine Considered for Dynamic Modification CHAR 1 0 QMASCHKZ
PROKZ Project Considered for Dynamic Modification CHAR 1 0 QPROKZ

TSK_CLASS_DATA foreign key relationships

Table Field Check Table Check Field
0 TSK_CLASS_DATA AENNR AENR Change Master AENNR
1 TSK_CLASS_DATA ANLZU T357M Machine operating condition MANDT
0 TSK_CLASS_DATA CCOAA TCC13 ECM: change types (object management record) MANDT
1 TSK_CLASS_DATA EXTNUM TQ12 Ind. external numbering for test units in results recording MANDT
1 TSK_CLASS_DATA EXTNUM TQ12 Ind. external numbering for test units in results recording EXTNUM
0 TSK_CLASS_DATA ISTRU MARA General Material Data MANDT
0 TSK_CLASS_DATA ISTRU MARA General Material Data MATNR
1 TSK_CLASS_DATA KOKRS TKA01 Controlling Areas MANDT
0 TSK_CLASS_DATA NETID CRID CIM Resource - Entities MANDT
0 TSK_CLASS_DATA NETID CRID CIM Resource - Entities OBJID
1 TSK_CLASS_DATA PLNME T006 Units of Measurement MANDT
1 TSK_CLASS_DATA PLNME T006 Units of Measurement MSEHI
0 TSK_CLASS_DATA PLNTY TCA01 Task list types MANDT
1 TSK_CLASS_DATA PROFIDNETZ TCA41 Default values for standard networks and profiles MANDT
1 TSK_CLASS_DATA PROFIDNETZ TCA41 Default values for standard networks and profiles PLNAW
0 TSK_CLASS_DATA PSPNR PRPSS Standard WBS Element (WBS element) - Master Data MANDT
0 TSK_CLASS_DATA PSPNR PRPSS Standard WBS Element (WBS element) - Master Data PSPNR
1 TSK_CLASS_DATA QDYNHEAD TQ39A Definition of dynamic modification level DYNLEVEL
0 TSK_CLASS_DATA QDYNREGEL QDDR Dynamic modification rule (header) MANDT
1 TSK_CLASS_DATA QPRZIEHVER QPRVK Sample-drawing procedure MANDT
1 TSK_CLASS_DATA QPRZIEHVER QPRVK Sample-drawing procedure VERSION
0 TSK_CLASS_DATA QVEWERKS T001W Plants/Branches MANDT
0 TSK_CLASS_DATA QVEWERKS T001W Plants/Branches WERKS
1 TSK_CLASS_DATA SLWBEZ TQ79 Table with inspection point/user field combinations MANDT
0 TSK_CLASS_DATA STATU T412 Task list status MANDT
0 TSK_CLASS_DATA STATU T412 Task list status PLNST
1 TSK_CLASS_DATA STRAT T351 Maintenance strategy MANDT
0 TSK_CLASS_DATA TXTSP T002 Language Keys (Component BC-I18) SPRAS
1 TSK_CLASS_DATA VAGRP T024A Planner group WERKS
0 TSK_CLASS_DATA VERWE T411 Task list usage MANDT
1 TSK_CLASS_DATA WERKS T001W Plants/Branches WERKS