pp_mrp_read_mfg_order

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

Tables used: AFKO, AFPO, VBAK, VBAP, KNA1, MARC, MKAL, PROJ, PRPS, T024

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

Column Name	Description

Column Name	Description

Column Name	Description
MaterialFixedLotSizeQuantity	Fixed lot size
MaterialMinLotSizeQuantity	Minimum Lot Size
MaterialMaxLotSizeQuantity	Maximum Lot Size
MaterialRoundingQuantity	Rounding value for purchase order quantity
PlannedTotalQty	Total Order Quantity
PlannedScrapQty	Total Scrap Quantity in the Order
OpenQuantity	null
📏 Unit of measure for in-house production (ProductionUnit):
ExpectedDeviationQty	Expected Surplus/Deficit For Goods Receipt
DeliveredQuantity	Quantity of Goods Received for the Order Item

Column Name	Description
PlannedStartDate	Basic Start Date
PlannedEndDate	Basic finish date
ActualStartDate	Actual start date
ActualEndDate	Confirmed Order Finish Date
ActualReleaseDate	Actual release date
ScheduledStartDate	Scheduled start
ScheduledEndDate	Scheduled finish
ScheduledReleaseDate	Scheduled release date

Column Name	Description
ManufacturingOrderCategory	Order category	Show values
IsPartOfCollectiveOrder	Order is Part of Collective Order	Show values

Column Name	Description	Domain name
ManufacturingOrder	Order Number	AUFNR
ManufacturingOrderItem	Order item number	CO_POSNR
ManufacturingOrderType	Order Type	AUFART
ProductionVersion	Production Version	VERID
ProductionVersionText	Short Text for Production Version	TEXT40
ProductionLine	Production Line for Repetitive Manufacturing	ARBPL
ResourceNetwork	null
MaterialGoodsReceiptDuration	Goods Receipt Processing Duration in Days	DEC3
MaterialPlannedDeliveryDurn	Planned Delivery Time in Days	DEC3
MaterialPlannedProductionDurn	In-house production time	DEC3
MattotalReplenishmentLeadDurn	Total replenishment lead time (in workdays)	DEC3
PurchasingGroupName	Description of purchasing group	TEXT18
PurchasingGroupPhoneNumber	null
PurchasingGroupEmailAddress	E-Mail Address	AD_SMTPADR
SuperiorOrder	Number of Superior Order	AUFNR
CustomerName	Name 1	NAME
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSDescription	PS: Short description (1st text line)	TEXT40
WBSResponsiblePersonName	Name of responsible person (Project manager)	PS_VERNA
Project	Project definition	PS_PSPID
ProjectDescription	PS: Short description (1st text line)	TEXT40
ProductionSupervisor	Production Supervisor	FEVOR
MRPController	MRP controller for the order	DISPO
OrderImportance	Order priority	CHAR1
QuickviewCategory	null

Master Data Relations	Join Conditions
Sold-to Party Client Sold-to Party	`PP_MRP_READ_MFG_ORDER.MANDT == KNA1.MANDT` `PP_MRP_READ_MFG_ORDER.CUSTOMER == KNA1.KUNNR`
Special Stock Indicator Special Stock Indicator Client	`PP_MRP_READ_MFG_ORDER.INVENTORYSPECIALSTOCK == T148.SOBKZ` `PP_MRP_READ_MFG_ORDER.MANDT == T148.MANDT`
Material Number for Order Material Number for Order Material Number Material Number for Order Client	`PP_MRP_READ_MFG_ORDER.MATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER.SALESORDERITEMMATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER.TOPLEVELORDERMATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER.MANDT == MARA.MANDT`
Rounding Profile Client Rounding Profile ? ?	`PP_MRP_READ_MFG_ORDER.MANDT == RDPR.MANDT` `PP_MRP_READ_MFG_ORDER.MATERIALROUNDINGPROFILE == RDPR.RDPRF` `PP_MRP_READ_MFG_ORDER.[column in domain "RDZAE"] == RDPR.RDZAE` `PP_MRP_READ_MFG_ORDER.[column in domain "WERKS_D"] == RDPR.WERKS`
Planning Plant for an Order Client Planning Plant for an Order	`PP_MRP_READ_MFG_ORDER.MANDT == T001W.MANDT` `PP_MRP_READ_MFG_ORDER.MRPPLANT == T001W.WERKS`
Plant Client Plant	`PP_MRP_READ_MFG_ORDER.MANDT == T001W.MANDT` `PP_MRP_READ_MFG_ORDER.PRODUCTIONPLANT == T001W.WERKS`
Unit of measure for in-house production Client Unit of measure for in-house production	`PP_MRP_READ_MFG_ORDER.MANDT == T006.MANDT` `PP_MRP_READ_MFG_ORDER.PRODUCTIONUNIT == T006.MSEHI`
Project Current number of the appropriate project Client	`PP_MRP_READ_MFG_ORDER.PROJECTINTERNALID == PROJ.PSPNR` `PP_MRP_READ_MFG_ORDER.MANDT == PROJ.MANDT`
Purchasing Group Purchasing Group Client	`PP_MRP_READ_MFG_ORDER.PURCHASINGGROUP == T024.EKGRP` `PP_MRP_READ_MFG_ORDER.MANDT == T024.MANDT`
Material: order item Material Number for Order Material Number Material Number for Order Client	`PP_MRP_READ_MFG_ORDER.MATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER.SALESORDERITEMMATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER.TOPLEVELORDERMATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER.MANDT == MARA.MANDT`
Order type in order header Client Order Type Sales Document Type	`PP_MRP_READ_MFG_ORDER.MANDT == TVAK.MANDT` `PP_MRP_READ_MFG_ORDER.MANUFACTURINGORDERTYPE == TVAK.AUART` `PP_MRP_READ_MFG_ORDER.SALESORDERTYPE == TVAK.AUART`
Serial Number Profile Serial Number Profile Client	`PP_MRP_READ_MFG_ORDER.SERIALNUMBERPROFILE == T377P.SERAIL` `PP_MRP_READ_MFG_ORDER.MANDT == T377P.MANDT`
Order Number Client Order Number Order Number	`PP_MRP_READ_MFG_ORDER.MANDT == AUFK.MANDT` `PP_MRP_READ_MFG_ORDER.MANUFACTURINGORDER == AUFK.AUFNR` `PP_MRP_READ_MFG_ORDER.TOPLEVELORDER == AUFK.AUFNR`
Material Number for Order Material Number for Order Material Number Material Number for Order Client	`PP_MRP_READ_MFG_ORDER.MATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER.SALESORDERITEMMATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER.TOPLEVELORDERMATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER.MANDT == MARA.MANDT`
Project manager personnel number Number of the Responsible Person (Project Manager) Client	`PP_MRP_READ_MFG_ORDER.WBSRESPONSIBLEPERSON == TCJ04.VERNR` `PP_MRP_READ_MFG_ORDER.MANDT == TCJ04.MANDT`