C_CacheMRPMfgOrder

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_CacheMRPMfgOrder.
-- 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: CCACHEMRPMFGORD

CREATE VIEW C_CacheMRPMfgOrder AS
SELECT
  MRPPlant,
  cast(MRPPlanningSegmentType as plaab) AS MRPPlanningSegmentType,
  MRPPlanningSegment,
  MaterialShortageProfile,
  MaterialShortageProfileCount,
  MRPElementCategory,
  CONCAT(LTRIM( MRPElement, '0' ), CONCAT('-', LTRIM( MRPElementItem, '0')) ) AS MRPElement,
  I_CacheMRPMfgOrder.Material AS Material,
  I_CacheMRPMfgOrder.MRPArea AS MRPArea,
  FactoryCalendar,
  _PlantVH.PlantName AS PlantName,
  case when _MaterialText[ 1: Language = $session.system_language ].MaterialName is not null and _MaterialText[ 1: Language = $session.system_language ].MaterialName != '' then _MaterialText[ 1: Language = $session.system_language ].MaterialName when _MaterialText[ 1: Language = 'E' ].MaterialName is not null and _MaterialText[ 1: Language = 'E' ].MaterialName != '' then _MaterialText[ 1: Language = $session.system_language ].MaterialName else I_CacheMRPMfgOrder.Material end as MaterialName AS MaterialendasMaterialName,
  _MRPAreaVH.MRPAreaText AS MRPAreaText,
  ProductionPlant,
  I_CacheMRPMfgOrder.MRPController AS MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  ManufacturingOrderType,
  _MfgOrderTypeText.ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  _MRPElementCategoryText.MRPElementCategoryName AS MRPElementCategoryName,
  _MRPElementCategoryText.MRPElementCategoryShortName AS MRPElementCategoryShortName,
  MfgOrderProgressStatus,
  cast(_ProgressStatusText.MfgOrderProgressStatusName as mfgorderprogressstatustext ) AS MfgOrderProgressStatusName,
  MfgOrderProgressNextStatus,
  cast(_NextStatusText.MfgOrderProgressNextStatusName as nextmilestone) AS MfgOrderProgressNextStatusName,
  MfgOrderPlannedStartDate,
  MfgOrderPlannedEndDate,
  MfgOrderPlannedTotalQty,
  MRPElementAvailyOrRqmtDate,
  MRPElementOpenQuantity,
  ProductionLine,
  cast(_ProductionLineVH._WorkCenterTextBySemanticKey[ 1: Language = $session.system_language ].WorkCenterText as productionlinetext preserving type) AS ProductionLineText,
  ProductionSupervisor,
  _ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  ProductionVersion,
  ProductionVersionText,
  StorageLocation,
  ComponentShortageDefinition,
  MaterialBaseUnit,
  ProductionUnit,
  UnitOfMeasureNumberOfDecimals,
  UnitOfMeasureDspNmbrOfDcmls,
  cast( NumberOfUncoveredDemandItems as missingcomponents preserving type) AS NumberOfComponentsWithProblems,
  MaximumDelayInDays,
  MaximumDelayInWorkdays,
  cast( '' as mrp_ui_comp_coverage ) AS CompCvrgInWrkDaysSelection,
  cast( '' as mrp_ui_material_delay ) AS MaterialDlyInWorkDaysSelection,
  cast( '' as mfgorderprogressstatustext ) AS MfgOrdProgressStatusSelection,
  cast( '' as mrp_ui_delay_in_process) AS DelayInProcessSelection,
  LateSupplyLatenessWorkdays,
  cast(I_CacheMRPMfgOrder._CacheSupDemItem.MRPElementDelayedQuantity as latesupplyquantity) AS LateSupplyQuantity,
  cast(I_CacheMRPMfgOrder._CacheSupDemItem.MaximumDelayDate as requirementdate preserving type) AS LateSupplyEarliestDemandDate,
  ManufacturingOrderIsLate,
  MfgOrderStatusActualDate,
  MfgOrderNextStatusPlannedDate,
  MfgOrderPlannedReleaseDate,
  cast( '' as mfgordernextstatusdate ) AS MfgOrderNextStatusDate,
  cast( 0 as durnplndstatustotodayindays) AS DurnPlndStatusToTodayInDays,
  DurnPlndStatusToTodayInWrkdays,
  cast( '' as durationuntilnextstatusindays) AS DurationToNextStatusInDays,
  cast( 0 as abap.int1) AS DurnToNextStsInDaysCritlty,
  cast( '' as durationtonextstatusinworkdays) AS DurationToNextStatusInWorkdays,
  cast( 0 as abap.int1) AS DurnToNextStsInWorkdaysCritlty,
  cast( '' as durationtoreleaseinworkdays) AS DurationUntilReleaseInWorkdays,
  cast( 0 as abap.int1) AS DurnUntilRelInWorkdaysCritlty,
  cast( '' as durationuntilstartinworkdays) AS DurationUntilStartInWorkdays,
  cast( 0 as abap.int1) AS DurnTilStartInWorkdaysCritlty,
  cast( '' as durationuntilendinworkdays) AS DurationUntilEndInWorkdays,
  cast( 0 as abap.int1) AS DurnTilEndInWorkdaysCritlty,
  cast( 0 as durationuntilgrinworkdays) AS DurationUntilGRInWorkdays,
  cast( 0 as abap.int1) AS DurnUntilGRInWorkdaysCritlty,
  MaterialGoodsReceiptDuration,
  MaterialCompIsProcuredDirectly,
  cast(ProjectNetwork as ps_pspid_edit) AS MatlPlngProjectNetwork,
  WBSElementInternalID,
  WBSElement,
  PlanningSegmentDocument,
  PlanningSegmentDocumentItem,
  cast( '' as mrpindividualsegment) AS MRPPlanningSegmentExternalCode,
  _MaterialShortageDef.MaterialShortageDefinitionName AS MaterialShortageDefinitionName,
  I_CacheMRPMfgOrder._StorageLocation AS _StorageLocation,
  I_CacheMRPMfgOrder._Material AS _Material
