I_MRPManufacturingOrder

DDL: I_MRPMANUFACTURINGORDER Type: view_entity COMPOSITE Package: ODATA_PP_MRP
53 Fields 2 Data Sources

MRP Manufacturing Order

I_MRPManufacturingOrder is a Composite CDS View that provides data about "MRP Manufacturing Order" in SAP S/4HANA. It reads from 2 data sources (I_MRPAreaOfResponsibility, I_CacheMRPMfgOrder) and exposes 53 fields with key fields MRPPlant, MRPElement, MRPElementItem, MRPElementCategory, MRPPlanningSegment. Part of development package ODATA_PP_MRP.

Data Sources (2)

SourceAliasJoin Type
I_MRPAreaOfResponsibility _AreaOfResponsibility inner
I_CacheMRPMfgOrder MFGOrder from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED 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

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY MRPPlant I_CacheMRPMfgOrder MRPPlant Plant
KEY MRPElement I_CacheMRPMfgOrder MRPElement MRP element number
KEY MRPElementItem
KEY MRPElementCategory I_CacheMRPMfgOrder MRPElementCategory MRP Elmnt Ind.
KEY MRPPlanningSegment I_CacheMRPMfgOrder MRPPlanningSegment Plng Segmnt No.
KEY MRPPlanningSegmentType
KEY MaterialShortageProfile I_CacheMRPMfgOrder MaterialShortageProfile Shortage Prf.
KEY MaterialShortageProfileCount I_CacheMRPMfgOrder MaterialShortageProfileCount Counter
KEY Material I_CacheMRPMfgOrder Material Vehicle Model
MRPController I_CacheMRPMfgOrder MRPController MRP Controller
FactoryCalendar I_CacheMRPMfgOrder FactoryCalendar Factory Calendar
ProductionPlant I_CacheMRPMfgOrder ProductionPlant Prod plnt
MRPArea I_CacheMRPMfgOrder MRPArea MRP Area
StorageLocation I_CacheMRPMfgOrder StorageLocation StorageLocation
ManufacturingOrderType I_CacheMRPMfgOrder ManufacturingOrderType
LateSupplyLatenessWorkdays I_CacheMRPMfgOrder LateSupplyLatenessWorkdays
MaximumDelayInDays I_CacheMRPMfgOrder MaximumDelayInDays Max.DelayInDays
MaximumDelayInWorkdays I_CacheMRPMfgOrder MaximumDelayInWorkdays MaxDelayWorkday
ManufacturingOrderIsLate I_CacheMRPMfgOrder ManufacturingOrderIsLate
NumberOfUncoveredDemandItems I_CacheMRPMfgOrder NumberOfUncoveredDemandItems
MRPElementOpenQuantity I_CacheMRPMfgOrder MRPElementOpenQuantity Rec./reqd qty
MfgOrderPlannedTotalQty I_CacheMRPMfgOrder MfgOrderPlannedTotalQty
MRPElementDelayedQuantity I_CacheMRPMfgOrder MRPElementDelayedQuantity DEC 20 3
MfgOrderPlannedStartDate I_CacheMRPMfgOrder MfgOrderPlannedStartDate
MfgOrderPlannedEndDate I_CacheMRPMfgOrder MfgOrderPlannedEndDate
MfgOrderPlannedReleaseDate I_CacheMRPMfgOrder MfgOrderPlannedReleaseDate
MfgOrderScheduledStartDate I_CacheMRPMfgOrder MfgOrderScheduledStartDate
MfgOrderScheduledEndDate I_CacheMRPMfgOrder MfgOrderScheduledEndDate
MfgOrderScheduledReleaseDate I_CacheMRPMfgOrder MfgOrderScheduledReleaseDate
MfgOrderActualReleaseDate I_CacheMRPMfgOrder MfgOrderActualReleaseDate
MaximumDelayDate I_CacheMRPMfgOrder MaximumDelayDate Date
ProductionLine I_CacheMRPMfgOrder ProductionLine Production Line
ProductionVersion I_CacheMRPMfgOrder ProductionVersion Version ID
ProductionVersionText I_CacheMRPMfgOrder ProductionVersionText
ProductionSupervisor I_CacheMRPMfgOrder ProductionSupervisor Prodn Supervisor
ComponentShortageDefinition I_CacheMRPMfgOrder ComponentShortageDefinition
MfgOrderProgressStatus I_CacheMRPMfgOrder MfgOrderProgressStatus
MfgOrderProgressNextStatus
MfgOrderStatusActualDate I_CacheMRPMfgOrder MfgOrderStatusActualDate
MfgOrderNextStatusPlannedDate I_CacheMRPMfgOrder MfgOrderNextStatusPlannedDate
MfgOrderStatusPlannedDate I_CacheMRPMfgOrder MfgOrderStatusPlannedDate
MaterialGoodsReceiptDuration I_CacheMRPMfgOrder MaterialGoodsReceiptDuration GR proc. time
ProductionUnit I_CacheMRPMfgOrder ProductionUnit
Reservation I_CacheMRPMfgOrder Reservation Reservation
ManufacturingOrderText I_CacheMRPMfgOrder ManufacturingOrderText
_CacheMaterial I_CacheMRPMfgOrder _CacheMaterial
_Material I_CacheMRPMfgOrder _Material
_MfgOrderType I_CacheMRPMfgOrder _MfgOrderType
_MRPPlant I_CacheMRPMfgOrder _MRPPlant
_Order I_CacheMRPMfgOrder _Order
_ProductionPlant I_CacheMRPMfgOrder _ProductionPlant
_ShortageDefinition I_CacheMRPMfgOrder _ShortageDefinition
_StorageLocation I_CacheMRPMfgOrder _StorageLocation

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_MRPManufacturingOrder.
-- 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.

