PROD_PLANT_WORK

Transparent Table Application Table
17 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTWORKSCHEDULINGWD

PROD_PLANT_WORK is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTWORKSCHEDULINGWD. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productworkschedulingd view from EXTENSION Ext view prd work sch draft(prd_work)

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
rootdraftuuid /bobf/uuid Key
product productnumber Product
plant werks_d Plant
plantforedit werks_d Plant
materialbasequantity basmg Base quantity
unlimitedoverdelivisallowed ueetk Unlimited
overdelivtolerancelimit ueeto Overdeliv. Tol.
underdelivtolerancelimit uneto Underdel. Tol.
productioninvtrymanagedloc lgpro Storage Location
productionsupervisor fevor Prodn Supervisor
productionschedulingprofile productionschedulingprofile Production Scheduling Profile
baseunit meins Base Unit
matlcompismarkedforbackflush rgekm Backflush
hasactiveentity sdraft_has_active Has active

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.

-- I_PRODUCTWD I_PRODUCTWORKSCHEDULINGWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_PLANT_WORK (
    MANDT,                         -- Client [mandt]
    DRAFTUUID,                     -- Key [/bobf/uuid]
    PARENTDRAFTUUID,               -- Key [/bobf/uuid]
    ROOTDRAFTUUID,                 -- Key [/bobf/uuid]
    PRODUCT,                       -- Product [productnumber]
    PLANT,                         -- Plant [werks_d]
    PLANTFOREDIT,                  -- Plant [werks_d]
    MATERIALBASEQUANTITY,          -- Base quantity [basmg]
    UNLIMITEDOVERDELIVISALLOWED,   -- Unlimited [ueetk]
    OVERDELIVTOLERANCELIMIT,       -- Overdeliv. Tol. [ueeto]
    UNDERDELIVTOLERANCELIMIT,      -- Underdel. Tol. [uneto]
    PRODUCTIONINVTRYMANAGEDLOC,    -- Storage Location [lgpro]
    PRODUCTIONSUPERVISOR,          -- Prodn Supervisor [fevor]
    PRODUCTIONSCHEDULINGPROFILE,   -- Production Scheduling Profile [productionschedulingprofile]
    BASEUNIT,                      -- Base Unit [meins]
    MATLCOMPISMARKEDFORBACKFLUSH,  -- Backflush [rgekm]
    HASACTIVEENTITY,               -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More