PRD_STORAGE

Transparent Table Application Table
28 Fields 1 CDS Views

Product: Draft Storage Location Node

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ProductStorageLocationD view from BASIC

Fields (28)

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
activestoragelocation STORAGELOCATION Stor. Location
storagelocation STORAGELOCATION Stor. Location
warehousestoragebin WAREHOUSESTORAGEBIN Storage Bin
maintenancestatus MAINTENANCESTATUS Maint. status
ismarkedfordeletion ISMARKEDFORDELETION Deletion Flag
physicalinventoryblockind PHYSICALINVENTORYBLOCKIND Phys. Inv. Blk
creationdate CREATIONDATE Created On
dateoflastpostedcntunrstrcdstk DATEOFLASTPOSTEDCNTUNRSTRCDSTK Last Count Date
inventorycorrectionfactor INVENTORYCORRECTIONFACTOR Inven.cor.fact.
invtryrestrictedusestockind INVTRYRESTRICTEDUSESTOCKIND Restricted-use
invtrycurrentyearstockind INVTRYCURRENTYEARSTOCKIND Warehouse stock
invtryqualinspcurrentyrstkind INVTRYQUALINSPCURRENTYRSTKIND QualInspStock
inventoryblockstockind INVENTORYBLOCKSTOCKIND Blocked stock
invtryreststockprevperiodind INVTRYRESTSTOCKPREVPERIODIND Restricted use
inventorystockprevperiod INVENTORYSTOCKPREVPERIOD Warehouse stock
invtrystockqltyinspprevperiod INVTRYSTOCKQLTYINSPPREVPERIOD QualInspStock
hasinvtryblockstockprevperiod HASINVTRYBLOCKSTOCKPREVPERIOD Blocked stock
fiscalyearcurrentperiod FISCALYEARCURRENTPERIOD Year cur.period
fiscalmonthcurrentperiod FISCALMONTHCURRENTPERIOD Current period
fiscalyearcurrentinvtryperiod FISCALYEARCURRENTINVTRYPERIOD Fiscal Year of Current Physical Inventory Indicator
dummy_stl_incl_eew_ps STL_INCL_EEW MD PRODUCT Storage location

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 Storage Location Node
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRD_STORAGE (
    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]
    ACTIVESTORAGELOCATION,           -- Stor. Location [STORAGELOCATION]
    STORAGELOCATION,                 -- Stor. Location [STORAGELOCATION]
    WAREHOUSESTORAGEBIN,             -- Storage Bin [WAREHOUSESTORAGEBIN]
    MAINTENANCESTATUS,               -- Maint. status [MAINTENANCESTATUS]
    ISMARKEDFORDELETION,             -- Deletion Flag [ISMARKEDFORDELETION]
    PHYSICALINVENTORYBLOCKIND,       -- Phys. Inv. Blk [PHYSICALINVENTORYBLOCKIND]
    CREATIONDATE,                    -- Created On [CREATIONDATE]
    DATEOFLASTPOSTEDCNTUNRSTRCDSTK,  -- Last Count Date [DATEOFLASTPOSTEDCNTUNRSTRCDSTK]
    INVENTORYCORRECTIONFACTOR,       -- Inven.cor.fact. [INVENTORYCORRECTIONFACTOR]
    INVTRYRESTRICTEDUSESTOCKIND,     -- Restricted-use [INVTRYRESTRICTEDUSESTOCKIND]
    INVTRYCURRENTYEARSTOCKIND,       -- Warehouse stock [INVTRYCURRENTYEARSTOCKIND]
    INVTRYQUALINSPCURRENTYRSTKIND,   -- QualInspStock [INVTRYQUALINSPCURRENTYRSTKIND]
    INVENTORYBLOCKSTOCKIND,          -- Blocked stock [INVENTORYBLOCKSTOCKIND]
    INVTRYRESTSTOCKPREVPERIODIND,    -- Restricted use [INVTRYRESTSTOCKPREVPERIODIND]
    INVENTORYSTOCKPREVPERIOD,        -- Warehouse stock [INVENTORYSTOCKPREVPERIOD]
    INVTRYSTOCKQLTYINSPPREVPERIOD,   -- QualInspStock [INVTRYSTOCKQLTYINSPPREVPERIOD]
    HASINVTRYBLOCKSTOCKPREVPERIOD,   -- Blocked stock [HASINVTRYBLOCKSTOCKPREVPERIOD]
    FISCALYEARCURRENTPERIOD,         -- Year cur.period [FISCALYEARCURRENTPERIOD]
    FISCALMONTHCURRENTPERIOD,        -- Current period [FISCALMONTHCURRENTPERIOD]
    FISCALYEARCURRENTINVTRYPERIOD,   -- Fiscal Year of Current Physical Inventory Indicator [FISCALYEARCURRENTINVTRYPERIOD]
    DUMMY_STL_INCL_EEW_PS,           -- MD PRODUCT Storage location [STL_INCL_EEW]
    PRIMARY KEY (CLIENT, DRAFTKEY)
);

Learn More