CREATE VIEW I_MRPManufacturingOrder AS
SELECT
  MFGOrder.MRPPlant AS MRPPlant,
  MFGOrder.MRPElement AS MRPElement,
  cast(lpad( (MFGOrder.MRPElementItem), 6, '0') as delps) AS MRPElementItem,
  MFGOrder.MRPElementCategory AS MRPElementCategory,
  MFGOrder.MRPPlanningSegment AS MRPPlanningSegment,
  cast( MFGOrder.MRPPlanningSegmentType as plaab ) AS MRPPlanningSegmentType,
  MFGOrder.MaterialShortageProfile AS MaterialShortageProfile,
  MFGOrder.MaterialShortageProfileCount AS MaterialShortageProfileCount,
  MFGOrder.Material AS Material,
  MFGOrder.MRPController AS MRPController,
  MFGOrder.FactoryCalendar AS FactoryCalendar,
  MFGOrder.ProductionPlant AS ProductionPlant,
  MFGOrder.MRPArea AS MRPArea,
  MFGOrder.StorageLocation AS StorageLocation,
  MFGOrder.ManufacturingOrderType AS ManufacturingOrderType,
  MFGOrder.LateSupplyLatenessWorkdays AS LateSupplyLatenessWorkdays,
  MFGOrder.MaximumDelayInDays AS MaximumDelayInDays,
  MFGOrder.MaximumDelayInWorkdays AS MaximumDelayInWorkdays,
  MFGOrder.ManufacturingOrderIsLate AS ManufacturingOrderIsLate,
  MFGOrder.NumberOfUncoveredDemandItems AS NumberOfUncoveredDemandItems,
  MFGOrder.MRPElementOpenQuantity AS MRPElementOpenQuantity,
  MFGOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  MFGOrder.MRPElementDelayedQuantity AS MRPElementDelayedQuantity,
  MFGOrder.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  MFGOrder.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  MFGOrder.MfgOrderPlannedReleaseDate AS MfgOrderPlannedReleaseDate,
  MFGOrder.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  MFGOrder.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  MFGOrder.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  MFGOrder.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  MFGOrder.MaximumDelayDate AS MaximumDelayDate,
  MFGOrder.ProductionLine AS ProductionLine,
  MFGOrder.ProductionVersion AS ProductionVersion,
  MFGOrder.ProductionVersionText AS ProductionVersionText,
  MFGOrder.ProductionSupervisor AS ProductionSupervisor,
  MFGOrder.ComponentShortageDefinition AS ComponentShortageDefinition,
  MFGOrder.MfgOrderProgressStatus AS MfgOrderProgressStatus,
  cast( MFGOrder.MfgOrderProgressNextStatus as mfgorderprogressstatus ) AS MfgOrderProgressNextStatus,
  MFGOrder.MfgOrderStatusActualDate AS MfgOrderStatusActualDate,
  MFGOrder.MfgOrderNextStatusPlannedDate AS MfgOrderNextStatusPlannedDate,
  MFGOrder.MfgOrderStatusPlannedDate AS MfgOrderStatusPlannedDate,
  MFGOrder.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  MFGOrder.ProductionUnit AS ProductionUnit,
  MFGOrder.Reservation AS Reservation,
  MFGOrder.ManufacturingOrderText AS ManufacturingOrderText,
  MFGOrder._CacheMaterial AS _CacheMaterial,
  MFGOrder._Material AS _Material,
  MFGOrder._MfgOrderType AS _MfgOrderType,
  MFGOrder._MRPPlant AS _MRPPlant,
  MFGOrder._Order AS _Order,
  MFGOrder._ProductionPlant AS _ProductionPlant,
  MFGOrder._ShortageDefinition AS _ShortageDefinition,
  MFGOrder._StorageLocation AS _StorageLocation
FROM I_CacheMRPMfgOrder AS MFGOrder
INNER JOIN I_MRPAreaOfResponsibility AS _AreaOfResponsibility ON /* join condition not captured in parsed metadata */
;

Learn More