I_MRPManufacturingComponent

DDL: I_MRPMANUFACTURINGCOMPONENT SQL: IMRPMANUCOMP Type: view COMPOSITE
72 Fields 1 Data Sources 3 Associations

MRP Manufacturing Components

I_MRPManufacturingComponent is a Composite CDS View that provides data about "MRP Manufacturing Components" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationComponent) and exposes 72 fields with key fields Reservation, ReservationItem, RecordType. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationComponent I_MfgOrderOperationComponent from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ProductPlant _ProductPlant $projection.Material = _ProductPlant.Product and $projection.MRPPlant = _ProductPlant.Plant
[0..1] I_ProductSupplyPlanning _ProductSupplyPlanning $projection.Material = _ProductSupplyPlanning.Product and $projection.MRPPlant = _ProductSupplyPlanning.Plant
[0..1] I_MRPControllerEmail _MRPControllerEmail $projection.MRPPlant = _MRPControllerEmail.Plant and $projection.MRPController = _MRPControllerEmail.MRPController

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMRPMANUCOMP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label MRP Manufacturing Components view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_MfgOrderOperationComponent Reservation Reservation
KEY ReservationItem I_MfgOrderOperationComponent ReservationItem Reservation Item
KEY RecordType I_MfgOrderOperationComponent RecordType Reservation Record Type
RequirementType I_MfgOrderOperationComponent RequirementType RequirementType
Material I_MfgOrderOperationComponent Material Vehicle Model
MaterialName
MRPPlant I_MfgOrderOperationComponent Plant Valuation Area
SupplyingPlant
RequirementDate I_MfgOrderOperationComponent MatlCompRequirementDate Reqmts date
BaseUnit I_MfgOrderOperationComponent BaseUnit Unit of Measure
Supplier I_MfgOrderOperationComponent Supplier Supplier
PurchasingGroup I_MfgOrderOperationComponent PurchasingGroup Purchasing Group
MaterialProcurementCategory _ProductPlant ProcurementType Procurement
MaterialProcurementType _ProductPlant SpecialProcurementType SpecProcurement
ManufacturingOrder I_MfgOrderOperationComponent ManufacturingOrder Order
ManufacturingOrderCategory I_MfgOrderOperationComponent ManufacturingOrderCategory
ManufacturingOrderType I_MfgOrderOperationComponent ManufacturingOrderType
ManufacturingOrderImportance
PlannedOrder
ProductionPlant I_MfgOrderOperationComponent ProductionPlant Prod plnt
MRPController I_MfgOrderOperationComponent AssemblyMRPController
MRPControllerName _MRPControllerEmail MRPControllerName Controller name
MRPControllerPhoneNumber
EmailAddress _MRPControllerEmail EmailAddress E-Mail Address
ProductionSupervisor I_MfgOrderOperationComponent ProductionSupervisor Prodn Supervisor
ProductionVersion
ProductionVersionText
ProductionLine
InventorySpecialStockType I_MfgOrderOperationComponent InventorySpecialStockType Special Stock Type
OrderedQuantity I_MfgOrderOperationComponent RequiredQuantity Requirement qty
WithdrawnQuantity I_MfgOrderOperationComponent WithdrawnQuantity Withdrawn Quantity
OpenQuantity
CommittedQuantity I_MfgOrderOperationComponent ConfirmedAvailableQuantity Available Quantity
OrderPlannedTotalQty
OrderPlannedScrapQty
ExpectedDeviationQuantity
GoodsReceiptQty
PlannedStartDate
OrderPlannedEndDate
ActualStartDate
ActualEndDate
ActualReleasedDate
ScheduledBasicStartDate
ScheduledBasicEndDate
ScheduledReleaseDate
TopLevelOrder
TopLevelOrderMaterial
MaterialGoodsReceiptDuration _ProductPlant GoodsReceiptDuration GR proc. time
MaterialPlannedDeliveryDurn _ProductSupplyPlanning PlannedDeliveryDurationInDays Plnd dely time
MaterialPlannedProductionDurn 0
MaterialReplenishmentLeadDurn _ProductSupplyPlanning TotalReplenishmentLeadTime Total RL time
SalesOrder I_MfgOrderOperationComponent SalesOrder SD Document
SalesOrderItem I_MfgOrderOperationComponent SalesOrderItem Sales Order Item
SalesOrderType
SalesOrderItemMaterial
Customer
WBSElementInternalID I_MfgOrderOperationComponent WBSElementInternalID WBS Internal ID
WBSElement
WBSDescription
ResponsiblePerson
ResponsiblePersonName
ProjectInternalID
ProjectDescription
Project
ProjectResponsiblePerson
ProjectResponsiblePersonName
TotalReplenishmentLeadDuration _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

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_MRPManufacturingComponent.
-- 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: IMRPMANUCOMP

