What is I_MRPMfgOrder in SAP S/4HANA?

I_MRPMfgOrder is a composite CDS view in SAP S/4HANA. MRP Manufacturing Order It contains 50 fields.

Which tables does I_MRPMfgOrder read from?

I_MRPMfgOrder reads data from: I_MfgOrder, I_MfgOrderItem, I_MfgOrderItem, I_ProductPlant.

What VDM layer is I_MRPMfgOrder?

I_MRPMfgOrder is classified as a Composite view that combines data from multiple basic views.

I_MRPMfgOrder

DDL: I_MRPMFGORDER SQL: IMRPMFGORDER Type: view COMPOSITE

50 Fields 4 Data Sources 2 Associations

MRP Manufacturing Order

I_MRPMfgOrder is a Composite CDS View that provides data about "MRP Manufacturing Order" in SAP S/4HANA. It reads from 4 data sources (I_MfgOrder, I_MfgOrderItem, I_MfgOrderItem, I_ProductPlant) and exposes 50 fields with key fields ManufacturingOrder, ManufacturingOrderItem. It has 2 associations to related views.

Data Sources (4)

Source	Alias	Join Type
I_MfgOrder	MfgOrder	from
I_MfgOrderItem	MfgOrderItem	inner
I_MfgOrderItem	OrderItem	inner
I_ProductPlant	ProductPlant	inner

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_ProductSupplyPlanning	_ProductSupplyPlanning	`$projection.Material = _ProductSupplyPlanning.Product and $projection.MRPPlant = _ProductSupplyPlanning.Plant`
[0..1]	I_WBSElement	_WBSElement	`$projection.WBSElementInternalID = _WBSElement.WBSElementInternalID`

Annotations (10)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.sqlViewName	IMRPMFGORDER	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	MRP Manufacturing Order	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#COMPOSITE	view
AccessControl.personalData.blocking	#REQUIRED	view

Fields (50)

Key	Field	Source Table	Source Field	Description
KEY	ManufacturingOrder	I_MfgOrderItem	ManufacturingOrder	Order
KEY	ManufacturingOrderItem	I_MfgOrderItem	ManufacturingOrderItem	Manufacturing Order Item
	ManufacturingOrderCategory	I_MfgOrder	ManufacturingOrderCategory
	ManufacturingOrderType	I_MfgOrder	ManufacturingOrderType
	Material	I_MfgOrderItem	Material	Vehicle Model
	MRPPlant	I_MfgOrderItem	MRPPlant	Plant
	ProductionPlant	I_MfgOrderItem	ProductionPlant	Prod plnt
	MaterialGoodsReceiptDuration	I_MfgOrderItem	MaterialGoodsReceiptDuration	GR proc. time
	MfgOrderPlannedStartDate	I_MfgOrder	MfgOrderPlannedStartDate
	MfgOrderPlannedEndDate	I_MfgOrder	MfgOrderPlannedEndDate
	MfgOrderActualStartDate	I_MfgOrder	MfgOrderActualStartDate
	MfgOrderActualEndDate	I_MfgOrder	MfgOrderActualEndDate
	MfgOrderActualReleaseDate	I_MfgOrder	MfgOrderActualReleaseDate
	MfgOrderScheduledStartDate	I_MfgOrder	MfgOrderScheduledStartDate
	MfgOrderScheduledEndDate	I_MfgOrder	MfgOrderScheduledEndDate
	MfgOrderScheduledReleaseDate	I_MfgOrder	MfgOrderScheduledReleaseDate
	ProductionUnit	I_MfgOrder	ProductionUnit
	MfgOrderPlannedTotalQty	I_MfgOrder	MfgOrderPlannedTotalQty
	MfgOrderPlannedScrapQty	I_MfgOrder	MfgOrderPlannedScrapQty
	ExpectedDeviationQuantity	I_MfgOrder	ExpectedDeviationQuantity
	ActualDeliveredQuantity	I_MfgOrder	ActualDeliveredQuantity	Delivered Quantity
	OpenQuantity
	ManufacturingOrderImportance	I_MfgOrder	ManufacturingOrderImportance
	MfgOrderIsPartOfCollvOrder	I_MfgOrder	MfgOrderIsPartOfCollvOrder
	MaterialPlannedDeliveryDurn	_ProductSupplyPlanning	PlannedDeliveryDurationInDays	Plnd dely time
	PurchasingGroup	I_ProductPlant	PurchasingGroup	Purchasing Group
	TotalReplenishmentLeadTime	_ProductSupplyPlanning	TotalReplenishmentLeadTime	Total RL time
	FixedLotSizeQuantity	_ProductSupplyPlanning	FixedLotSizeQuantity	Fixed lot size
	MinimumLotSizeQuantity	_ProductSupplyPlanning	MinimumLotSizeQuantity	Min. Lot Size
	MaximumLotSizeQuantity	_ProductSupplyPlanning	MaximumLotSizeQuantity	Max. Lot Size
	LotSizeRoundingQuantity	_ProductSupplyPlanning	LotSizeRoundingQuantity	Rounding value
	RoundingProfile	_ProductSupplyPlanning	RoundingProfile	Rnding Profile
	SalesOrder	I_MfgOrderItem	SalesOrder	SD Document
	SalesOrderItem	I_MfgOrderItem	SalesOrderItem	Sales Order Item
	SalesOrderType
	SalesOrderItemMaterial
	Customer
	ProductionVersionText
	ProductionVersion	I_MfgOrderItem	ProductionVersion	Version ID
	ProductionLine
	WBSElementInternalID	I_MfgOrderItem	WBSElementInternalID	WBS Internal ID
	WBSElement
	WBSDescription
	ProjectInternalID
	Project
	TopLevelOrder	TopLevelOrder	ManufacturingOrder	Order
	TopLevelOrderMaterial	I_MfgOrderItem	Material	Vehicle Model
	MRPController	I_MfgOrder	MRPController	MRP Controller
	ProductionSupervisor	I_MfgOrder	ProductionSupervisor	Prodn Supervisor
	_WBSElement		_WBSElement

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MRPMfgOrder.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMRPMFGORDER

