What is C_MRPMfgOrder in SAP S/4HANA?

C_MRPMfgOrder is a consumption CDS view in SAP S/4HANA. MRP Manufacturing Order It contains 54 fields.

Which tables does C_MRPMfgOrder read from?

C_MRPMfgOrder reads data from: I_MRPMfgOrder.

What VDM layer is C_MRPMfgOrder?

C_MRPMfgOrder is classified as a Consumption view optimized for specific business scenarios and reporting.

C_MRPMfgOrder

DDL: C_MRPMFGORDER SQL: CMRPMFGORDER Type: view CONSUMPTION Package: ODATA_PP_MRP

54 Fields 1 Data Sources 8 Associations

MRP Manufacturing Order

C_MRPMfgOrder is a Consumption CDS View that provides data about "MRP Manufacturing Order" in SAP S/4HANA. It reads from 1 data source (I_MRPMfgOrder) and exposes 54 fields with key fields ManufacturingOrder, ManufacturingOrderItem. It has 8 associations to related views. Part of development package ODATA_PP_MRP.

Data Sources (1)

Source	Alias	Join Type
I_MRPMfgOrder	I_MRPMfgOrder	from

Associations (8)

Cardinality	Target	Alias	Condition
[0..*]	I_LogisticalRoundingProfileT	_RoundingProfileText	`$projection.RoundingProfile = _RoundingProfileText.LogisticalRoundingProfile and $projection.MRPPlant = _RoundingProfileText.Plant`
[0..1]	I_ProductionSupervisor	_ProductionSupervisor	`$projection.ProductionPlant = _ProductionSupervisor.Plant and $projection.ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor`
[0..1]	I_MRPController	_MRPController	`$projection.ProductionPlant = _MRPController.Plant and $projection.MRPController = _MRPController.MRPController`
[0..1]	I_MRPControllerEmail	_MRPControllerEmail	`$projection.MRPController = _MRPControllerEmail.MRPController and $projection.ProductionPlant = _MRPControllerEmail.Plant`
[0..*]	I_MfgOrderTypeText	_MfgOrderTypeText	`$projection.ManufacturingOrderType = _MfgOrderTypeText.ManufacturingOrderType`
[0..*]	I_MaterialText	_MaterialText	`$projection.Material = _MaterialText.Material`
[0..*]	I_MaterialText	_SOMaterialText	`$projection.SalesOrderItemMaterial = _SOMaterialText.Material`
[0..*]	I_MaterialText	_TLMaterialText	`$projection.TopLevelOrderMaterial = _TLMaterialText.Material`

Annotations (10)

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

Fields (54)

