A_MRPMaterial

Master Data | view: IMRPMATERIAL | Extraction: Not supported | Component: Material Requirements Planning
Column Name Description
Material Material Number
MRPPlant Plant
MRPArea MRP Area
Column Name Description
💲 Currency Key (Currency):
LotSizeIndependentCosts Lot-Size-Independent Costs
Column Name Description
📏 Base Unit of Measure (BaseUnit):
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
MaterialName Product Description TEXT40
PlantName Plant Name TEXT30
MRPAreaText MRP Area Text BERTX
MRPAreaCategoryName MRP Area Category Name DDTEXT
MaterialGroupName Product Group Description TEXT20
CrossPlantStatusName Cross Plant Status Text TEXT25
UnitOfMeasureName Unit of Measurement Text (Maximum 10 Characters) TEXT10
LowLevelCode Low-Level Code DISST
MaterialUsabilityProfileName Cross Plant Status Text TEXT25
MaterialABCClassificationDesc Consumption Value Category Text TEXT30
PurchasingGroupName Purchasing Group Name TEXT18
MaterialProcurementCatName Material Procurement Category Name DDTEXT
DependentRequirementsTypeName Short Text for Fixed Values DDTEXT
MatlCompDiscontinuationType null
MatlCompDscontnTypeName Short Text for Fixed Values DDTEXT
MaterialTypeName Description of product type TEXT25
MRPGroup MRP Group DISGR
MRPGroupName MRP Group Description TEXT40
MRPController MRP Controller DISPO
MRPControllerName MRP Controller Name TEXT18
ConfigurableProductName Product Description TEXT40
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
MaterialLotSizingProcedureName Name of Lot-Sizing Procedure TEXT40
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
MRPTypeName Material Requirements Planning Type Description DIBEZ
MaterialProcurementProfile Special procurement type SOBSL
MaterialProcurementProfileName Material Procurement Profile Name TEXT40
ProductionSupervisorName Production Supervisor Name TEXT30
ProductionInvtryManagedLoc Issue Storage Location LGORT
StorageLocationName Storage Location Name TEXT16
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Unit of Measure
  • Client
  • Base Unit of Measure
  • A_MRPMATERIAL.MANDT == T006.MANDT
  • A_MRPMATERIAL.BASEUNIT == T006.MSEHI
Configurable material
  • Configurable material
  • Client
  • A_MRPMATERIAL.CONFIGURABLEPRODUCT == MARA.MATNR
  • A_MRPMATERIAL.MANDT == MARA.MANDT
Cross-Plant Product Status
  • Client
  • Cross-Plant Product Status
  • A_MRPMATERIAL.MANDT == T141.MANDT
  • A_MRPMATERIAL.CROSSPLANTSTATUS == T141.MMSTA
Currency Key
  • Client
  • Currency Key
  • A_MRPMATERIAL.MANDT == TCURC.MANDT
  • A_MRPMATERIAL.CURRENCY == TCURC.WAERS
Value Table for ABC Indicator
  • Client
  • ABC Indicator
  • A_MRPMATERIAL.MANDT == TMABC.MANDT
  • A_MRPMATERIAL.MATERIALABCCLASSIFICATION == TMABC.MAABC
Material Group
  • Product Group
  • Client
  • A_MRPMATERIAL.MATERIALGROUP == T023.MATKL
  • A_MRPMATERIAL.MANDT == T023.MANDT
Product Type
  • Client
  • Product Type
  • A_MRPMATERIAL.MANDT == T134.MANDT
  • A_MRPMATERIAL.MATERIALTYPE == T134.MTART
Plant-Specific Material Status
  • Client
  • Plant-Specific Material Status
  • A_MRPMATERIAL.MANDT == T141.MANDT
  • A_MRPMATERIAL.MATERIALUSABILITYPROFILE == T141.MMSTA
Planning Strategy Group
  • Client
  • Planning Strategy Group
  • A_MRPMATERIAL.MANDT == T461P.MANDT
  • A_MRPMATERIAL.PLANNINGSTRATEGYGROUP == T461P.STRGR
Work scheduler group
  • Production Supervisor
  • Client
  • Plant
  • A_MRPMATERIAL.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • A_MRPMATERIAL.MANDT == T024F.MANDT
  • A_MRPMATERIAL.MRPPLANT == T024F.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • A_MRPMATERIAL.MANDT == T024.MANDT
  • A_MRPMATERIAL.PURCHASINGGROUP == T024.EKGRP
Plant range of coverage profile
  • Client
  • Plant
  • Range of coverage profile
  • A_MRPMATERIAL.MANDT == T438R.MANDT
  • A_MRPMATERIAL.MRPPLANT == T438R.WERKS
  • A_MRPMATERIAL.RANGEOFCVRGPRFLCODE == T438R.RWPRO
Repetitive Manufacturing Profile
  • Client
  • Repetitive Manufacturing Profile
  • A_MRPMATERIAL.MANDT == T437S.MANDT
  • A_MRPMATERIAL.REPETITIVEMANUFACTURINGPROFILE == T437S.SFPRO
Scheduling margin key
  • Scheduling Margin Key for Floats
  • Client
  • Plant
  • A_MRPMATERIAL.SCHEDULINGFLOATPROFILE == T436A.FHORI
  • A_MRPMATERIAL.MANDT == T436A.MANDT
  • A_MRPMATERIAL.MRPPLANT == T436A.WERKS