SAP Table PLKOD
I/O table for task list headers
PLKOD (I/O table for task list headers) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PLKOD to other SAP tables.
PLKOD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||
|
PLNTY
Task List Type
|
PLNTY | TCA01 |
CHAR
|
1 | 0 | |||||||||||||||||
|
PLNNR
Key for Task List Group
|
PLNNR |
CHAR
|
8 | 0 | ||||||||||||||||||
|
PLNAL
Group Counter
|
PLNAL |
CHAR
|
2 | 0 | ||||||||||||||||||
|
ZAEHL
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||||||||||||
|
DATUV
Valid-From Date
|
DATUV |
DATS
|
8 | 0 | ||||||||||||||||||
|
TECHV
Technical status from
|
TECHV |
CHAR
|
12 | 0 | ||||||||||||||||||
|
AENNR
Change Number
|
AENNR | AENR |
CHAR
|
12 | 0 | |||||||||||||||||
|
LOEKZ
Deletion Indicator
|
LKENZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
PARKZ
Indicator: inactive changes
|
PARKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
ANDAT
Date record created on
|
ANDAT |
DATS
|
8 | 0 | ||||||||||||||||||
|
ANNAM
User who created record
|
ANNAM |
CHAR
|
12 | 0 | ||||||||||||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||||||||||
|
VERWE
Task list usage
|
PLN_VERWE | T411 |
CHAR
|
3 | 0 | |||||||||||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||||||||||
|
STATU
Status
|
PLNST | T412 |
CHAR
|
3 | 0 | |||||||||||||||||
|
PLNME
Task list unit of measure
|
PLNME | T006 |
UNIT
|
3 | 0 | |||||||||||||||||
|
LOSVN
From Lot Size
|
LOSGRVON |
QUAN
|
13 | 3 | ||||||||||||||||||
|
LOSBS
To lot size
|
LOSGRBIS |
QUAN
|
13 | 3 | ||||||||||||||||||
|
VAGRP
Responsible planner group/department
|
VAGRP | T024A |
CHAR
|
3 | 0 | |||||||||||||||||
|
AESZN
Document change number (without document management system)
|
AESZN |
CHAR
|
6 | 0 | ||||||||||||||||||
|
KTEXT
Task list description
|
PLANTEXT |
CHAR
|
40 | 0 | ||||||||||||||||||
|
TXTSP
Language Key
|
SPRAS | T002 |
LANG
|
1 | 0 | |||||||||||||||||
|
ABDAT
Date of the last call
|
ABRUFDAT |
DATS
|
8 | 0 | ||||||||||||||||||
|
ABANZ
Number of calls
|
ABRUFANZ |
DEC
|
4 | 0 | ||||||||||||||||||
|
PROFIDNETZ
Profile
|
PROFID_STD | TCA41 |
CHAR
|
7 | 0 | |||||||||||||||||
|
KOKRS
Controlling Area
|
KOKRS | TKA01 |
CHAR
|
4 | 0 | |||||||||||||||||
|
QVEWERKS
Plant of Selected Set for Automatic Usage Decision
|
QVEWERKS | T001W |
CHAR
|
4 | 0 | |||||||||||||||||
|
QVEMENGE
Selected Set for Usage Decision
|
QVEMENGE |
CHAR
|
8 | 0 | ||||||||||||||||||
|
QVEVERSION
Code Version Used for an Automatic Usage Decision
|
QVEVERSION |
CHAR
|
6 | 0 | ||||||||||||||||||
|
QVEDATUM
Date of Code Used for Usage Decision
|
QVEDATUM |
DATS
|
8 | 0 | ||||||||||||||||||
|
QVEGRUPPE
Code Group for Automatic Usage Decision
|
QVEGRUPPE |
CHAR
|
8 | 0 | ||||||||||||||||||
|
QVECODE
Code for Automatic Usage Decision
|
QVECODE |
CHAR
|
4 | 0 | ||||||||||||||||||
|
QDYNREGEL
Dynamic Modification Rule
|
QDYNREGEL | QDDR |
CHAR
|
3 | 0 | |||||||||||||||||
|
QDYNHEAD
Level at Which Dynamic Modification Parameters Are Defined
|
QDYNHEAD | TQ39A |
CHAR
|
1 | 0 | |||||||||||||||||
|
QPRZIEHVER
Sample-Drawing Procedure
|
QPRZIEHVER | QPRVK |
CHAR
|
8 | 0 | |||||||||||||||||
|
QVERSNPRZV
Version No. of the Sample-Drawing Procedure
|
QVERSNPRZV |
CHAR
|
6 | 0 | ||||||||||||||||||
|
QKZRASTER
Inspection Point
|
QKZRASTER |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
QDYNSTRING
String for Dynamic Modification Criteria (Database Relevant)
|
QDYNSTRING |
CHAR
|
10 | 0 | ||||||||||||||||||
|
STRAT
Maintenance strategy
|
STRAT | T351 |
CHAR
|
6 | 0 | |||||||||||||||||
|
PPOOL
Maintenance package pool
|
PPOOL |
CHAR
|
6 | 0 | ||||||||||||||||||
|
ISTRU
Assembly
|
ISTRU | MARA |
CHAR
|
18 | 0 | |||||||||||||||||
|
IWERK
Maintenance Planning Plant
|
IWERK |
CHAR
|
4 | 0 | ||||||||||||||||||
|
ANLZU
Syst.Condition
|
ANLZU | T357M |
CHAR
|
1 | 0 | |||||||||||||||||
|
ARBID
Work center group with planning function
|
IGEWERK |
NUMC
|
8 | 0 | ||||||||||||||||||
|
EXTNUM
External Numbering of Units to be Inspected
|
QEXTNUM | TQ12 |
CHAR
|
1 | 0 | |||||||||||||||||
|
DELKZ
Indicator: Delete completely in reorganization run
|
CP_DELKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
ARBTY
Object types of the CIM resource
|
CR_OBJTY |
CHAR
|
2 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
STUPR
Setup recipe
|
STUPR |
CHAR
|
8 | 0 | ||||||||||||||||||
|
CLNDR
Clean-out recipe
|
CLNDR |
CHAR
|
8 | 0 | ||||||||||||||||||
|
PRTYP
Process type
|
C2_PRTYP |
NUMC
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
REODAT
Archive date
|
REODAT |
DATS
|
8 | 0 | ||||||||||||||||||
|
NETID
Object ID of the resource
|
CR_OBJID | CRID |
NUMC
|
8 | 0 | |||||||||||||||||
|
FLG_CHK
Ind: Task list was submitted for consistency check
|
FLG_CHKED |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
PSPNR
Standard WBS element
|
PS_SPS_ELE | PRPSS |
NUMC
|
8 | 0 | |||||||||||||||||
|
TTRAS
Task lists: Internal representation of the period pattern
|
CP_TTRAS |
NUMC
|
6 | 0 | ||||||||||||||||||
|
KZKFG
Ind: Configurable object
|
CP_KZKFG |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
PLNNR_ALT
Old number
|
CP_PLNNR_A |
CHAR
|
20 | 0 | ||||||||||||||||||
|
FLG_CAPO
Recalculate standard values at order creation using CAPP
|
FLG_CAPO |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
STLTY
BOM category
|
STLTY |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
STLNR
Bill of material
|
STNUM |
CHAR
|
8 | 0 | ||||||||||||||||||
|
STLAL
Alternative BOM
|
STLAL |
CHAR
|
2 | 0 | ||||||||||||||||||
|
SLWBEZ
Identification for the Inspection Point Field Combination
|
QSLWBEZ | TQ79 |
CHAR
|
3 | 0 | |||||||||||||||||
|
PPKZTLZU
Partial Lot Assignment in an Inspection During Production
|
QPPKZTLZU |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
CHRULE
Change rule
|
R_CHRULE |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
CCOAA
Change Type for Object
|
CCOAA | TCC13 |
NUMC
|
3 | 0 | |||||||||||||||||
|
ST_ARBID
Object ID
|
OBJEKTID |
NUMC
|
8 | 0 | ||||||||||||||||||
|
MEINH
Unit of Measure for Activity/Operation
|
VORME |
UNIT
|
3 | 0 | ||||||||||||||||||
|
UMREZ
Numerator for converting task list and oper. un. of measure
|
CP_UMREZ |
DEC
|
5 | 0 | ||||||||||||||||||
|
UMREN
Denominator for converting rtg and op units of measure
|
CP_UMREN |
DEC
|
5 | 0 | ||||||||||||||||||
|
BMSCH
Base Quantity
|
BMSCH |
QUAN
|
13 | 3 | ||||||||||||||||||
|
ADPSP
Reference Element PM/PS
|
ADDCOMPARE_CORE |
CHAR
|
40 | 0 | ||||||||||||||||||
|
MS_FLAG
Indicator: Multiple Specifications
|
Q_MS_FLG |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
TSTMP_BW
Time Stamp for BI Delta Extraction
|
TSTMP_BW_EXT |
DEC
|
16 | 0 | ||||||||||||||||||
|
MES_ROUTINGID
Key of a Routing from an ME System
|
CO_MES_INT_ROUTINGID |
CHAR
|
64 | 0 | ||||||||||||||||||
|
XHIERTL
Sign: Task List Contains Hierarchical Operations
|
XHIERTL |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
TL_EXTID
A&D: External ID of Task List
|
TL_EXTID |
CHAR
|
40 | 0 | ||||||||||||||||||
|
DATUB
Valid-to date
|
DATUB |
DATS
|
8 | 0 | ||||||||||||||||||
|
AENNR_AUS
To change number
|
CPCS_ECN_TO |
CHAR
|
12 | 0 | ||||||||||||||||||
|
KAP_ARBPL
Work center for capacity planning
|
KAP_ARBPL |
CHAR
|
8 | 0 | ||||||||||||||||||
|
ST_ARBPL
Work center for a work center operation set
|
ST_ARBPL |
CHAR
|
8 | 0 | ||||||||||||||||||
|
STAUFG
Indicator: Work center operation set
|
STAUFG |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
LINE
Line hierarchy
|
LD_LINE |
CHAR
|
8 | 0 | ||||||||||||||||||
|
AEUZEIT
Time of last change made to the task list
|
AEUZEIT |
TIMS
|
6 | 0 | ||||||||||||||||||
|
QM_IP_TYPE_ALLOWED
QM: Allowed Insp. Point Cats (for Search Help and Check)
|
QM_INSP_POINT_SH01 |
CHAR
|
1 | 0 | ||||||||||||||||||
|
ARBPL
Line
|
C2_ARBPL |
CHAR
|
8 | 0 | ||||||||||||||||||
|
NNAME
Resource network name
|
CR_NNAME |
CHAR
|
10 | 0 | ||||||||||||||||||
PLKOD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| PLKOD | AENNR | PLKOD | MANDT |
AENR
Change Master
|
MANDT |
| PLKOD | AENNR | PLKOD | AENNR |
AENR
Change Master
|
AENNR |
| PLKOD | ANLZU | PLKOD | MANDT |
T357M
Machine operating condition
|
MANDT |
| PLKOD | ANLZU | PLKOD | ANLZU |
T357M
Machine operating condition
|
ANLZU |
| PLKOD | CCOAA | PLKOD | MANDT |
TCC13
ECM: change types (object management record)
|
MANDT |
| PLKOD | CCOAA | PLKOD | CCOAA |
TCC13
ECM: change types (object management record)
|
CCOAA |
| PLKOD | EXTNUM | PLKOD | EXTNUM |
TQ12
Ind. external numbering for test units in results recording
|
EXTNUM |
| PLKOD | EXTNUM | PLKOD | MANDT |
TQ12
Ind. external numbering for test units in results recording
|
MANDT |
| PLKOD | ISTRU | PLKOD | ISTRU |
MARA
General Material Data
|
MATNR |
| PLKOD | ISTRU | PLKOD | MANDT |
MARA
General Material Data
|
MANDT |
| PLKOD | KOKRS | PLKOD | MANDT |
TKA01
Controlling Areas
|
MANDT |
| PLKOD | KOKRS | PLKOD | KOKRS |
TKA01
Controlling Areas
|
KOKRS |
| PLKOD | MANDT | PLKOD | MANDT |
T000
Clients
|
MANDT |
| PLKOD | NETID | PLKOD | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| PLKOD | NETID | PLKOD | ARBTY |
CRID
CIM Resource - Entities
|
OBJTY |
| PLKOD | NETID | PLKOD | NETID |
CRID
CIM Resource - Entities
|
OBJID |
| PLKOD | PLNME | PLKOD | MANDT |
T006
Units of Measurement
|
MANDT |
| PLKOD | PLNME | PLKOD | PLNME |
T006
Units of Measurement
|
MSEHI |
| PLKOD | PLNTY | PLKOD | MANDT |
TCA01
Task list types
|
MANDT |
| PLKOD | PLNTY | PLKOD | PLNTY |
TCA01
Task list types
|
PLNTY |
| PLKOD | PROFIDNETZ | PLKOD | MANDT |
TCA41
Default values for standard networks and profiles
|
MANDT |
| PLKOD | PROFIDNETZ | TCA01 | PLNAW |
TCA41
Default values for standard networks and profiles
|
PLNAW |
| PLKOD | PROFIDNETZ | PLKOD | PROFIDNETZ |
TCA41
Default values for standard networks and profiles
|
PROFIDNETZ |
| PLKOD | PSPNR | PLKOD | MANDT |
PRPSS
Standard WBS Element (WBS element) - Master Data
|
MANDT |
| PLKOD | PSPNR | PLKOD | PSPNR |
PRPSS
Standard WBS Element (WBS element) - Master Data
|
PSPNR |
| PLKOD | QDYNHEAD | PLKOD | QDYNHEAD |
TQ39A
Definition of dynamic modification level
|
DYNLEVEL |
| PLKOD | QDYNREGEL | PLKOD | MANDT |
QDDR
Dynamic modification rule (header)
|
MANDT |
| PLKOD | QDYNREGEL | PLKOD | QDYNREGEL |
QDDR
Dynamic modification rule (header)
|
DYNREGEL |
| PLKOD | QPRZIEHVER | PLKOD | MANDT |
QPRVK
Sample-drawing procedure
|
MANDT |
| PLKOD | QPRZIEHVER | PLKOD | QPRZIEHVER |
QPRVK
Sample-drawing procedure
|
PRZIEHVERF |
| PLKOD | QPRZIEHVER | '000001' |
QPRVK
Sample-drawing procedure
|
VERSION | |
| PLKOD | QVEWERKS | PLKOD | QVEWERKS |
T001W
Plants/Branches
|
WERKS |
| PLKOD | QVEWERKS | PLKOD | MANDT |
T001W
Plants/Branches
|
MANDT |
| PLKOD | SLWBEZ | PLKOD | MANDT |
TQ79
Table with inspection point/user field combinations
|
MANDT |
| PLKOD | SLWBEZ | PLKOD | SLWBEZ |
TQ79
Table with inspection point/user field combinations
|
SLWBEZ |
| PLKOD | STATU | PLKOD | STATU |
T412
Task list status
|
PLNST |
| PLKOD | STATU | PLKOD | MANDT |
T412
Task list status
|
MANDT |
| PLKOD | STRAT | PLKOD | MANDT |
T351
Maintenance strategy
|
MANDT |
| PLKOD | STRAT | PLKOD | STRAT |
T351
Maintenance strategy
|
STRAT |
| PLKOD | TXTSP | PLKOD | TXTSP |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| PLKOD | VAGRP | PLKOD | MANDT |
T024A
Planner group
|
MANDT |
| PLKOD | VAGRP | PLKOD | WERKS |
T024A
Planner group
|
WERKS |
| PLKOD | VAGRP | PLKOD | VAGRP |
T024A
Planner group
|
FEVOR |
| PLKOD | VERWE | PLKOD | MANDT |
T411
Task list usage
|
MANDT |
| PLKOD | VERWE | PLKOD | VERWE |
T411
Task list usage
|
VERWE |
| PLKOD | WERKS | PLKOD | MANDT |
T001W
Plants/Branches
|
MANDT |
| PLKOD | WERKS | PLKOD | WERKS |
T001W
Plants/Branches
|
WERKS |