PROD_STORAGE

Transparent Table Application Table
19 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTSTORAGEWD

PROD_STORAGE is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTSTORAGEWD. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productstoraged view from EXTENSION Extension draft view-product storage

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
product matnr Material
storageconditions raube Stor.conditions
temperatureconditionind tempb Temperature
hazardousmaterialnumber stoff Haz. matl no.
nmbrofgrorgislipstoprintqty wesch GR slips quantity
labeltype etiar Label type
labelform etifo Label form
minremainingshelflife mhdrz Rem. Shelf Life
expirationdate sled_bbd Expiration Date
storagebininstruction behvo Container
totalshelflifestoragepercent mhdlp Storage %
shelflifeexpirationdateperiod shelflifeexpirationdateperiod Period Ind.
shelflifeexprtndaterndingrule rdmhd Rounding rule
authorizationgroup begru AuthorizGroup
baseunit meins Base Unit
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_PRODUCTSTORAGEWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_STORAGE (
    MANDT,                          -- Client [mandt]
    DRAFTUUID,                      -- Key [/bobf/uuid]
    PARENTDRAFTUUID,                -- Key [/bobf/uuid]
    PRODUCT,                        -- Material [matnr]
    STORAGECONDITIONS,              -- Stor.conditions [raube]
    TEMPERATURECONDITIONIND,        -- Temperature [tempb]
    HAZARDOUSMATERIALNUMBER,        -- Haz. matl no. [stoff]
    NMBROFGRORGISLIPSTOPRINTQTY,    -- GR slips quantity [wesch]
    LABELTYPE,                      -- Label type [etiar]
    LABELFORM,                      -- Label form [etifo]
    MINREMAININGSHELFLIFE,          -- Rem. Shelf Life [mhdrz]
    EXPIRATIONDATE,                 -- Expiration Date [sled_bbd]
    STORAGEBININSTRUCTION,          -- Container [behvo]
    TOTALSHELFLIFESTORAGEPERCENT,   -- Storage % [mhdlp]
    SHELFLIFEEXPIRATIONDATEPERIOD,  -- Period Ind. [shelflifeexpirationdateperiod]
    SHELFLIFEEXPRTNDATERNDINGRULE,  -- Rounding rule [rdmhd]
    AUTHORIZATIONGROUP,             -- AuthorizGroup [begru]
    BASEUNIT,                       -- Base Unit [meins]
    HASACTIVEENTITY,                -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More