_PRODUCTSTORAGELOCATION

18 Fields

_PRODUCTSTORAGELOCATION is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
KEY StorageLocation StorageLocation 2
CreationDate CreationDate,CreationDateMaterial 2
DateOfLastPostedCntUnRstrcdStk DateOfLastPostedCntUnRstrcdStk 1
FiscalMonthCurrentPeriod FiscalMonthCurrentPeriod 1
FiscalYearCurrentInvtryPeriod FiscalYearCurrentInvtryPeriod 1
FiscalYearCurrentPeriod FiscalYearCurrentPeriod 1
HasInvtryBlockStockPrevPeriod HasInvtryBlockStockPrevPeriod 1
InventoryBlockStockInd InventoryBlockStockInd 1
InventoryCorrectionFactor InventoryCorrectionFactor 1
InventoryStockPrevPeriod InventoryStockPrevPeriod 1
InvtryCurrentYearStockInd InvtryCurrentYearStockInd 1
InvtryQualInspCurrentYrStkInd InvtryQualInspCurrentYrStkInd 1
InvtryRestrictedUseStockInd InvtryRestrictedUseStockInd 1
InvtryRestStockPrevPeriodInd InvtryRestStockPrevPeriodInd 1
InvtryStockQltyInspPrevPeriod InvtryStockQltyInspPrevPeriod 1
MaintenanceStatus MaintenanceStatus 1
PhysicalInventoryBlockInd PhysicalInventoryBlockInd 1
WarehouseStorageBin WarehouseStorageBin 8

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PRODUCTSTORAGELOCATION (
    STORAGELOCATION,
    CREATIONDATE,
    DATEOFLASTPOSTEDCNTUNRSTRCDSTK,
    FISCALMONTHCURRENTPERIOD,
    FISCALYEARCURRENTINVTRYPERIOD,
    FISCALYEARCURRENTPERIOD,
    HASINVTRYBLOCKSTOCKPREVPERIOD,
    INVENTORYBLOCKSTOCKIND,
    INVENTORYCORRECTIONFACTOR,
    INVENTORYSTOCKPREVPERIOD,
    INVTRYCURRENTYEARSTOCKIND,
    INVTRYQUALINSPCURRENTYRSTKIND,
    INVTRYRESTRICTEDUSESTOCKIND,
    INVTRYRESTSTOCKPREVPERIODIND,
    INVTRYSTOCKQLTYINSPPREVPERIOD,
    MAINTENANCESTATUS,
    PHYSICALINVENTORYBLOCKIND,
    WAREHOUSESTORAGEBIN,
    PRIMARY KEY (STORAGELOCATION)
);

Learn More