PROD_PLNT_SLSTOR

Transparent Table Application Table
32 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTSTORAGELOCATIONWD

PROD_PLNT_SLSTOR is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTSTORAGELOCATIONWD. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productstoragelocationd view from EXTENSION Ext draft view PrdStorage (PRD_STORAGE)

Fields (32)

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
storagelocation LGORT_D Location
plantforedit WERKS_D Plant
storagelocationforedit LGORT_D Location
warehousestoragebin LGPBE Storage Bin
maintenancestatus PSTAT_D Maint. Status
ismarkedfordeletion LVOLG DF stor.loc.lvl
physicalinventoryblockind SPERR Phys. Inv. Blk
creationdate ERSDA Created On
dateoflastpostedcntunrstrcdstk DLINL Last Count Date
inventorycorrectionfactor BSKRF Inven.cor.fact.
invtryrestrictedusestockind KZILE Restricted-use
invtrycurrentyearstockind KZILL Warehouse stock
invtryqualinspcurrentyrstkind KZILQ QualInspStock
inventoryblockstockind KZILS Blocked stock
invtryreststockprevperiodind KZVLE Restricted use
inventorystockprevperiod KZVLL Warehouse stock
invtrystockqltyinspprevperiod KZVLQ QualInspStock
hasinvtryblockstockprevperiod KZVLS Blocked stock
fiscalyearcurrentinvtryperiod GJINV Fiscal year of current physical inventory indicator
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code
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.

-- I_PRODUCTWD I_PRODUCTSTORAGELOCATIONWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_PLNT_SLSTOR (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    PARENTDRAFTUUID,                 -- Key [/BOBF/UUID]
    ROOTDRAFTUUID,                   -- Key [/BOBF/UUID]
    PRODUCT,                         -- Product [PRODUCTNUMBER]
    PLANT,                           -- Plant [WERKS_D]
    STORAGELOCATION,                 -- Location [LGORT_D]
    PLANTFOREDIT,                    -- Plant [WERKS_D]
    STORAGELOCATIONFOREDIT,          -- Location [LGORT_D]
    WAREHOUSESTORAGEBIN,             -- Storage Bin [LGPBE]
    MAINTENANCESTATUS,               -- Maint. Status [PSTAT_D]
    ISMARKEDFORDELETION,             -- DF stor.loc.lvl [LVOLG]
    PHYSICALINVENTORYBLOCKIND,       -- Phys. Inv. Blk [SPERR]
    CREATIONDATE,                    -- Created On [ERSDA]
    DATEOFLASTPOSTEDCNTUNRSTRCDSTK,  -- Last Count Date [DLINL]
    INVENTORYCORRECTIONFACTOR,       -- Inven.cor.fact. [BSKRF]
    INVTRYRESTRICTEDUSESTOCKIND,     -- Restricted-use [KZILE]
    INVTRYCURRENTYEARSTOCKIND,       -- Warehouse stock [KZILL]
    INVTRYQUALINSPCURRENTYRSTKIND,   -- QualInspStock [KZILQ]
    INVENTORYBLOCKSTOCKIND,          -- Blocked stock [KZILS]
    INVTRYRESTSTOCKPREVPERIODIND,    -- Restricted use [KZVLE]
    INVENTORYSTOCKPREVPERIOD,        -- Warehouse stock [KZVLL]
    INVTRYSTOCKQLTYINSPPREVPERIOD,   -- QualInspStock [KZVLQ]
    HASINVTRYBLOCKSTOCKPREVPERIOD,   -- Blocked stock [KZVLS]
    FISCALYEARCURRENTINVTRYPERIOD,   -- Fiscal year of current physical inventory indicator [GJINV]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    DUMMY_STL_INCL_EEW_PS,           -- MD PRODUCT Storage location [STL_INCL_EEW]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More