What is I_MRPMfgOrder in SAP S/4HANA?

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

What VDM layer is I_MRPMfgOrder?

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

I_MRPMfgOrder

Q: Which tables does I_MRPMfgOrder read from?

I_MRPMfgOrder reads data from: I_ManufacturingOrder, I_ManufacturingOrderItem, I_ManufacturingOrderItem, I_ProductPlant.

DDL: I_MRPMFGORDER SQL: IMRPMFGORDER Type: view COMPOSITE Package: ODATA_PP_MRP

55 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_ManufacturingOrder, I_ManufacturingOrderItem, I_ManufacturingOrderItem, I_ProductPlant) and exposes 55 fields with key fields ManufacturingOrder, ManufacturingOrderItem. It has 2 associations to related views. Part of development package ODATA_PP_MRP.

Data Sources (4)

Source	Alias	Join Type
I_ManufacturingOrder	MfgOrder	from
I_ManufacturingOrderItem	MfgOrderItem	inner
I_ManufacturingOrderItem	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_EntProjectResponsiblePerson	_ProjectRespPersn	`$projection.WBSElementInternalID = _ProjectRespPersn.WBSElementInternalID and _ProjectRespPersn.WBSElementInternalID is not initial`

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 (55)

Key	Field	Source Table	Source Field	Description
KEY	ManufacturingOrder	I_ManufacturingOrderItem	ManufacturingOrder	Order
KEY	ManufacturingOrderItem	I_ManufacturingOrderItem	ManufacturingOrderItem	Manufacturing Order Item
	ManufacturingOrderCategory	I_ManufacturingOrder	ManufacturingOrderCategory	Order Category
	ManufacturingOrderType	I_ManufacturingOrder	ManufacturingOrderType	Order Type
	Material	I_ManufacturingOrderItem	Material	Vehicle Model
	MRPPlant	I_ManufacturingOrderItem	PlanningPlant	Plant
	ProductionPlant	I_ManufacturingOrderItem	ProductionPlant	Prod plnt
	MaterialGoodsReceiptDuration	I_ManufacturingOrderItem	MaterialGoodsReceiptDuration	GR proc. time
	MfgOrderPlannedStartDate	I_ManufacturingOrder	MfgOrderPlannedStartDate
	MfgOrderPlannedEndDate	I_ManufacturingOrder	MfgOrderPlannedEndDate
	MfgOrderActualStartDate	I_ManufacturingOrder	MfgOrderActualStartDate
	MfgOrderActualEndDate	I_ManufacturingOrder	MfgOrderActualEndDate
	MfgOrderActualReleaseDate	I_ManufacturingOrder	MfgOrderActualReleaseDate
	MfgOrderScheduledStartDate	I_ManufacturingOrder	MfgOrderScheduledStartDate
	MfgOrderScheduledEndDate	I_ManufacturingOrder	MfgOrderScheduledEndDate
	MfgOrderScheduledReleaseDate	I_ManufacturingOrder	MfgOrderScheduledReleaseDate
	ProductionUnit	I_ManufacturingOrder	ProductionUnit
	MfgOrderPlannedTotalQty	I_ManufacturingOrder	MfgOrderPlannedTotalQty
	MfgOrderPlannedScrapQty	I_ManufacturingOrder	MfgOrderPlannedScrapQty
	ExpectedDeviationQuantity	I_ManufacturingOrder	ExpectedDeviationQuantity
	ActualDeliveredQuantity	I_ManufacturingOrder	ActualDeliveredQuantity	Delivered Quantity
	OpenQuantity
	ManufacturingOrderImportance	I_ManufacturingOrder	ManufacturingOrderImportance
	MfgOrderIsPartOfCollvOrder	I_ManufacturingOrder	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_ManufacturingOrderItem	SalesOrder	SD Document
	SalesOrderItem	I_ManufacturingOrderItem	SalesOrderItem	Sales Order Item
	SalesOrderType
	SalesOrderItemMaterial
	Customer
	ProductionVersionText
	ProductionVersion	I_ManufacturingOrderItem	ProductionVersion	Version ID
	ProductionLine
	WBSElementInternalID	I_ManufacturingOrderItem	WBSElementInternalID_2
	WBSElement
	WBSDescription
	ResponsiblePerson
	ResponsiblePersonName
	ProjectInternalID
	Project
	ProjectDescription
	ProjectResponsiblePerson
	ProjectResponsiblePersonName
	TopLevelOrder	TopLevelOrder	ManufacturingOrder	Order
	TopLevelOrderMaterial	I_ManufacturingOrderItem	Material	Vehicle Model
	MRPController	I_ManufacturingOrder	MRPController	MRP Controller
	ProductionSupervisor	I_ManufacturingOrder	ProductionSupervisor	Prodn Supervisor
	_WBSElementBasicData2	I_ManufacturingOrderItem	_WBSElementBasicData2

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.PlanningPlant 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_2 AS WBSElementInternalID,
  MfgOrderItem._WBSElementBasicData2.WBSElementExternalID AS WBSElement,
  MfgOrderItem._WBSElementBasicData2.WBSDescription AS WBSDescription,
  cast( _ProjectRespPersn.PersonWorkAgreement as ps_s4_vernr preserving type ) AS ResponsiblePerson,
  _ProjectRespPersn._WorkforcePerson.PersonFullName AS ResponsiblePersonName,
  MfgOrderItem._WBSElementBasicData2._Project.ProjectInternalID AS ProjectInternalID,
  MfgOrderItem._WBSElementBasicData2._Project.ProjectExternalID AS Project,
  MfgOrderItem._WBSElementBasicData2._Project.ProjectDescription AS ProjectDescription,
  cast( _ProjectRespPersn.PersonWorkAgreement as ps_s4_vernr preserving type ) AS ProjectResponsiblePerson,
  _ProjectRespPersn._WorkforcePerson.PersonFullName AS ProjectResponsiblePersonName,
  TopLevelOrder.ManufacturingOrder AS TopLevelOrder,
  OrderItem.Material AS TopLevelOrderMaterial,
  MfgOrder.MRPController AS MRPController,
  MfgOrder.ProductionSupervisor AS ProductionSupervisor,
  MfgOrderItem._WBSElementBasicData2 AS _WBSElementBasicData2
FROM I_ManufacturingOrder AS MfgOrder
INNER JOIN I_ManufacturingOrderItem 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_ManufacturingOrderItem 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_EntProjectResponsiblePerson AS _ProjectRespPersn ON WBSElementInternalID = _ProjectRespPersn.WBSElementInternalID AND _ProjectRespPersn.WBSElementInternalID is not initial  -- association [0..1]
;

Depth:

I_MRPMfgOrder view

C_MRPMfgOrder view