pp_mrp_read_mfg_order_comp

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

Tables used: AFIH, AFKO, AFPO, RESB, VBAK, VBAP, IHPA, MARC, MKAL, PROJ, PRPS, T460A

🔑 Keys (3)
💰 Amounts
∑ Quantities (13)
📅 Dates (9)
☰ Categorical (4)
Other (26)
🔗 Relations (26)

Column Name	Description
Reservation	Number of reservation/dependent requirements
ReservationItem	Item Number of Reservation / Dependent Requirements
RecordType	Record type

Column Name	Description

Column Name	Description
📏 Base Unit of Measure (MaterialBaseUnit):
OrderedQuantity	Requirement Quantity
WithdrawnQuantity	Quantity withdrawn
CommittedQuantity	Confirmed quantity for availability check in SKU
OpenQuantity	null
MaterialFixedLotSizeQuantity	Fixed lot size
MaterialMinLotSizeQuantity	Minimum Lot Size
MaterialMaxLotSizeQuantity	Maximum Lot Size
MaterialRoundingQuantity	Rounding value for purchase order quantity
OrderPlannedTotalQty	Total Order Quantity
OrderPlannedScrapQty	Total Scrap Quantity in the Order
OrderExpectedDeviationQty	Expected Surplus/Deficit For Goods Receipt
GoodsReceiptQuantity	Quantity of Goods Received for the Order Item
OrderOpenQuantity	null

Column Name	Description
RequirementDate	Requirements date for the component
OrderPlannedStartDate	Basic Start Date
OrderPlannedEndDate	Basic finish date
OrderActualStartDate	Actual start date
OrderActualEndDate	Confirmed Order Finish Date
OrderActualReleaseDate	Actual release date
OrderScheduledStartDate	Scheduled start
OrderScheduledEndDate	Scheduled finish
OrderScheduledReleaseDate	Scheduled release date

Column Name	Description
MaterialProcurementCategory	Procurement Type	Show values
MaterialProcurementType	Special procurement type	Show values
ManufacturingOrderCategory	Order category	Show values
IsPartOfCollectiveOrder	Order is Part of Collective Order	Show values

Column Name	Description	Domain name
RequirementType	Requirement type	BDART
MaterialGoodsReceiptDuration	Goods receipt processing time in days	DEC3
MaterialPlannedDeliveryDurn	Planned Delivery Time in Days	DEC3
MaterialPlannedProductionDurn	In-house production time	DEC3
MatTotalReplenishmentLeadDurn	Total replenishment lead time (in workdays)	DEC3
ManufacturingOrder	Order Number	AUFNR
ManufacturingOrderType	Order Type	AUFART
ManufacturingOrderImportance	Order priority	CHAR1
PlannedOrder	Planned Order	PLNUM
ProductionPlant	Plant	WERKS
MRPController	MRP controller for the order	DISPO
ProductionSupervisor	Production Supervisor	FEVOR
ProductionVersion	Production Version	VERID
ProductionVersionText	Short Text for Production Version	TEXT40
ProductionLine	Production Line for Repetitive Manufacturing	ARBPL
SuperiorOrder	Number of Superior Order	AUFNR
ResourceNetwork	null
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
MaintenanceWorkCenter	Main work center for maintenance tasks	ARBPL
MaintenanceWorkCenterPlant	Plant associated with main work center	WERKS
ResponsiblePerson	Partner	I_PARNR
QuickviewCategory	null

