P_MaterialPlantStorageLocation

Material including Plant and Storage Location | view: PMATPLANTSLOC | Extraction: Not supported | Component: Plant Maintenance
Column Name Description
Material Material Number
Plant Plant
StorageLocation Storage location
Column Name Description
Column Name Description
📏 Weight Unit (MaterialWeightUnit):
MaterialGrossWeight Gross weight
MaterialNetWeight Net weight
MinimumLotSizeQuantity Minimum Lot Size
MaximumLotSizeQuantity Maximum Lot Size
FixedLotSizeQuantity Fixed lot size
StockInTransferQuantity null
StockInTransitQuantity null
GoodsReceiptBlockedStockQty null
SafetyStockQuantity Safety Stock
Column Name Description
CreationDate Created On
DateOfLastPostedCntUnRstrcdStk Date of Last Posted Count
ProfileValidityStartDate Date from Which the Plant-Specific Material Status Is Valid
ConsumptionRefUsageEndDate To date of the material to be copied for consumption
Column Name Description
PhysicalInventoryBlockInd Physical Inventory Blocking Indicator Show values
PeriodType Period Indicator Show values
IsCoProduct Indicator: Material can be co-product Show values
HasPostToInspectionStock Has Post to Inspection Stock Show values
IsBatchManagementRequired Batch Management Requirement Indicator for Plant Show values
IsNegativeStockAllowed Negative stocks allowed in plant Show values
IsPurgAcrossPurgGroup Purchasing Across Purchasing Group Show values
IsInternalBatchManaged Batch management indicator (internal) Show values
ProductCFOPCategory Material CFOP category Show values
ProcurementType Procurement Type Show values
Column Name Description Domain name
WarehouseStorageBin Storage Bin CHAR10
MaintenanceStatus Maintenance status PSTAT
InventoryCorrectionFactor Inventory Correction Factor FLTP
InvtryRestrictedUseStockInd Physical inventory indicator for restricted-use stock INVKZ
InvtryCurrentYearStockInd Physical inventory indicator for whse stock in current year INVKZ
InvtryQualInspCurrentYrStkInd Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
InventoryBlockStockInd Physical inventory indicator for blocked stock INVKZ
InvtryRestStockPrevPeriodInd Physical inventory ind. for restricted-use stock, prev.pd INVKZ
InventoryStockPrevPeriod Physical inventory indicator for stock in previous year INVKZ
InvtryStockQltyInspPrevPeriod Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
HasInvtryBlockStockPrevPeriod Phys. inventory indicator for blocked stock in prev. period INVKZ
FiscalYearCurrentPeriod null
FiscalMonthCurrentPeriod null
FiscalYearCurrentInvtryPeriod Fiscal year of current physical inventory indicator GJAHR
MaterialManufacturerPartNumber Manufacturer Part Number CHAR40
Product Material Number MATNR
PurchasingGroup Purchasing Group EKGRP
CountryOfOrigin Country/Region of Origin of Material (Non-Preferential Ori.) LAND1
RegionOfOrigin Region of Origin of Material (Non-Preferential Origin) REGIO
ProductionInvtryManagedLoc Issue Storage Location LGORT
ProfileCode Plant-Specific Material Status MMSTA
AvailabilityCheckType Checking Group for Availability Check MTVFP
FiscalYearVariant Fiscal Year Variant PERIV
ProfitCenter Profit Center PRCTR
Commodity Commodity Code STAWN
GoodsReceiptDuration Goods receipt processing time in days DEC3
MaintenanceStatusName Maintenance status PSTAT
MRPType MRP Type DISMM
MRPResponsible MRP Controller DISPO
ABCIndicator ABC Indicator MAABC
ConsumptionTaxCtrlCode Control code for consumption taxes in foreign trade STEUC
ProductIsConfigurable Configurable Product MATNR
StockDeterminationGroup Stock determination group BF_GROUP
SerialNumberProfile Serial Number Profile SERAIL
HasConsignmentCtrl Consignment Control WRF_CONS_PROCG
UnderDelivToleranceLimit Underdelivery tolerance limit DEC2_1
OverDelivToleranceLimit Overdelivery tolerance limit DEC2_1
SpecialProcurementType Special procurement type SOBSL
ProductionSchedulingProfile Production Scheduling Profile CO_PRODPRF
ProductionSupervisor Production Supervisor FEVOR
SourceOfSupplyCategory Source of Supply BQSCL
ConsumptionReferenceProduct Reference material for consumption MATNR
ConsumptionReferencePlant Reference plant for consumption WERKS
ConsumptionQtyMultiplier Multiplier for reference material for consumption DEC2_2
ProductUnitGroup Unit of Measure Group MEGRU
DistrCntrDistributionProfile Distribution profile of material in plant MPPRF
ConsignmentControl Consignment Control WRF_CONS_PROCG
GoodIssueProcessingDays Goods Issue Processing Time in Days DEC3
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Unit of Measure
  • Client
  • Base Unit of Measure
  • P_MATERIALPLANTSTORAGELOCATION.MANDT == T006.MANDT
  • P_MATERIALPLANTSTORAGELOCATION.MATERIALBASEUNIT == T006.MSEHI
Material Group
  • Client
  • Material Group
  • P_MATERIALPLANTSTORAGELOCATION.MANDT == T023.MANDT
  • P_MATERIALPLANTSTORAGELOCATION.MATERIALGROUP == T023.MATKL
Manufacturer Number
  • Client
  • Manufacturer number
  • P_MATERIALPLANTSTORAGELOCATION.MANDT == LFA1.MANDT
  • P_MATERIALPLANTSTORAGELOCATION.MATERIALMANUFACTURERNUMBER == LFA1.LIFNR
Material type
  • Client
  • Material type
  • P_MATERIALPLANTSTORAGELOCATION.MANDT == T134.MANDT
  • P_MATERIALPLANTSTORAGELOCATION.MATERIALTYPE == T134.MTART
Unit of Weight
  • Client
  • Weight Unit
  • P_MATERIALPLANTSTORAGELOCATION.MANDT == T006.MANDT
  • P_MATERIALPLANTSTORAGELOCATION.MATERIALWEIGHTUNIT == T006.MSEHI