CREATE VIEW I_MRPMfgOrder AS
SELECT
  MfgOrderItem.ManufacturingOrder AS ManufacturingOrder,
  MfgOrderItem.ManufacturingOrderItem AS ManufacturingOrderItem,
  MfgOrder.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MfgOrder.ManufacturingOrderType AS ManufacturingOrderType,
  MfgOrderItem.Material AS Material,
  MfgOrderItem.MRPPlant AS MRPPlant,
  MfgOrderItem.ProductionPlant AS ProductionPlant,
  MfgOrderItem.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  MfgOrder.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  MfgOrder.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  MfgOrder.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  MfgOrder.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  MfgOrder.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  MfgOrder.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  MfgOrder.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  MfgOrder.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  MfgOrder.ProductionUnit AS ProductionUnit,
  MfgOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  MfgOrder.MfgOrderPlannedScrapQty AS MfgOrderPlannedScrapQty,
  MfgOrder.ExpectedDeviationQuantity AS ExpectedDeviationQuantity,
  MfgOrder.ActualDeliveredQuantity AS ActualDeliveredQuantity,
  (MfgOrder.MfgOrderPlannedTotalQty - MfgOrder.MfgOrderPlannedScrapQty - MfgOrder.ExpectedDeviationQuantity - MfgOrder.ActualDeliveredQuantity) AS OpenQuantity,
  MfgOrder.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  MfgOrder.MfgOrderIsPartOfCollvOrder AS MfgOrderIsPartOfCollvOrder,
  _ProductSupplyPlanning.PlannedDeliveryDurationInDays AS MaterialPlannedDeliveryDurn,
  ProductPlant.PurchasingGroup AS PurchasingGroup,
  _ProductSupplyPlanning.TotalReplenishmentLeadTime AS TotalReplenishmentLeadTime,
  _ProductSupplyPlanning.FixedLotSizeQuantity AS FixedLotSizeQuantity,
  _ProductSupplyPlanning.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  _ProductSupplyPlanning.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  _ProductSupplyPlanning.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
  _ProductSupplyPlanning.RoundingProfile AS RoundingProfile,
  MfgOrderItem.SalesOrder AS SalesOrder,
  MfgOrderItem.SalesOrderItem AS SalesOrderItem,
  MfgOrderItem._SalesOrder.SalesOrderType AS SalesOrderType,
  MfgOrderItem._SalesOrderItem.Material AS SalesOrderItemMaterial,
  MfgOrderItem._SalesOrder.SoldToParty AS Customer,
  MfgOrderItem._ProductionVersion.ProductionVersionText AS ProductionVersionText,
  MfgOrderItem.ProductionVersion AS ProductionVersion,
  MfgOrderItem._ProductionVersion.ProductionLine AS ProductionLine,
  MfgOrderItem.WBSElementInternalID AS WBSElementInternalID,
  MfgOrderItem._WBSElement.WBSElement AS WBSElement,
  MfgOrderItem._WBSElement.WBSDescription AS WBSDescription,
  MfgOrderItem._WBSElement.ProjectInternalID AS ProjectInternalID,
  MfgOrderItem._WBSElement._Project.Project AS Project,
  TopLevelOrder.ManufacturingOrder AS TopLevelOrder,
  OrderItem.Material AS TopLevelOrderMaterial,
  MfgOrder.MRPController AS MRPController,
  MfgOrder.ProductionSupervisor AS ProductionSupervisor
FROM I_MfgOrder AS MfgOrder
INNER JOIN I_MfgOrderItem AS MfgOrderItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProductPlant AS ProductPlant ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgOrderItem AS OrderItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductSupplyPlanning AS _ProductSupplyPlanning ON Material = _ProductSupplyPlanning.Product AND MRPPlant = _ProductSupplyPlanning.Plant  -- association [1..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;

Depth:

I_MRPMfgOrder view

C_MRPMfgOrder view