I_MRPMfgOrderItem

MRP Manufacturing Order Item | view: IMRPMFGORDERITEM | Extraction: Not supported | Component: Fiori UI for Production Planning and Control
Tables used: AFPOMARAMDMAMDLGMARAT001T001KT001WMARC
Column Name Description
OrderID FK Order Number
OrderItem Order Item
MRPPlant FK Planning Plant for an Order
Material FK Material Number for Order
StorageLocation FK Storage Location
Column Name Description
Column Name Description
📏 Production Unit of Measure (ProductionUnit):
ItemQuantity Order Item Planned Total Quantity
MfgOrderItemGoodsReceiptQty Quantity of Goods Received for the Order Item
MfgOrderItemActualDeviationQty Expected Surplus/Deficit For Goods Receipt
Column Name Description
PlannedEndDate Basic finish date
ActualDeliveryDate Actual Delivery/Finish Date
Column Name Description
OrderCategory Order Category Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
ConsumptionPosting Consumption posting Show values
Column Name Description Domain name
MfgOrderItemQtyToBaseQtyDnmntr Denominator for conversion to base units of measure UMBSN
MfgOrderItemQtyToBaseQtyNmrtr Numerator for Conversion to Base Units of Measure UMBSZ
MaterialGoodsReceiptDuration Goods Receipt Processing Duration in Days DEC3
ProductionVersion Production Version VERID
OrderIsReleased null
OrderItemIsNotRelevantForMRP Indicator: Order Item is not Relevant for MRP CHAR1
SettlementReservation Settlement Reservation RSNUM
SettlementReservationItem Settlement Reservation Item RSPOS
MRPArea null
MRPPlanningSegmentType null
MRPPlanningSegment null
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_MRPMFGORDERITEM.BASEUNIT == T006.MSEHI
  • I_MRPMFGORDERITEM.MANDT == T006.MANDT
Inventory Special Stock Type
  • Client
  • Inventory Special Stock Type
  • I_MRPMFGORDERITEM.MANDT == T148.MANDT
  • I_MRPMFGORDERITEM.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Material Number for Order
  • Client
  • Material Number for Order
  • I_MRPMFGORDERITEM.MANDT == MARA.MANDT
  • I_MRPMFGORDERITEM.MATERIAL == MARA.MATNR
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • I_MRPMFGORDERITEM.MANDT == T001W.MANDT
  • I_MRPMFGORDERITEM.MRPPLANT == T001W.WERKS
Order Number
  • Order Number
  • Client
  • I_MRPMFGORDERITEM.ORDERID == AUFK.AUFNR
  • I_MRPMFGORDERITEM.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_MRPMFGORDERITEM.ORDERTYPE == T003O.AUART
  • I_MRPMFGORDERITEM.MANDT == T003O.CLIENT
Production Plant
  • Client
  • Production Plant
  • I_MRPMFGORDERITEM.MANDT == T001W.MANDT
  • I_MRPMFGORDERITEM.PRODUCTIONPLANT == T001W.WERKS
Production Unit of Measure
  • Client
  • Production Unit of Measure
  • I_MRPMFGORDERITEM.MANDT == T006.MANDT
  • I_MRPMFGORDERITEM.PRODUCTIONUNIT == T006.MSEHI
Storage Location
  • Storage Location
  • Client
  • Planning Plant for an Order
  • I_MRPMFGORDERITEM.STORAGELOCATION == T001L.LGORT
  • I_MRPMFGORDERITEM.MANDT == T001L.MANDT
  • I_MRPMFGORDERITEM.MRPPLANT == T001L.WERKS