Master Data Relations \| to Other Relations ↓	Join Conditions
Maintenance activity type Maintenance activity type Client	`PP_MRP_READ_MFG_ORDER_COMP.ACTIVITYTYPE == T353I.ILART` `PP_MRP_READ_MFG_ORDER_COMP.MANDT == T353I.MANDT`
Sold-to Party Client Sold-to Party	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == KNA1.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.CUSTOMER == KNA1.KUNNR`
Special Stock Indicator Client Special Stock Indicator	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == T148.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.INVENTORYSPECIALSTOCK == T148.SOBKZ`
Priority Priority Type Client Priority	`PP_MRP_READ_MFG_ORDER_COMP.MAINTENANCEORDERPRIORITYTYPE == T356.ARTPR` `PP_MRP_READ_MFG_ORDER_COMP.MANDT == T356.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.MAINTENANCEORDERPRIORITY == T356.PRIOK`
Priority Type Priority Type Client	`PP_MRP_READ_MFG_ORDER_COMP.MAINTENANCEORDERPRIORITYTYPE == T356A.ARTPR` `PP_MRP_READ_MFG_ORDER_COMP.MANDT == T356A.MANDT`
Maintenance Plan Maintenance Plan Client	`PP_MRP_READ_MFG_ORDER_COMP.MAINTENANCEPLAN == MPLA.WARPL` `PP_MRP_READ_MFG_ORDER_COMP.MANDT == MPLA.MANDT`
Revision for Plant Maintenance and Customer Service Client Revision for Plant Maintenance and Customer Service Maintenance Planning Plant	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == T352R.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.MAINTENANCEREVISION == T352R.REVNR` `PP_MRP_READ_MFG_ORDER_COMP.MAINTENANCEPLANNINGPLANT == T352R.IWERK`
Material Number Client Material Number for Order Material Number Material Number	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == MARA.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.TOPLEVELORDERMATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER_COMP.MATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER_COMP.SALESORDERITEMMATERIAL == MARA.MATNR`
Base Unit of Measure Client Base Unit of Measure	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == T006.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.MATERIALBASEUNIT == T006.MSEHI`
Rounding Profile Client ? ? Rounding Profile	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == RDPR.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.[column in domain "RDZAE"] == RDPR.RDZAE` `PP_MRP_READ_MFG_ORDER_COMP.[column in domain "WERKS_D"] == RDPR.WERKS` `PP_MRP_READ_MFG_ORDER_COMP.MATERIALROUNDINGPROFILE == RDPR.RDPRF`
Plant Plant Plant Client	`PP_MRP_READ_MFG_ORDER_COMP.PRODUCTIONPLANT == T001W.WERKS` `PP_MRP_READ_MFG_ORDER_COMP.MRPPLANT == T001W.WERKS` `PP_MRP_READ_MFG_ORDER_COMP.MANDT == T001W.MANDT`
Project Current number of the appropriate project Client	`PP_MRP_READ_MFG_ORDER_COMP.PROJECTINTERNALID == PROJ.PSPNR` `PP_MRP_READ_MFG_ORDER_COMP.MANDT == PROJ.MANDT`
Purchasing Group Purchasing Group Client	`PP_MRP_READ_MFG_ORDER_COMP.PURCHASINGGROUP == T024.EKGRP` `PP_MRP_READ_MFG_ORDER_COMP.MANDT == T024.MANDT`
Material: order item Client Material Number for Order Material Number Material Number	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == MARA.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.TOPLEVELORDERMATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER_COMP.MATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER_COMP.SALESORDERITEMMATERIAL == MARA.MATNR`
Order type in order header Sales Document Type Order Type Client	`PP_MRP_READ_MFG_ORDER_COMP.SALESORDERTYPE == TVAK.AUART` `PP_MRP_READ_MFG_ORDER_COMP.MANUFACTURINGORDERTYPE == TVAK.AUART` `PP_MRP_READ_MFG_ORDER_COMP.MANDT == TVAK.MANDT`
Receiving plant/issuing plant Client Receiving plant/issuing plant	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == T001W.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.SUPPLYINGPLANT == T001W.WERKS`
Order Number Client Order Number Order Number	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == AUFK.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.MANUFACTURINGORDER == AUFK.AUFNR` `PP_MRP_READ_MFG_ORDER_COMP.TOPLEVELORDER == AUFK.AUFNR`
Material Number for Order Client Material Number for Order Material Number Material Number	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == MARA.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.TOPLEVELORDERMATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER_COMP.MATERIAL == MARA.MATNR` `PP_MRP_READ_MFG_ORDER_COMP.SALESORDERITEMMATERIAL == MARA.MATNR`
Vendor Account Number of Supplier Client	`PP_MRP_READ_MFG_ORDER_COMP.VENDOR == LFA1.LIFNR` `PP_MRP_READ_MFG_ORDER_COMP.MANDT == LFA1.MANDT`
Project manager personnel number Client Number of the Responsible Person (Project Manager)	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == TCJ04.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.WBSRESPONSIBLEPERSON == TCJ04.VERNR`

Other Relations \| to Master Data Relations ↑	Join Conditions
Planner Group for Customer Service and Plant Maintenance Client Maintenance Planning Plant Planner Group for Customer Service and Plant Maintenance	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == T024I.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `PP_MRP_READ_MFG_ORDER_COMP.MAINTENANCEPLANNERGROUP == T024I.INGRP`
Maintenance Planning Plant Client Maintenance Planning Plant	`PP_MRP_READ_MFG_ORDER_COMP.MANDT == T399I.MANDT` `PP_MRP_READ_MFG_ORDER_COMP.MAINTENANCEPLANNINGPLANT == T399I.IWERK`