Key	Field	Source Table	Source Field	Description
KEY	ManufacturingOrder	I_MRPMfgOrder	ManufacturingOrder	Order
KEY	ManufacturingOrderItem	I_MRPMfgOrder	ManufacturingOrderItem	Manufacturing Order Item
	Material	I_MRPMfgOrder	Material	Vehicle Model
	MaterialName
	MRPPlant	I_MRPMfgOrder	MRPPlant	Plant
	ProductionUnit	I_MRPMfgOrder	ProductionUnit
	SalesOrderType	I_MRPMfgOrder	SalesOrderType	Sales Order Type
	ManufacturingOrderCategory		ManufacturingOrderCategory
	ProductionSupervisor	I_MRPMfgOrder	ProductionSupervisor	Prodn Supervisor
	ProductionSupervisorName	_ProductionSupervisor	ProductionSupervisorName
	MRPController	I_MRPMfgOrder	MRPController	MRP Controller
	MRPControllerName	_MRPController	MRPControllerName	Controller name
	MRPControllerPhoneNumber	_MRPController	MRPControllerPhoneNumber
	EmailAddress	_MRPControllerEmail	EmailAddress	E-Mail Address
	MaterialPlannedDeliveryDurn	I_MRPMfgOrder	MaterialPlannedDeliveryDurn	Pl. Deliv. Time
	TotalReplenishmentLeadTime	I_MRPMfgOrder	TotalReplenishmentLeadTime	Total RL time
	FixedLotSizeQuantity	I_MRPMfgOrder	FixedLotSizeQuantity	Fixed lot size
	MinimumLotSizeQuantity	I_MRPMfgOrder	MinimumLotSizeQuantity	Min. Lot Size
	MaximumLotSizeQuantity	I_MRPMfgOrder	MaximumLotSizeQuantity	Max. Lot Size
	LotSizeRoundingQuantity	I_MRPMfgOrder	LotSizeRoundingQuantity	Rounding value
	RoundingProfile	I_MRPMfgOrder	RoundingProfile	Rnding Profile
	MaterialRoundingProfileName
	ManufacturingOrderType	I_MRPMfgOrder	ManufacturingOrderType
	ManufacturingOrderTypeName
	MfgOrderProgressStatus	I_MRPMfgOrder	MfgOrderProgressStatus
	MfgOrderPlannedStartDate	I_MRPMfgOrder	MfgOrderPlannedStartDate
	MfgOrderScheduledReleaseDate	I_MRPMfgOrder	MfgOrderScheduledReleaseDate
	MfgOrderScheduledStartDate	I_MRPMfgOrder	MfgOrderScheduledStartDate
	MfgOrderScheduledEndDate	I_MRPMfgOrder	MfgOrderScheduledEndDate
	MfgOrderPlannedEndDate	I_MRPMfgOrder	MfgOrderPlannedEndDate
	MaterialGoodsReceiptDuration	I_MRPMfgOrder	MaterialGoodsReceiptDuration	GR proc. time
	MfgOrderPlannedTotalQty	I_MRPMfgOrder	MfgOrderPlannedTotalQty
	MfgOrderPlannedScrapQty	I_MRPMfgOrder	MfgOrderPlannedScrapQty
	ActualDeliveredQuantity	I_MRPMfgOrder	ActualDeliveredQuantity	Delivered Quantity
	OpenQuantity	I_MRPMfgOrder	OpenQuantity	PBE Entry Open Qty
	ProductionPlant	I_MRPMfgOrder	ProductionPlant	Prod plnt
	ProductionVersion	I_MRPMfgOrder	ProductionVersion	Version ID
	ProductionVersionText	I_MRPMfgOrder	ProductionVersionText
	ProductionLine	I_MRPMfgOrder	ProductionLine	Production Line
	ManufacturingOrderImportance	I_MRPMfgOrder	ManufacturingOrderImportance
	WBSElement	I_MRPMfgOrder	WBSElement	WBS Internal ID
	WBSDescription	I_MRPMfgOrder	WBSDescription	WBS Element Name
	ResponsiblePerson	I_MRPMfgOrder	ResponsiblePerson	Processor
	ResponsiblePersonName	I_MRPMfgOrder	ResponsiblePersonName	User
	Project	I_MRPMfgOrder	Project	WBS Element
	ProjectDescription	I_MRPMfgOrder	ProjectDescription	Project Name
	ProjectResponsiblePerson	I_MRPMfgOrder	ProjectResponsiblePerson
	ProjectResponsiblePersonName	I_MRPMfgOrder	ProjectResponsiblePersonName
	SalesOrder	I_MRPMfgOrder	SalesOrder	SD Document
	SalesOrderItemMaterial	I_MRPMfgOrder	SalesOrderItemMaterial
	SalesOrderItemMaterialName
	TopLevelOrder	I_MRPMfgOrder	TopLevelOrder	Order
	TopLevelOrderMaterial	I_MRPMfgOrder	TopLevelOrderMaterial	Vehicle Model
	TopLevelOrderMaterialName

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 C_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: CMRPMFGORDER

