PRD_WORK

Transparent Table Application Table
12 Fields 1 CDS Views

Product: Draft Work Scheduling Node

PRD_WORK is an SAP database table in S/4HANA. Product: Draft Work Scheduling Node. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ProductWorkSchedulingD view from BASIC

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY draftkey /BOBF/CONF_KEY NodeID
parentdraftkey /BOBF/CONF_KEY NodeID
rootdraftkey /BOBF/CONF_KEY NodeID
hasactiveentity BOOLE_D TRUE
activeproduct PRODUCTNUMBER Product
activeplant PRODUCTPLANT Plant
materialbasequantity MATERIALBASEQUANTITY Base quantity
unlimitedoverdelivisallowed UNLIMITEDOVERDELIVISALLOWED Unlimited
overdelivtolerancelimit OVERDELIVTOLERANCELIMIT Overdely tol.
underdelivtolerancelimit UNDERDELIVTOLERANCELIMIT Underdely tol.
dummy_plnt_incl_eew_ps PLNT_INCL_EEW MD product plant extensible field element

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.

-- Product: Draft Work Scheduling Node
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRD_WORK (
    CLIENT,                       -- Client [MANDT]
    DRAFTKEY,                     -- NodeID [/BOBF/CONF_KEY]
    PARENTDRAFTKEY,               -- NodeID [/BOBF/CONF_KEY]
    ROOTDRAFTKEY,                 -- NodeID [/BOBF/CONF_KEY]
    HASACTIVEENTITY,              -- TRUE [BOOLE_D]
    ACTIVEPRODUCT,                -- Product [PRODUCTNUMBER]
    ACTIVEPLANT,                  -- Plant [PRODUCTPLANT]
    MATERIALBASEQUANTITY,         -- Base quantity [MATERIALBASEQUANTITY]
    UNLIMITEDOVERDELIVISALLOWED,  -- Unlimited [UNLIMITEDOVERDELIVISALLOWED]
    OVERDELIVTOLERANCELIMIT,      -- Overdely tol. [OVERDELIVTOLERANCELIMIT]
    UNDERDELIVTOLERANCELIMIT,     -- Underdely tol. [UNDERDELIVTOLERANCELIMIT]
    DUMMY_PLNT_INCL_EEW_PS,       -- MD product plant extensible field element [PLNT_INCL_EEW]
    PRIMARY KEY (CLIENT, DRAFTKEY)
);

Learn More