PLKO

Transparent Table Application Table
85 Fields 9 CDS Views

Task list - header

PLKO is an SAP database table in S/4HANA. Task list - header. It contains 85 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
E_ProductionRoutingHeader view_entity from EXTENSION Production Routing Header - Extn
E_RoutingHeader view_entity from EXTENSION Routing Header - Extension
I_BillOfOperationsChangeState view from BASIC Bill of Operations Change State
I_BillOfOperationsDescription view_entity from BASIC Latest routing description per task list
I_MfgEngShopFloorRtgMatlBasic view_entity inner BASIC Shop Floor Rtg with Material Assignment
I_RoutingHeaderSearchModel view_entity from BASIC Bill of Operations for Routing
I_StdNetworkVH view from BASIC Standard Network
P_ProductionRoutingHeaderDEX view_entity from BASIC
sdm_task_list view inner SDM: All Task List Tables

Fields (85)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plnty PLNTY Task List Type
KEY plnnr PLNNR Group
KEY plnal PLNAL Group Counter
KEY zaehl CIM_COUNT Counter
datuv DATUV Valid From
techv TECHV Tech st from
aennr AENNR Change Number
loekz LKENZ Deletion Ind.
parkz PARKZ Inactive
andat ANDAT Created On
annam ANNAM Created by
aedat AEDAT Changed On
aenam AENAM Changed By
verwe PLN_VERWE Usage
werks WERKS_D Plant
statu PLNST Status
plnme PLNME Task List Unit
losvn LOSGRVON Lot Size From
losbs LOSGRBIS Lot Size To
vagrp VAGRP Planner Group
aeszn AESZN Doc. Change No.
ktext PLANTEXT Description
txtsp SPRAS Language
abdat ABRUFDAT Last Call
abanz ABRUFANZ No. of Calls
profidnetz PROFID_STD Profile
kokrs KOKRS CO Area
qvewerks QVEWERKS SelSet plant
qvemenge QVEMENGE UD Selected Set
qveversion QVEVERSION Code version
qvedatum QVEDATUM UD Code Date
qvegruppe QVEGRUPPE UD code group
qvecode QVECODE UD code
qdynregel QDYNREGEL Dyn. Mod. Rule
qdynhead QDYNHEAD Dyn. Mod. Level
qprziehver QPRZIEHVER Drawing Proc.
qversnprzv QVERSNPRZV Version
qkzraster QKZRASTER Insp. Points
qdynstring QDYNSTRING DynCrit. strng
strat STRAT Strategy
ppool PPOOL Package pool
istru ISTRU Assembly
iwerk IWERK Planning Plant
anlzu ANLZU SystemCondition
arbid IGEWERK WorkCtrGp plan.
extnum QEXTNUM Ext. Numbering
delkz CP_DELKZ Deletion Flag
arbty CR_OBJTY Object Type
stupr STUPR Setup recipe
clndr CLNDR Cl.-out recipe
prtyp C2_PRTYP Process type
reodat REODAT Archive Date
netid CR_OBJID Object ID
flg_chk FLG_CHKED Consistency chk
pspnr PS_SPS_ELE Std.WBS element
ttras CP_TTRAS Period pattern
kzkfg CP_KZKFG Configurable
plnnr_alt CP_PLNNR_A Old TL Number
flg_capo FLG_CAPO CAPP order
stlty STLTY BOM category
stlnr STNUM BOM
stlal STLAL AlternativeBOM
slwbez QSLWBEZ Field Combinat.
ppkztlzu QPPKZTLZU PL Assignment
chrule R_CHRULE Change Rule
ccoaa CCOAA Change Type
st_arbid OBJEKTID Object ID
meinh VORME Act/op UoM
umrez CP_UMREZ Numerator
umren CP_UMREN Denominator
bmsch BMSCH Base Quantity
adpsp ADDCOMPARE_CORE Ref. Element PM/PS
valid_to DATUB to
loekz_inherited LKENZ Deletion Ind.
dummy_plko_incl_eew_ps CFD_DUMMY Dummy
ms_flag Q_MS_FLG Multiple Specs
changeddatetime TZNTSTMPS Time Stamp
tstmp_bw TSTMP_BW_EXT Time (GMT)
mes_routingid CO_MES_INT_ROUTINGID MES Routing
versn PLNVERSN Routing Version
crtype CHANGE_RECORD_TYPE Change Record Type
efftyp CC_EFFT Effect. Type
xhiertl XHIERTL Hier.TaskList
tl_extid TL_EXTID External Ident.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Task list - header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLKO (
    MANDT,                   -- Client [MANDT]
    PLNTY,                   -- Task List Type [PLNTY]
    PLNNR,                   -- Group [PLNNR]
    PLNAL,                   -- Group Counter [PLNAL]
    ZAEHL,                   -- Counter [CIM_COUNT]
    DATUV,                   -- Valid From [DATUV]
    TECHV,                   -- Tech st from [TECHV]
    AENNR,                   -- Change Number [AENNR]
    LOEKZ,                   -- Deletion Ind. [LKENZ]
    PARKZ,                   -- Inactive [PARKZ]
    ANDAT,                   -- Created On [ANDAT]
    ANNAM,                   -- Created by [ANNAM]
    AEDAT,                   -- Changed On [AEDAT]
    AENAM,                   -- Changed By [AENAM]
    VERWE,                   -- Usage [PLN_VERWE]
    WERKS,                   -- Plant [WERKS_D]
    STATU,                   -- Status [PLNST]
    PLNME,                   -- Task List Unit [PLNME]
    LOSVN,                   -- Lot Size From [LOSGRVON]
    LOSBS,                   -- Lot Size To [LOSGRBIS]
    VAGRP,                   -- Planner Group [VAGRP]
    AESZN,                   -- Doc. Change No. [AESZN]
    KTEXT,                   -- Description [PLANTEXT]
    TXTSP,                   -- Language [SPRAS]
    ABDAT,                   -- Last Call [ABRUFDAT]
    ABANZ,                   -- No. of Calls [ABRUFANZ]
    PROFIDNETZ,              -- Profile [PROFID_STD]
    KOKRS,                   -- CO Area [KOKRS]
    QVEWERKS,                -- SelSet plant [QVEWERKS]
    QVEMENGE,                -- UD Selected Set [QVEMENGE]
    QVEVERSION,              -- Code version [QVEVERSION]
    QVEDATUM,                -- UD Code Date [QVEDATUM]
    QVEGRUPPE,               -- UD code group [QVEGRUPPE]
    QVECODE,                 -- UD code [QVECODE]
    QDYNREGEL,               -- Dyn. Mod. Rule [QDYNREGEL]
    QDYNHEAD,                -- Dyn. Mod. Level [QDYNHEAD]
    QPRZIEHVER,              -- Drawing Proc. [QPRZIEHVER]
    QVERSNPRZV,              -- Version [QVERSNPRZV]
    QKZRASTER,               -- Insp. Points [QKZRASTER]
    QDYNSTRING,              -- DynCrit. strng [QDYNSTRING]
    STRAT,                   -- Strategy [STRAT]
    PPOOL,                   -- Package pool [PPOOL]
    ISTRU,                   -- Assembly [ISTRU]
    IWERK,                   -- Planning Plant [IWERK]
    ANLZU,                   -- SystemCondition [ANLZU]
    ARBID,                   -- WorkCtrGp plan. [IGEWERK]
    EXTNUM,                  -- Ext. Numbering [QEXTNUM]
    DELKZ,                   -- Deletion Flag [CP_DELKZ]
    ARBTY,                   -- Object Type [CR_OBJTY]
    STUPR,                   -- Setup recipe [STUPR]
    CLNDR,                   -- Cl.-out recipe [CLNDR]
    PRTYP,                   -- Process type [C2_PRTYP]
    REODAT,                  -- Archive Date [REODAT]
    NETID,                   -- Object ID [CR_OBJID]
    FLG_CHK,                 -- Consistency chk [FLG_CHKED]
    PSPNR,                   -- Std.WBS element [PS_SPS_ELE]
    TTRAS,                   -- Period pattern [CP_TTRAS]
    KZKFG,                   -- Configurable [CP_KZKFG]
    PLNNR_ALT,               -- Old TL Number [CP_PLNNR_A]
    FLG_CAPO,                -- CAPP order [FLG_CAPO]
    STLTY,                   -- BOM category [STLTY]
    STLNR,                   -- BOM [STNUM]
    STLAL,                   -- AlternativeBOM [STLAL]
    SLWBEZ,                  -- Field Combinat. [QSLWBEZ]
    PPKZTLZU,                -- PL Assignment [QPPKZTLZU]
    CHRULE,                  -- Change Rule [R_CHRULE]
    CCOAA,                   -- Change Type [CCOAA]
    ST_ARBID,                -- Object ID [OBJEKTID]
    MEINH,                   -- Act/op UoM [VORME]
    UMREZ,                   -- Numerator [CP_UMREZ]
    UMREN,                   -- Denominator [CP_UMREN]
    BMSCH,                   -- Base Quantity [BMSCH]
    ADPSP,                   -- Ref. Element PM/PS [ADDCOMPARE_CORE]
    VALID_TO,                -- to [DATUB]
    LOEKZ_INHERITED,         -- Deletion Ind. [LKENZ]
    DUMMY_PLKO_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    MS_FLAG,                 -- Multiple Specs [Q_MS_FLG]
    CHANGEDDATETIME,         -- Time Stamp [TZNTSTMPS]
    TSTMP_BW,                -- Time (GMT) [TSTMP_BW_EXT]
    MES_ROUTINGID,           -- MES Routing [CO_MES_INT_ROUTINGID]
    VERSN,                   -- Routing Version [PLNVERSN]
    CRTYPE,                  -- Change Record Type [CHANGE_RECORD_TYPE]
    EFFTYP,                  -- Effect. Type [CC_EFFT]
    XHIERTL,                 -- Hier.TaskList [XHIERTL]
    TL_EXTID,                -- External Ident. [TL_EXTID]
    PRIMARY KEY (MANDT, PLNTY, PLNNR, PLNAL, ZAEHL)
);

Learn More