CREATE VIEW C_MRPMfgOrder AS
SELECT
  I_MRPMfgOrder.ManufacturingOrder AS ManufacturingOrder,
  I_MRPMfgOrder.ManufacturingOrderItem AS ManufacturingOrderItem,
  I_MRPMfgOrder.Material AS Material,
  _MaterialText[1: Language = $session.system_language ].MaterialName AS MaterialName,
  I_MRPMfgOrder.MRPPlant AS MRPPlant,
  I_MRPMfgOrder.ProductionUnit AS ProductionUnit,
  I_MRPMfgOrder.SalesOrderType AS SalesOrderType,
  ManufacturingOrderCategory,
  I_MRPMfgOrder.ProductionSupervisor AS ProductionSupervisor,
  _ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  I_MRPMfgOrder.MRPController AS MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  _MRPController.MRPControllerPhoneNumber AS MRPControllerPhoneNumber,
  _MRPControllerEmail.EmailAddress AS EmailAddress,
  I_MRPMfgOrder.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  I_MRPMfgOrder.TotalReplenishmentLeadTime AS TotalReplenishmentLeadTime,
  I_MRPMfgOrder.FixedLotSizeQuantity AS FixedLotSizeQuantity,
  I_MRPMfgOrder.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  I_MRPMfgOrder.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  I_MRPMfgOrder.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
  I_MRPMfgOrder.RoundingProfile AS RoundingProfile,
  _RoundingProfileText[1: Language = $session.system_language ].LogisticalRoundingProfileName AS MaterialRoundingProfileName,
  I_MRPMfgOrder.ManufacturingOrderType AS ManufacturingOrderType,
  _MfgOrderTypeText[ 1: Language = $session.system_language ].ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  I_MRPMfgOrder.MfgOrderProgressStatus AS MfgOrderProgressStatus,
  I_MRPMfgOrder.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  I_MRPMfgOrder.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  I_MRPMfgOrder.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  I_MRPMfgOrder.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  I_MRPMfgOrder.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  I_MRPMfgOrder.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  I_MRPMfgOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  I_MRPMfgOrder.MfgOrderPlannedScrapQty AS MfgOrderPlannedScrapQty,
  I_MRPMfgOrder.ActualDeliveredQuantity AS ActualDeliveredQuantity,
  I_MRPMfgOrder.OpenQuantity AS OpenQuantity,
  I_MRPMfgOrder.ProductionPlant AS ProductionPlant,
  I_MRPMfgOrder.ProductionVersion AS ProductionVersion,
  I_MRPMfgOrder.ProductionVersionText AS ProductionVersionText,
  I_MRPMfgOrder.ProductionLine AS ProductionLine,
  I_MRPMfgOrder.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  I_MRPMfgOrder.WBSElement AS WBSElement,
  I_MRPMfgOrder.WBSDescription AS WBSDescription,
  I_MRPMfgOrder.ResponsiblePerson AS ResponsiblePerson,
  I_MRPMfgOrder.ResponsiblePersonName AS ResponsiblePersonName,
  I_MRPMfgOrder.Project AS Project,
  I_MRPMfgOrder.ProjectDescription AS ProjectDescription,
  I_MRPMfgOrder.ProjectResponsiblePerson AS ProjectResponsiblePerson,
  I_MRPMfgOrder.ProjectResponsiblePersonName AS ProjectResponsiblePersonName,
  I_MRPMfgOrder.SalesOrder AS SalesOrder,
  I_MRPMfgOrder.SalesOrderItemMaterial AS SalesOrderItemMaterial,
  _SOMaterialText[1: Language = $session.system_language ].MaterialName AS SalesOrderItemMaterialName,
  I_MRPMfgOrder.TopLevelOrder AS TopLevelOrder,
  I_MRPMfgOrder.TopLevelOrderMaterial AS TopLevelOrderMaterial,
  _TLMaterialText[1: Language = $session.system_language ].MaterialName AS TopLevelOrderMaterialName
FROM I_MRPMfgOrder
LEFT OUTER JOIN I_LogisticalRoundingProfileT AS _RoundingProfileText ON RoundingProfile = _RoundingProfileText.LogisticalRoundingProfile AND MRPPlant = _RoundingProfileText.Plant  -- association [0..*]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON ProductionPlant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON ProductionPlant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_MRPControllerEmail AS _MRPControllerEmail ON MRPController = _MRPControllerEmail.MRPController AND ProductionPlant = _MRPControllerEmail.Plant  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderTypeText AS _MfgOrderTypeText ON ManufacturingOrderType = _MfgOrderTypeText.ManufacturingOrderType  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _SOMaterialText ON SalesOrderItemMaterial = _SOMaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _TLMaterialText ON TopLevelOrderMaterial = _TLMaterialText.Material  -- association [0..*]
;

Depth:

C_MRPMfgOrder view

I_MRPMfgOrder view