I_MRPMfgOrder

MRP Manufacturing Order | view: IMRPMFGORDER | Extraction: Not supported | Component: Fiori UI for Production Planning and Control

Tables used: VBAP, AFKO, AFKO, AFPO, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, PRTE, MATDOC_EXTRACT, MARA, AUFK, MARA, MKAL, T001, T001K, T001W, PROJ, PROJ, CNLDST_SHORTTX, PRPS, /SAPSLL/CLSNR, /SAPSLL/MARITC, /SAPSLL/NOSCA, MARC, T001W, MKAL_AEND, MKAL_AEND, MARC, /SAPSLL/TUNOS

🔑 Keys (2)
💰 Amounts
∑ Quantities (9)
📅 Dates (8)
☰ Categorical (2)
Other (14)
🔗 Relations (18)

Column Name	Description
ManufacturingOrder FK	Manufacturing Order ID
ManufacturingOrderItem	Manufacturing Order Item ID

Column Name	Description

Column Name	Description
📏 Production Unit of Measure (ProductionUnit):
MfgOrderPlannedTotalQty	Manufacturing Order Planned Total Quantity
MfgOrderPlannedScrapQty	Manufacturing Order Planned Scrap Quantity
ExpectedDeviationQuantity	Expected Yield Deviation
ActualDeliveredQuantity	Quantity of Goods Received for the Order Item
OpenQuantity	null
FixedLotSizeQuantity	Fixed lot size
MinimumLotSizeQuantity	Minimum Lot Size
MaximumLotSizeQuantity	Maximum Lot Size
LotSizeRoundingQuantity	Rounding value for purchase order quantity

Column Name	Description
MfgOrderPlannedStartDate	Manufacturing Order Planned Start Date
MfgOrderPlannedEndDate	Manufacturing Order Planned End Date
MfgOrderActualStartDate	Manufacturing Order Actual Start Date
MfgOrderActualEndDate	Manufacturing Order Actual End Date
MfgOrderActualReleaseDate	Manufacturing Order Actual Release Date
MfgOrderScheduledStartDate	Manufacturing Order Scheduled Start Date
MfgOrderScheduledEndDate	Manufacturing Order Scheduled End Date
MfgOrderScheduledReleaseDate	Manufacturing Order Scheduled Release Date

Column Name	Description
ManufacturingOrderCategory	Manufacturing Order Category	Show values
MfgOrderIsPartOfCollvOrder	Order is Part of Collective Order	Show values

Column Name	Description	Domain name
MaterialGoodsReceiptDuration	Goods Receipt Processing Duration in Days	DEC3
ManufacturingOrderImportance	Order Importance Code	CHAR1
MaterialPlannedDeliveryDurn	Planned Delivery Time in Days	DEC3
PurchasingGroup	Purchasing Group	EKGRP
TotalReplenishmentLeadTime	Total replenishment lead time (in workdays)	DEC3
ProductionVersionText	Short Text for Production Version	TEXT40
ProductionVersion	Production Version	VERID
ProductionLine	Production Line for Repetitive Manufacturing	ARBPL
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSDescription	WBS Element Name	TEXT40
ResponsiblePersonName	Name of responsible person (Project manager)	PS_VERNA
Project	Project definition	PS_PSPID
TopLevelOrder	Manufacturing Order ID	AUFNR
MfgOrderProgressStatus	null