INNER JOIN I_SDMAreaOfResponsibility AS SDMAreaOfResponsibility ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialShortageDefinition AS _MaterialShortageDef ON MaterialShortageProfile = _MaterialShortageDef.MaterialShortageProfile AND MaterialShortageProfileCount = _MaterialShortageDef.MaterialShortageProfileCount  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderTypeText AS _MfgOrderTypeText ON ManufacturingOrderType = _MfgOrderTypeText.ManufacturingOrderType AND _MfgOrderTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON ProductionPlant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderCategoryText AS _MfgOrderCategoryText ON MRPElementCategory = _MfgOrderCategoryText.ManufacturingOrderCategory AND _MfgOrderCategoryText.Language = $session.system_language  -- 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 I_MfgOrdProgressStatusText AS _ProgressStatusText ON MfgOrderProgressStatus = _ProgressStatusText.MfgOrderProgressStatus AND _ProgressStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MfgOrdProgressNextStatusText AS _NextStatusText ON MfgOrderProgressNextStatus = _NextStatusText.MfgOrderProgressNextStatus AND _NextStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON MRPPlant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN C_ComponentCoverageVH AS _ComponentCoverage ON _ComponentCoverage.CompCvrgInWrkDaysSelection = CompCvrgInWrkDaysSelection  -- association [0..1]
LEFT OUTER JOIN C_MaterialDelayVH AS _MaterialDelay ON _MaterialDelay.MaterialDlyInWorkDaysSelection = MaterialDlyInWorkDaysSelection  -- association [0..1]
LEFT OUTER JOIN C_MfgOrderProgressStatusVH AS _MfgOrderProgressStatus ON _MfgOrderProgressStatus.MfgOrdProgressStatusSelection = MfgOrdProgressStatusSelection  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderMRPControllerVH AS _MRPControllerVH ON MRPPlant = _MRPControllerVH.Plant AND MRPController = _MRPControllerVH.MRPController  -- association [0..1]
LEFT OUTER JOIN C_PlantVH AS _PlantVH ON MRPPlant = _PlantVH.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductionLineStdVH AS _ProductionLineVH ON ProductionPlant = _ProductionLineVH.Plant AND ProductionLine = _ProductionLineVH.ProductionLine  -- association [0..1]
LEFT OUTER JOIN I_ProductionVersionStdVH AS _ProductionVersionVH ON ProductionPlant = _ProductionVersionVH.Plant AND ProductionVersion = _ProductionVersionVH.ProductionVersion AND Material = _ProductionVersionVH.Material  -- association [0..1]
LEFT OUTER JOIN C_MRPAreaValHelp AS _MRPAreaVH ON MRPArea = _MRPAreaVH.MRPArea AND MRPPlant = _MRPAreaVH.Plant  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderProdnSupervisorVH AS _ProductionSupervisorVH ON ProductionPlant = _ProductionSupervisorVH.Plant AND ProductionSupervisor = _ProductionSupervisorVH.ProductionSupervisor  -- association [0..1]
;