PLMZ
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA