C_MRPManufacturingOrder

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_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 C_MRPManufacturingOrder AS
SELECT
  MFGOrder.MRPPlant AS MRPPlant,
  MFGOrder.MRPElement AS MRPElement,
  MFGOrder.MRPElementItem AS MRPElementItem,
  MFGOrder.MRPElementCategory AS MRPElementCategory,
  MFGOrder.MRPPlanningSegment AS MRPPlanningSegment,
  MFGOrder.MRPPlanningSegmentType 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.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  MFGOrder.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  dats_add_days ( MFGOrder.MfgOrderPlannedEndDate, cast ( MFGOrder.MaterialGoodsReceiptDuration as abap.int4 ) , 'UNCHANGED') AS GoodsReceiptDate,
  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,
  concat( MFGOrder.MaterialShortageProfile, MFGOrder.MaterialShortageProfileCount ) AS MaterialShortageDefinition,
  MFGOrder.MfgOrderProgressStatus AS MfgOrderProgressStatus,
  MFGOrder.MfgOrderProgressNextStatus AS MfgOrderProgressNextStatus,
  MFGOrder.MfgOrderStatusActualDate AS MfgOrderStatusActualDate,
  MFGOrder.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  MFGOrder.MRPElementOpenQuantity AS MRPElementOpenQuantity,
  MFGOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  MFGOrder.MRPElementDelayedQuantity AS MRPElementDelayedQuantity,
  MFGOrder.ProductionUnit AS ProductionUnit,
  MFGOrder.ManufacturingOrderIsLate AS ManufacturingOrderIsLate,
  MFGOrder.NumberOfUncoveredDemandItems AS NumberOfUncoveredDemandItems,
  cast( '' as char7 ) AS UICT_MissingComponentsText,
  MFGOrder.DurnPlndStatusToTodayInDays AS DurnPlndStatusToTodayInDays,
  cast ( '' as abap.char( 50 ) ) AS UICT_DurnPlndStatusToTodayTxt,
  _ManufacturingOrderDelay(P_SAPClient:$session.client).DurnToGRInWorkDays AS DurnToGRInWorkDays,
  cast( '' as mrp_ui_scheduled_gr_duration ) AS DurnToGRInWorkDaysFltr,
  cast( '' as abap.char( 50 ) ) AS UICT_GoodsReceiptWDaysTxt,
  0 AS UICT_GoodsReceiptWDCriticality,
  0 AS UICT_DurnToRelInWDCriticality,
  dats_days_between( $session.user_date, MFGOrder.MfgOrderNextStatusPlannedDate ) AS DurationToNextStatusInDays,
  cast( '' as abap.char( 50 ) ) AS UICT_MilestoneDaysTxt,
  0 AS UICT_MilestoneCDCriticality,
  _ManufacturingOrderDelay(P_SAPClient:$session.client).DurationToNextStatusInWorkdays AS DurationToNextStatusInWorkdays,
  cast( '' as mrp_ui_scheduled_gr_duration ) AS DurnToNextStsInWorkDaysFltr,
  cast( '' as abap.char( 50 ) ) AS UICT_MilestoneWDaysTxt,
  0 AS UICT_MilestoneWDCriticality,
  _ManufacturingOrderDelay(P_SAPClient:$session.client).DurnToStartInWorkDays AS DurnToStartInWorkDays,
  cast( 0 as mrp_ui_scheduled_duration ) AS DurnToStartInWorkDaysFltr,
  cast ( '' as abap.char( 50 ) ) AS UICT_StartWDaysTxt,
  0 AS UICT_StartWDCriticality,
  _ManufacturingOrderDelay(P_SAPClient:$session.client).DurnToFinishInWorkDays AS DurnToFinishInWorkDays,
  cast( 0 as mrp_ui_scheduled_duration ) AS DurnToFinishInWorkDaysFltr,
  cast ( '' as abap.char( 50 ) ) AS UICT_EndWDaysTxt,
  0 AS UICT_EndWDCriticality,
  MFGOrder.MaximumDelayInDays AS MaximumDelayInDays,
  cast( '' as abap.char( 50 ) ) AS MaximumDelayInDaysText,
  MFGOrder.MaximumDelayInWorkdays AS MaximumDelayInWorkdays,
  cast( '' as abap.char( 50 ) ) AS MaximumDelayInWorkDaysText,
  cast( '' as char7 ) AS MaximumDelayInWorkDaysFltr,
  _ManufacturingOrderDelay(P_SAPClient:$session.client).DurnPlndStatusToTodayInWrkdays AS DurnPlndStatusToTodayInWrkdays,
  cast ( '' as abap.char( 50 ) ) AS UICT_DurnPlndStsToTodayWDTxt,
  cast( '' as char7 ) AS DurnPlndStsToTodayWorkDaysFltr,
  MFGOrder.LateSupplyLatenessWorkdays AS LateSupplyLatenessWorkdays,
  cast( '' as abap.char( 50 ) ) AS UICT_LateSupplyLtnssWDstxt,
  cast( '' as char7 ) AS LateSupplyLatenessWorkDaysFltr,
  _ManufacturingOrderDelay(P_SAPClient:$session.client).DurnToReleaseInWorkDays AS DurnToReleaseInWorkDays,
  cast( '' as abap.char( 50 ) ) AS UICT_ReleaseWDaysTxt,
  cast( '' as mrp_ui_scheduled_duration ) AS DurnToReleaseInWorkDaysFltr,
  cast( '' as abap.char( 3 )) AS MfgOrderProblemCategory,
  cast( '' as abap.char( 255 ) ) AS MfgOrderProblemCategoryName,
  '' AS Name,
  MFGOrder.ManufacturingOrderText AS ManufacturingOrderText,
  MFGOrder._Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  _MRPPlanningSegment.MRPPlanningSegmentExternalCode AS MRPPlanningSegmentExternalCode,
  _OrderStatusText.MfgOrderProgressStatusName AS MfgOrderProgressStatusName,
  _MRPArea.MRPAreaText AS MRPAreaText,
  _MRPController.MRPControllerName AS MRPControllerName,
  _MRPElementCategoryText.MRPElementCategoryName AS MRPElementCategoryName,
  _MRPElementCategoryText.MRPElementCategoryShortName AS MRPElementCategoryShortName,
  _MRPElementCategoryText.MRPElementCategoryShortName AS MRPElementName,
  _MfgOrdProgressNextStatusText.MfgOrderProgressNextStatusName AS MfgOrderProgressNextStatusName,
  cast( concat( _MfgOrdProgressNextStatusText.MfgOrderProgressNextStatusName, concat(' (', concat(_MfgOrdProgressNextStatusText.MfgOrderProgressNextStatus, ')')) ) as abap.char(24) ) as NextMilestone AS char24asNextMilestone,
  _OrderTypeText.OrderTypeName AS OrderTypeName,
  _MRPPlanningPlant.PlantName AS MRPPlantName,
  cast( concat( _MRPPlanningPlant.PlantName, concat(' (', concat(MFGOrder.MRPPlant, ')')) ) as abap.char(100) ) as MRPPlanningPlantName AS char100asMRPPlanningPlantName,
  cast( concat( _MRPProductionPlant.PlantName, concat(' (', concat(MFGOrder.ProductionPlant, ')')) ) as abap.char(100) ) as ProductionPlantName AS char100asProductionPlantName,
  _ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  _MaterialShortageDefinition.MaterialShortageDefinitionName AS MaterialShortageDefinitionName,
  _WorkCenterCategoryText.WorkCenterCategoryName AS WorkCenterCategoryName,
  cast( '' as abap_boolean preserving type ) AS UICT_ShortageDefinitionAssign,
  cast( 'X' as abap_boolean preserving type ) AS UICT_BufferUpdateIndicator,
  cast( '' as matnr ) AS UICT_BufferMaterial,
  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
