C_MRPMfgOrder

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

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

🔑 Keys (2)
💰 Amounts
∑ Quantities (8)
📅 Dates (5)
☰ Categorical (1)
Other (23)
🔗 Relations (14)

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

Column Name	Description

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

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

Column Name	Description
ManufacturingOrderCategory	Manufacturing Order Category	Show values

Column Name	Description	Domain name
MaterialName	Material Description	TEXT40
ProductionSupervisorName	Production Supervisor Name	TEXT30
MRPControllerName	MRP Controller Name	TEXT18
MRPControllerPhoneNumber	MRP Controller's Phone Number	CHAR12
EmailAddress	E-Mail Address	AD_SMTPADR
MaterialPlannedDeliveryDurn	Planned Delivery Time in Days	DEC3
TotalReplenishmentLeadTime	Total replenishment lead time (in workdays)	DEC3
MaterialRoundingProfileName	Text, 40 Characters Long	TEXT40
ManufacturingOrderTypeName	Manufacturing Order Type Name	TEXT40
MfgOrderProgressStatus	null
MaterialGoodsReceiptDuration	Goods Receipt Processing Duration in Days	DEC3
ProductionVersion	Production Version	VERID
ProductionVersionText	Short Text for Production Version	TEXT40
ProductionLine	Production Line for Repetitive Manufacturing	ARBPL
ManufacturingOrderImportance	Order Importance Code	CHAR1
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
ProjectDescription	Project Definition Name	TEXT40
SalesOrderItemMaterialName	Material Description	TEXT40
TopLevelOrder	Manufacturing Order ID	AUFNR
TopLevelOrderMaterialName	Material Description	TEXT40

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