PLMZ

Transparent Table Application Table

Allocation of bill of material items to operations

PLMZ is an SAP database table in S/4HANA. Allocation of bill of material items to operations. It contains 64 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BOOOpBOMItemChangeState view_entity from BASIC Bill of Operations Operation BOM Item Change State
I_BOOOpBOMItmIntIdChgState view_entity from BASIC BOO Op. BOM Item Internal ID Change State
I_RoutingCompAllocSrchMod view_entity from BASIC Bill of Operations Operation BOM Item
sdm_task_list view inner SDM: All Task List Tables

Fields (64)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY plnty plnty Task List Type
KEY plnnr plnnr Group
KEY zuonr cim_zuord Allocation no.
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
plnal plnal Group Counter
plnfl plnfolge Sequence
plnkn cim_plnkn Task list node
stlty stlty BOM category
stlnr cim_stnum BOM
stlal stalt Alternative
stlkn kntnr Nodes
werk_stl werks_d Plant
zudiv dzudiv Divisor
zums1 dzums1 Cutting meas. 1
zums2 dzums2 Cutting meas. 2
zums3 dzums3 Cutting meas. 3
zumei dzumei Unit
imeng kmpmg Quantity
imein kmpme Component UoM
andat andat Created On
annam annam Created by
aedat cim_aedat Changed on
aenam aenam Changed By
rgekz rgekz Backflush
stlst aufst Order level
stlwg aufwg Order path
refkn plnkn Node
gp_matnr matnr Material
gp_werks werks_d Plant
gp_uvorn uvorn Suboperation
gp_krit1 plobj Planning object
gp_freet lintx Line text
aobar aobar Relations. type
zeinh aobdaueh Rel. unit
dauer aobdauer Time Interval
dmeng dkmpmg AvCompQty
knttp knttp Acct Assgmt Cat
flgex flgex External procurement
vorab vorabkz Prelim. order
strecke strecke 3rd party order
stlty_w stlty BOM category
stlnr_w cim_stnum BOM
stlal_w stalt Alternative
kante kante_k Path
lgort lgort_res Stor. loc. res.
disp disp_plus_1 Res./Purc. req.
prodflowid prdflid Product Flow ID
beikz beikz Mat. Prov. Ind.
ablad ablad Unloading Point
wempf wempf Recipient
valid_to datub to
loekz_inherited lkenz Deletion Ind.
versn plnversn Routing Version
versn_source plnversn_source_versn Source Version
versn_source_zuonr plnversn_source_zuonr Src. Allocation no.
bom_versn cim_bom_versn BOM Version
bom_versn_w cim_bom_versn BOM Version
log_comp mpe_log_comp Logical Component

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.

-- Allocation of bill of material items to operations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLMZ (
    MANDT,               -- Client [mandt]
    PLNTY,               -- Task List Type [plnty]
    PLNNR,               -- Group [plnnr]
    ZUONR,               -- Allocation no. [cim_zuord]
    ZAEHL,               -- Counter [cim_count]
    DATUV,               -- Valid From [datuv]
    TECHV,               -- Tech st from [techv]
    AENNR,               -- Change Number [aennr]
    LOEKZ,               -- Deletion Ind. [lkenz]
    PARKZ,               -- Inactive [parkz]
    PLNAL,               -- Group Counter [plnal]
    PLNFL,               -- Sequence [plnfolge]
    PLNKN,               -- Task list node [cim_plnkn]
    STLTY,               -- BOM category [stlty]
    STLNR,               -- BOM [cim_stnum]
    STLAL,               -- Alternative [stalt]
    STLKN,               -- Nodes [kntnr]
    WERK_STL,            -- Plant [werks_d]
    ZUDIV,               -- Divisor [dzudiv]
    ZUMS1,               -- Cutting meas. 1 [dzums1]
    ZUMS2,               -- Cutting meas. 2 [dzums2]
    ZUMS3,               -- Cutting meas. 3 [dzums3]
    ZUMEI,               -- Unit [dzumei]
    IMENG,               -- Quantity [kmpmg]
    IMEIN,               -- Component UoM [kmpme]
    ANDAT,               -- Created On [andat]
    ANNAM,               -- Created by [annam]
    AEDAT,               -- Changed on [cim_aedat]
    AENAM,               -- Changed By [aenam]
    RGEKZ,               -- Backflush [rgekz]
    STLST,               -- Order level [aufst]
    STLWG,               -- Order path [aufwg]
    REFKN,               -- Node [plnkn]
    GP_MATNR,            -- Material [matnr]
    GP_WERKS,            -- Plant [werks_d]
    GP_UVORN,            -- Suboperation [uvorn]
    GP_KRIT1,            -- Planning object [plobj]
    GP_FREET,            -- Line text [lintx]
    AOBAR,               -- Relations. type [aobar]
    ZEINH,               -- Rel. unit [aobdaueh]
    DAUER,               -- Time Interval [aobdauer]
    DMENG,               -- AvCompQty [dkmpmg]
    KNTTP,               -- Acct Assgmt Cat [knttp]
    FLGEX,               -- External procurement [flgex]
    VORAB,               -- Prelim. order [vorabkz]
    STRECKE,             -- 3rd party order [strecke]
    STLTY_W,             -- BOM category [stlty]
    STLNR_W,             -- BOM [cim_stnum]
    STLAL_W,             -- Alternative [stalt]
    KANTE,               -- Path [kante_k]
    LGORT,               -- Stor. loc. res. [lgort_res]
    DISP,                -- Res./Purc. req. [disp_plus_1]
    PRODFLOWID,          -- Product Flow ID [prdflid]
    BEIKZ,               -- Mat. Prov. Ind. [beikz]
    ABLAD,               -- Unloading Point [ablad]
    WEMPF,               -- Recipient [wempf]
    VALID_TO,            -- to [datub]
    LOEKZ_INHERITED,     -- Deletion Ind. [lkenz]
    VERSN,               -- Routing Version [plnversn]
    VERSN_SOURCE,        -- Source Version [plnversn_source_versn]
    VERSN_SOURCE_ZUONR,  -- Src. Allocation no. [plnversn_source_zuonr]
    BOM_VERSN,           -- BOM Version [cim_bom_versn]
    BOM_VERSN_W,         -- BOM Version [cim_bom_versn]
    LOG_COMP,            -- Logical Component [mpe_log_comp]
    PRIMARY KEY (MANDT, PLNTY, PLNNR, ZUONR, ZAEHL)
);