P_ProductStorageLocationBasic

Product Storage Location | view: PPRDSTORLOCBASIC | Extraction: Not supported | Component: Material Master
Tables used: MARD
Column Name Description
Product FK Product Number
Plant FK Plant
StorageLocation FK Storage location
Column Name Description
Column Name Description
StorLocMRPReplnmtQtyInBaseUoM Replenishment quantity for storage location MRP
Column Name Description
DateOfLastPostedCntUnRstrcdStk Date of Last Posted Count
CreationDate Created On
Column Name Description
IsMarkedForDeletion Flag Material for Deletion at Storage Location Level Show values
PhysicalInventoryBlockInd Physical Inventory Blocking Indicator Show values
StorLocMRP Storage location MRP indicator Show values
Column Name Description Domain name
MaintenanceStatus Maintenance status PSTAT
InvtryCurrentYearStockInd Physical inventory indicator for whse stock in current year INVKZ
InvtryQualInspCurrentYrStkInd Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
InvtryRestrictedUseStockInd Physical inventory indicator for restricted-use stock INVKZ
InventoryBlockStockInd Physical inventory indicator for blocked stock INVKZ
InventoryStockPrevPeriod Physical inventory indicator for stock in previous year INVKZ
InvtryStockQltyInspPrevPeriod Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
InvtryRestStockPrevPeriodInd Physical inventory ind. for restricted-use stock, prev.pd INVKZ
HasInvtryBlockStockPrevPeriod Phys. inventory indicator for blocked stock in prev. period INVKZ
WarehouseStorageBin Storage Bin CHAR10
LeanWrhsManagementPickingArea Picking area for lean WM KOBER
InventoryCorrectionFactor Inventory Correction Factor FLTP
FiscalYearCurrentInvtryPeriod Fiscal year of current physical inventory indicator GJAHR
Master Data Relations Join Conditions
Country of origin
  • Client
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • P_PRODUCTSTORAGELOCATIONBASIC.MANDT == T005.MANDT
  • P_PRODUCTSTORAGELOCATIONBASIC.COUNTRYOFORIGIN == T005.LAND1
Material number/plant
  • Client
  • Product Number
  • Plant
  • P_PRODUCTSTORAGELOCATIONBASIC.MANDT == MARC.MANDT
  • P_PRODUCTSTORAGELOCATIONBASIC.PRODUCT == MARC.MATNR
  • P_PRODUCTSTORAGELOCATIONBASIC.PLANT == MARC.WERKS
Product Number
  • Client
  • Product Number
  • P_PRODUCTSTORAGELOCATIONBASIC.MANDT == MARA.MANDT
  • P_PRODUCTSTORAGELOCATIONBASIC.PRODUCT == MARA.MATNR
Storage location
  • Client
  • Storage location
  • Plant
  • P_PRODUCTSTORAGELOCATIONBASIC.MANDT == T001L.MANDT
  • P_PRODUCTSTORAGELOCATIONBASIC.STORAGELOCATION == T001L.LGORT
  • P_PRODUCTSTORAGELOCATIONBASIC.PLANT == T001L.WERKS
Special procurement type
  • Special procurement type at storage location level
  • Client
  • Plant
  • P_PRODUCTSTORAGELOCATIONBASIC.STORLOCSPECIALPROCUREMENTTYPE == T460A.SOBSL
  • P_PRODUCTSTORAGELOCATIONBASIC.MANDT == T460A.MANDT
  • P_PRODUCTSTORAGELOCATIONBASIC.PLANT == T460A.WERKS