P_MRPMATERIAL

MRP Material | view: PMRPMATRL | Extraction: Not supported | Component: Material Requirements Planning
Tables used: PPH_DBVMMARAMDLVMARAMARCMDFDMDFDDBMDMAT460AT460A
Column Name Description
Material Material Number
MRPPlant Plant
MRPArea MRP Area
Column Name Description
LotSizeIndependentCosts Lot-Size-Independent Costs
Column Name Description
MinimumLotSizeQuantity Minimum Lot Size
MaximumLotSizeQuantity Maximum Lot Size
FixedLotSizeQuantity Fixed lot size
MaterialMaxStockLevelQuantity Maximum Stock Level
PurOrderQtyRoundingQty Rounding value for purchase order quantity
MaterialBaseQuantity Base quantity
Column Name Description
EffectiveOutDate Effective-Out Date
Column Name Description
MRPAreaCategory MRP Area Category Show values
MaterialIsMarkedForDeletion Deletion Indicator Show values
PlntMatlIsMarkedForDeletion Flag Material for Deletion at Plant Level Show values
MaterialIsConfigurable Product is Configurable Show values
MaterialProcurementCategory Procurement Type Show values
DependentRequirementsType Dependent requirements ind. for individual and coll. reqmts Show values
IsSafetyTime Safety time indicator (with or without safety time) Show values
RepetitiveManufacturingIsAllwd Indicator: Repetitive Manufacturing Allowed Show values
Column Name Description Domain name
LowLevelCode Low-Level Code DISST
MatlCompDiscontinuationType null
MRPGroup MRP Group DISGR
MRPController MRP Controller DISPO
ProcessingTime Processing time DEC3_2
SetupAndTeardownTime Setup and teardown time DEC3_2
TransitionTime Interoperation time DEC3_2
GoodsReceiptDuration Goods receipt processing time in days DEC3
MaterialPlannedDeliveryDurn Planned Delivery Time in Days DEC3
MaterialPlannedProductionDurn In-house production time DEC3
TotalReplenishmentLeadDuration Total replenishment lead time (in workdays) DEC3
MRPSafetyDuration Safety Time (in Workdays) NUMC2
PerdPrflForSftyTme Period Profile for Safety Time SHPRO
ReorderThresholdQuantity null
SafetyStockQuantity null
LotSizingProcedure Lot Sizing Procedure within Materials Planning DISLS
StorageCostsPercentageCode Storage Costs Percentage Code LAGPR
AssemblyScrapPercent Assembly scrap in percent DEC3_2
TaktTime Takt time DEC3
RoundingProfile Rounding Profile RDPRF
DfltStorageLocationExtProcmt Default storage location for external procurement LGORT
MRPPlanningCalendar PPC Planning Calendar MRPPP
PlanningTimeFenceInDays Planning time fence FXHOR
MRPType MRP Type DISMM
MaterialProcurementProfile Special procurement type SOBSL
ProductionInvtryManagedLoc Issue Storage Location LGORT
IsMarkedForDeletion null
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Unit of Measure
  • Client
  • Base Unit of Measure
  • P_MRPMATERIAL.MANDT == T006.MANDT
  • P_MRPMATERIAL.BASEUNIT == T006.MSEHI
Configurable material
  • Client
  • Configurable material
  • P_MRPMATERIAL.MANDT == MARA.MANDT
  • P_MRPMATERIAL.CONFIGURABLEPRODUCT == MARA.MATNR
Cross-Plant Product Status
  • Client
  • Cross-Plant Product Status
  • P_MRPMATERIAL.MANDT == T141.MANDT
  • P_MRPMATERIAL.CROSSPLANTSTATUS == T141.MMSTA
Value Table for ABC Indicator
  • Client
  • ABC Indicator
  • P_MRPMATERIAL.MANDT == TMABC.MANDT
  • P_MRPMATERIAL.MATERIALABCCLASSIFICATION == TMABC.MAABC
Material Group
  • Client
  • Product Group
  • P_MRPMATERIAL.MANDT == T023.MANDT
  • P_MRPMATERIAL.MATERIALGROUP == T023.MATKL
Product Type
  • Product Type
  • Client
  • P_MRPMATERIAL.MATERIALTYPE == T134.MTART
  • P_MRPMATERIAL.MANDT == T134.MANDT
Plant-Specific Material Status
  • Client
  • Plant-Specific Material Status
  • P_MRPMATERIAL.MANDT == T141.MANDT
  • P_MRPMATERIAL.MATERIALUSABILITYPROFILE == T141.MMSTA
Planning Strategy Group
  • Client
  • Planning Strategy Group
  • P_MRPMATERIAL.MANDT == T461P.MANDT
  • P_MRPMATERIAL.PLANNINGSTRATEGYGROUP == T461P.STRGR
Work scheduler group
  • Plant
  • Production Supervisor
  • Client
  • P_MRPMATERIAL.MRPPLANT == T024F.WERKS
  • P_MRPMATERIAL.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • P_MRPMATERIAL.MANDT == T024F.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • P_MRPMATERIAL.MANDT == T024.MANDT
  • P_MRPMATERIAL.PURCHASINGGROUP == T024.EKGRP
Plant range of coverage profile
  • Plant
  • Client
  • Range of coverage profile
  • P_MRPMATERIAL.MRPPLANT == T438R.WERKS
  • P_MRPMATERIAL.MANDT == T438R.MANDT
  • P_MRPMATERIAL.RANGEOFCVRGPRFLCODE == T438R.RWPRO
Repetitive Manufacturing Profile
  • Client
  • Repetitive Manufacturing Profile
  • P_MRPMATERIAL.MANDT == T437S.MANDT
  • P_MRPMATERIAL.REPETITIVEMANUFACTURINGPROFILE == T437S.SFPRO
Scheduling margin key
  • Plant
  • Client
  • Scheduling Margin Key for Floats
  • P_MRPMATERIAL.MRPPLANT == T436A.WERKS
  • P_MRPMATERIAL.MANDT == T436A.MANDT
  • P_MRPMATERIAL.SCHEDULINGFLOATPROFILE == T436A.FHORI