INNER JOIN I_MRPAreaOfResponsibility AS _AreaOfResponsibility ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgOrdProgressStatusText AS _OrderStatusText ON MfgOrderProgressStatus = _OrderStatusText.MfgOrderProgressStatus AND _OrderStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON MRPController = _MRPController.MRPController AND MRPPlant = _MRPController.Plant  -- association [0..1]
LEFT OUTER JOIN I_MRPElementCategoryText AS _MRPElementCategoryText ON MRPElementCategory = _MRPElementCategoryText.MRPElementCategory AND _MRPElementCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_MfgOrdProgressNextStatusText AS _MfgOrdProgressNextStatusText ON MfgOrderProgressNextStatus = _MfgOrdProgressNextStatusText.MfgOrderProgressNextStatus AND _MfgOrdProgressNextStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OrderTypeText AS _OrderTypeText ON ManufacturingOrderType = _OrderTypeText.OrderType AND _OrderTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MRPPlanningPlant ON MRPPlant = _MRPPlanningPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MRPProductionPlant ON ProductionPlant = _MRPProductionPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor AND MRPPlant = _ProductionSupervisor.Plant  -- association [0..1]
LEFT OUTER JOIN I_MRPPlanningSegment AS _MRPPlanningSegment ON MRPPlant = _MRPPlanningSegment.MRPPlant AND Material = _MRPPlanningSegment.Material AND MRPArea = _MRPPlanningSegment.MRPArea AND MRPPlanningSegmentType = _MRPPlanningSegment.MRPPlanningSegmentType AND MRPPlanningSegment = _MRPPlanningSegment.MRPPlanningSegment AND MaterialShortageProfile = _MRPPlanningSegment.MaterialShortageProfile  -- association [0..1]
LEFT OUTER JOIN C_MaterialShortageDefinition AS _MaterialShortageDefinition ON MaterialShortageProfile = _MaterialShortageDefinition.MaterialShortageProfile AND MaterialShortageProfileCount = _MaterialShortageDefinition.MaterialShortageProfileCount  -- association [0..1]
LEFT OUTER JOIN P_MRPManufacturingOrderDelay AS _ManufacturingOrderDelay ON MRPPlant = _ManufacturingOrderDelay.MRPPlant AND MRPElement = _ManufacturingOrderDelay.MRPElement AND MRPElementItem = _ManufacturingOrderDelay.MRPElementItem AND MRPElementCategory = _ManufacturingOrderDelay.MRPElementCategory AND MRPPlanningSegment = _ManufacturingOrderDelay.MRPPlanningSegment AND MRPPlanningSegmentType = _ManufacturingOrderDelay.MRPPlanningSegmentType AND MaterialShortageProfile = _ManufacturingOrderDelay.MaterialShortageProfile AND MaterialShortageProfileCount = _ManufacturingOrderDelay.MaterialShortageProfileCount AND Material = _ManufacturingOrderDelay.Material  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterCategoryText AS _WorkCenterCategoryText ON ProductionLine = _WorkCenterCategoryText.WorkCenterCategoryCode AND _WorkCenterCategoryText.Language = $session.system_language  -- association [0..*]
;