PRD_ROOT_STORAGE

Transparent Table Application Table
19 Fields 1 CDS Views

Product: Draft root Storage Node

PRD_ROOT_STORAGE is an SAP database table in S/4HANA. Product: Draft root Storage Node. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_Productstoraged view from BASIC

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY draftkey /BOBF/CONF_KEY NodeID
parentdraftkey /BOBF/CONF_KEY NodeID
hasactiveentity BOOLE_D TRUE
activeproduct PRODUCTNUMBER Product
storageconditions STORAGECONDITIONS Stor.conditions
temperatureconditionind TEMPERATURECONDITIONIND Temperature
hazardousmaterialnumber HAZARDOUSMATERIALNUMBER Haz. matl no.
nmbrofgrorgislipstoprintqty NMBROFGRORGISLIPSTOPRINTQTY Number of GR slips
labeltype LABELTYPE Label Type
labelform LABELFORM Label Form
minremainingshelflife MINREMAININGSHELFLIFE Rem. Shelf Life
expirationdate EXPIRATIONDATE Expiratn Date
storagebininstruction STORAGEBININSTRUCTION Container
totalshelflife TOTALSHELFLIFE Tot. shelf life
totalshelflifestoragepercent TOTALSHELFLIFESTORAGEPERCENT Storage %
shelflifeexpirationdateperiod SHELFLIFEEXPIRATIONDATEPERIOD Period Ind.
shelflifeexprtndaterndingrule SHELFLIFEEXPRTNDATERNDINGRULE Rounding rule
dummy_prd_incl_eew_ps PRD_INCL_EEW Dummy Field

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 root Storage Node
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRD_ROOT_STORAGE (
    CLIENT,                         -- Client [MANDT]
    DRAFTKEY,                       -- NodeID [/BOBF/CONF_KEY]
    PARENTDRAFTKEY,                 -- NodeID [/BOBF/CONF_KEY]
    HASACTIVEENTITY,                -- TRUE [BOOLE_D]
    ACTIVEPRODUCT,                  -- Product [PRODUCTNUMBER]
    STORAGECONDITIONS,              -- Stor.conditions [STORAGECONDITIONS]
    TEMPERATURECONDITIONIND,        -- Temperature [TEMPERATURECONDITIONIND]
    HAZARDOUSMATERIALNUMBER,        -- Haz. matl no. [HAZARDOUSMATERIALNUMBER]
    NMBROFGRORGISLIPSTOPRINTQTY,    -- Number of GR slips [NMBROFGRORGISLIPSTOPRINTQTY]
    LABELTYPE,                      -- Label Type [LABELTYPE]
    LABELFORM,                      -- Label Form [LABELFORM]
    MINREMAININGSHELFLIFE,          -- Rem. Shelf Life [MINREMAININGSHELFLIFE]
    EXPIRATIONDATE,                 -- Expiratn Date [EXPIRATIONDATE]
    STORAGEBININSTRUCTION,          -- Container [STORAGEBININSTRUCTION]
    TOTALSHELFLIFE,                 -- Tot. shelf life [TOTALSHELFLIFE]
    TOTALSHELFLIFESTORAGEPERCENT,   -- Storage % [TOTALSHELFLIFESTORAGEPERCENT]
    SHELFLIFEEXPIRATIONDATEPERIOD,  -- Period Ind. [SHELFLIFEEXPIRATIONDATEPERIOD]
    SHELFLIFEEXPRTNDATERNDINGRULE,  -- Rounding rule [SHELFLIFEEXPRTNDATERNDINGRULE]
    DUMMY_PRD_INCL_EEW_PS,          -- Dummy Field [PRD_INCL_EEW]
    PRIMARY KEY (CLIENT, DRAFTKEY)
);

Learn More