CREATE VIEW I_MRPManufacturingComponent AS
SELECT
  I_MfgOrderOperationComponent.Reservation AS Reservation,
  I_MfgOrderOperationComponent.ReservationItem AS ReservationItem,
  I_MfgOrderOperationComponent.RecordType AS RecordType,
  I_MfgOrderOperationComponent.RequirementType AS RequirementType,
  I_MfgOrderOperationComponent.Material AS Material,
  I_MfgOrderOperationComponent._Material._Text[1: Language = $session.system_language ].MaterialName AS MaterialName,
  I_MfgOrderOperationComponent.Plant AS MRPPlant,
  '' AS SupplyingPlant,
  I_MfgOrderOperationComponent.MatlCompRequirementDate AS RequirementDate,
  I_MfgOrderOperationComponent.BaseUnit AS BaseUnit,
  I_MfgOrderOperationComponent.Supplier AS Supplier,
  I_MfgOrderOperationComponent.PurchasingGroup AS PurchasingGroup,
  _ProductPlant.ProcurementType AS MaterialProcurementCategory,
  _ProductPlant.SpecialProcurementType AS MaterialProcurementType,
  I_MfgOrderOperationComponent.ManufacturingOrder AS ManufacturingOrder,
  I_MfgOrderOperationComponent.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  I_MfgOrderOperationComponent.ManufacturingOrderType AS ManufacturingOrderType,
  I_MfgOrderOperationComponent._MfgOrder.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  I_MfgOrderOperationComponent._MfgOrder.PlannedOrder AS PlannedOrder,
  I_MfgOrderOperationComponent.ProductionPlant AS ProductionPlant,
  I_MfgOrderOperationComponent.AssemblyMRPController AS MRPController,
  _MRPControllerEmail.MRPControllerName AS MRPControllerName,
  I_MfgOrderOperationComponent._AssemblyMRPController.MRPControllerPhoneNumber AS MRPControllerPhoneNumber,
  _MRPControllerEmail.EmailAddress AS EmailAddress,
  I_MfgOrderOperationComponent.ProductionSupervisor AS ProductionSupervisor,
  I_MfgOrderOperationComponent._MfgOrder._ProductionVersion.ProductionVersion AS ProductionVersion,
  I_MfgOrderOperationComponent._MfgOrder._ProductionVersion.ProductionVersionText AS ProductionVersionText,
  I_MfgOrderOperationComponent._MfgOrder._ProductionVersion.ProductionLine AS ProductionLine,
  I_MfgOrderOperationComponent.InventorySpecialStockType AS InventorySpecialStockType,
  I_MfgOrderOperationComponent.RequiredQuantity AS OrderedQuantity,
  I_MfgOrderOperationComponent.WithdrawnQuantity AS WithdrawnQuantity,
  (I_MfgOrderOperationComponent.RequiredQuantity - I_MfgOrderOperationComponent.WithdrawnQuantity) AS OpenQuantity,
  I_MfgOrderOperationComponent.ConfirmedAvailableQuantity AS CommittedQuantity,
  I_MfgOrderOperationComponent._MfgOrder.MfgOrderPlannedTotalQty AS OrderPlannedTotalQty,
  I_MfgOrderOperationComponent._MfgOrder.MfgOrderPlannedScrapQty AS OrderPlannedScrapQty,
  I_MfgOrderOperationComponent._MfgOrder.ExpectedDeviationQuantity AS ExpectedDeviationQuantity,
  I_MfgOrderOperationComponent._MfgOrder.ActualDeliveredQuantity AS GoodsReceiptQty,
  I_MfgOrderOperationComponent._MfgOrder.MfgOrderPlannedStartDate AS PlannedStartDate,
  I_MfgOrderOperationComponent._MfgOrder.MfgOrderPlannedEndDate AS OrderPlannedEndDate,
  I_MfgOrderOperationComponent._MfgOrder.MfgOrderActualStartDate AS ActualStartDate,
  I_MfgOrderOperationComponent._MfgOrder.MfgOrderActualEndDate AS ActualEndDate,
  I_MfgOrderOperationComponent._MfgOrder.MfgOrderActualReleaseDate AS ActualReleasedDate,
  I_MfgOrderOperationComponent._MfgOrder.MfgOrderScheduledStartDate AS ScheduledBasicStartDate,
  I_MfgOrderOperationComponent._MfgOrder.MfgOrderScheduledEndDate AS ScheduledBasicEndDate,
  I_MfgOrderOperationComponent._MfgOrder.MfgOrderScheduledReleaseDate AS ScheduledReleaseDate,
  '' AS TopLevelOrder,
  '' AS TopLevelOrderMaterial,
  _ProductPlant.GoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  _ProductSupplyPlanning.PlannedDeliveryDurationInDays AS MaterialPlannedDeliveryDurn,
  0 AS MaterialPlannedProductionDurn,
  _ProductSupplyPlanning.TotalReplenishmentLeadTime AS MaterialReplenishmentLeadDurn,
  I_MfgOrderOperationComponent.SalesOrder AS SalesOrder,
  I_MfgOrderOperationComponent.SalesOrderItem AS SalesOrderItem,
  I_MfgOrderOperationComponent._SalesOrder.SalesOrderType AS SalesOrderType,
  I_MfgOrderOperationComponent._SalesOrderItem.Material AS SalesOrderItemMaterial,
  I_MfgOrderOperationComponent._SalesOrder.SoldToParty AS Customer,
  I_MfgOrderOperationComponent.WBSElementInternalID AS WBSElementInternalID,
  I_MfgOrderOperationComponent._WBSElement.WBSElementExternalID AS WBSElement,
  I_MfgOrderOperationComponent._WBSElement.WBSDescription AS WBSDescription,
  I_MfgOrderOperationComponent._WBSElement.ResponsiblePerson AS ResponsiblePerson,
  I_MfgOrderOperationComponent._WBSElement.ResponsiblePersonName AS ResponsiblePersonName,
  I_MfgOrderOperationComponent._WBSElement.ProjectInternalID AS ProjectInternalID,
  I_MfgOrderOperationComponent._WBSElement._Project.ProjectDescription AS ProjectDescription,
  I_MfgOrderOperationComponent._WBSElement._Project.ProjectWithCodingMask AS Project,
  I_MfgOrderOperationComponent._WBSElement._Project.ResponsiblePerson AS ProjectResponsiblePerson,
  I_MfgOrderOperationComponent._WBSElement._Project.ResponsiblePersonName AS ProjectResponsiblePersonName,
  _ProductSupplyPlanning.TotalReplenishmentLeadTime AS TotalReplenishmentLeadDuration,
  _ProductSupplyPlanning.FixedLotSizeQuantity AS FixedLotSizeQuantity,
  _ProductSupplyPlanning.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  _ProductSupplyPlanning.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  _ProductSupplyPlanning.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
  _ProductSupplyPlanning.RoundingProfile AS RoundingProfile
FROM I_MfgOrderOperationComponent
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND MRPPlant = _ProductPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductSupplyPlanning AS _ProductSupplyPlanning ON Material = _ProductSupplyPlanning.Product AND MRPPlant = _ProductSupplyPlanning.Plant  -- association [0..1]
LEFT OUTER JOIN I_MRPControllerEmail AS _MRPControllerEmail ON MRPPlant = _MRPControllerEmail.Plant AND MRPController = _MRPControllerEmail.MRPController  -- association [0..1]
;

Learn More