SAP table PLKO (Task list - header)

SAP table PLKO has 5 primary key fields being MANDT,PLNTY,PLNNR,PLNAL,ZAEHL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

PLKO foreign key relationships

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