Master Data Relations	Join Conditions
Sold-to Party Sold-to Party Client	`I_MRPMFGORDER.CUSTOMER == KNA1.KUNNR` `I_MRPMFGORDER.MANDT == KNA1.MANDT`
Manufacturing Order ID Manufacturing Order ID Manufacturing Order ID Client	`I_MRPMFGORDER.MANUFACTURINGORDER == AUFK.AUFNR` `I_MRPMFGORDER.TOPLEVELORDER == AUFK.AUFNR` `I_MRPMFGORDER.MANDT == AUFK.MANDT`
Manufacturing Order Type Sales Order Type Manufacturing Order Type Client	`I_MRPMFGORDER.SALESORDERTYPE == T003O.AUART` `I_MRPMFGORDER.MANUFACTURINGORDERTYPE == T003O.AUART` `I_MRPMFGORDER.MANDT == T003O.CLIENT`
Material Number for Order Client Material Number for Order Material Number Material Number for Order	`I_MRPMFGORDER.MANDT == MARA.MANDT` `I_MRPMFGORDER.MATERIAL == MARA.MATNR` `I_MRPMFGORDER.SALESORDERITEMMATERIAL == MARA.MATNR` `I_MRPMFGORDER.TOPLEVELORDERMATERIAL == MARA.MATNR`
MRP Controller Group MRP Controller ? Client	`I_MRPMFGORDER.MRPCONTROLLER == T024D.DISPO` `I_MRPMFGORDER.[column in domain "WERKS_D"] == T024D.WERKS` `I_MRPMFGORDER.MANDT == T024D.MANDT`
Planning Plant for an Order Planning Plant for an Order Client	`I_MRPMFGORDER.MRPPLANT == T001W.WERKS` `I_MRPMFGORDER.MANDT == T001W.MANDT`
Production Plant Production Plant Client	`I_MRPMFGORDER.PRODUCTIONPLANT == T001W.WERKS` `I_MRPMFGORDER.MANDT == T001W.MANDT`
Production Supervisor Production Supervisor ? Client	`I_MRPMFGORDER.PRODUCTIONSUPERVISOR == T024F.FEVOR` `I_MRPMFGORDER.[column in domain "WERKS_D"] == T024F.WERKS` `I_MRPMFGORDER.MANDT == T024F.MANDT`
Production Unit of Measure Production Unit of Measure Client	`I_MRPMFGORDER.PRODUCTIONUNIT == T006.MSEHI` `I_MRPMFGORDER.MANDT == T006.MANDT`
Project Project (internal) Client	`I_MRPMFGORDER.PROJECTINTERNALID == PROJ.PSPNR` `I_MRPMFGORDER.MANDT == PROJ.MANDT`
Project manager personnel number Responsible Person Number (Project Manager) Client	`I_MRPMFGORDER.RESPONSIBLEPERSON == TCJ04.VERNR` `I_MRPMFGORDER.MANDT == TCJ04.MANDT`
Rounding Profile ? ? Rounding Profile Client	`I_MRPMFGORDER.[column in domain "RDZAE"] == RDPR.RDZAE` `I_MRPMFGORDER.[column in domain "WERKS_D"] == RDPR.WERKS` `I_MRPMFGORDER.ROUNDINGPROFILE == RDPR.RDPRF` `I_MRPMFGORDER.MANDT == RDPR.MANDT`
Material: order item Client Material Number for Order Material Number Material Number for Order	`I_MRPMFGORDER.MANDT == MARA.MANDT` `I_MRPMFGORDER.MATERIAL == MARA.MATNR` `I_MRPMFGORDER.SALESORDERITEMMATERIAL == MARA.MATNR` `I_MRPMFGORDER.TOPLEVELORDERMATERIAL == MARA.MATNR`
Order type in order header Sales Order Type Manufacturing Order Type Client	`I_MRPMFGORDER.SALESORDERTYPE == TVAK.AUART` `I_MRPMFGORDER.MANUFACTURINGORDERTYPE == TVAK.AUART` `I_MRPMFGORDER.MANDT == TVAK.MANDT`
Material Number for Order Client Material Number for Order Material Number Material Number for Order	`I_MRPMFGORDER.MANDT == MARA.MANDT` `I_MRPMFGORDER.MATERIAL == MARA.MATNR` `I_MRPMFGORDER.SALESORDERITEMMATERIAL == MARA.MATNR` `I_MRPMFGORDER.TOPLEVELORDERMATERIAL == MARA.MATNR`