PLMB

Transparent Table Application Table
19 Fields 2 CDS Views

Task List Version to Material BOM Version assignment

PLMB is an SAP database table in S/4HANA. Task List Version to Material BOM Version assignment. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BOOVersionBOMAssignment view from BASIC Bill of Operations Version BOM Assignment
I_ProdnModBOOVersBOMAssgmt view_entity inner BASIC Bill of Operation Version BOM Assignment

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plnty PLNTY Task List Type
KEY plnnr PLNNR Group
KEY plnal PLNAL Group Counter
KEY versn PLNVERSN Routing Version
KEY zuonr CIM_ZUORD Allocation no.
matnr MATNR Material
werks WERKS_D Plant
stlty STLTY BOM category
stlan STLAN Usage
stlnr CIM_STNUM BOM
stlal STALT Alternative
bom_versn CIM_BOM_VERSN BOM Version
source_zuonr CIM_ZUORD Allocation no.
created_by PLNVERSN_CREATE_USER Created by
created_at PLNVERSN_CREATED_AT Created At
changed_by PLNVERSN_CHANGE_USER Change User
changed_at PLNVERSN_CHANGED_AT Changed At
dummy_plmb_incl_eew_ps CFD_DUMMY Dummy

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 Version to Material BOM Version assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLMB (
    MANDT,                   -- Client [MANDT]
    PLNTY,                   -- Task List Type [PLNTY]
    PLNNR,                   -- Group [PLNNR]
    PLNAL,                   -- Group Counter [PLNAL]
    VERSN,                   -- Routing Version [PLNVERSN]
    ZUONR,                   -- Allocation no. [CIM_ZUORD]
    MATNR,                   -- Material [MATNR]
    WERKS,                   -- Plant [WERKS_D]
    STLTY,                   -- BOM category [STLTY]
    STLAN,                   -- Usage [STLAN]
    STLNR,                   -- BOM [CIM_STNUM]
    STLAL,                   -- Alternative [STALT]
    BOM_VERSN,               -- BOM Version [CIM_BOM_VERSN]
    SOURCE_ZUONR,            -- Allocation no. [CIM_ZUORD]
    CREATED_BY,              -- Created by [PLNVERSN_CREATE_USER]
    CREATED_AT,              -- Created At [PLNVERSN_CREATED_AT]
    CHANGED_BY,              -- Change User [PLNVERSN_CHANGE_USER]
    CHANGED_AT,              -- Changed At [PLNVERSN_CHANGED_AT]
    DUMMY_PLMB_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PLNTY, PLNNR, PLNAL, VERSN, ZUONR)
);

Learn More