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
  I_CacheMRPMfgOrder.MRPPlant AS MRPPlant,
  cast( I_CacheMRPMfgOrder.MRPPlanningSegmentType as plaab) AS MRPPlanningSegmentType,
  I_CacheMRPMfgOrder.MRPPlanningSegment AS MRPPlanningSegment,
  I_CacheMRPMfgOrder.MaterialShortageProfile AS MaterialShortageProfile,
  I_CacheMRPMfgOrder.MaterialShortageProfileCount AS MaterialShortageProfileCount,
  I_CacheMRPMfgOrder.MRPElementCategory AS MRPElementCategory,
  concat(ltrim( I_CacheMRPMfgOrder.MRPElement, '0' ), concat('-', ltrim( I_CacheMRPMfgOrder.MRPElementItem, '0')) ) AS MRPElement,
  I_CacheMRPMfgOrder.Material AS Material,
  I_CacheMRPMfgOrder.MRPArea AS MRPArea,
  I_CacheMRPMfgOrder.FactoryCalendar AS 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,
  I_CacheMRPMfgOrder.ProductionPlant AS ProductionPlant,
  I_CacheMRPMfgOrder.MRPController AS MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  I_CacheMRPMfgOrder.ManufacturingOrderType AS ManufacturingOrderType,
  _MfgOrderTypeText.ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  _MRPElementCategoryText.MRPElementCategoryName AS MRPElementCategoryName,
  _MRPElementCategoryText.MRPElementCategoryShortName AS MRPElementCategoryShortName,
  I_CacheMRPMfgOrder.MfgOrderProgressStatus AS MfgOrderProgressStatus,
  cast(_ProgressStatusText.MfgOrderProgressStatusName as mfgorderprogressstatustext ) AS MfgOrderProgressStatusName,
  I_CacheMRPMfgOrder.MfgOrderProgressNextStatus AS MfgOrderProgressNextStatus,
  cast(_NextStatusText.MfgOrderProgressNextStatusName as nextmilestone) AS MfgOrderProgressNextStatusName,
  I_CacheMRPMfgOrder.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  I_CacheMRPMfgOrder.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  I_CacheMRPMfgOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  I_CacheMRPMfgOrder.MRPElementAvailyOrRqmtDate AS MRPElementAvailyOrRqmtDate,
  I_CacheMRPMfgOrder.MRPElementOpenQuantity AS MRPElementOpenQuantity,
  I_CacheMRPMfgOrder.ProductionLine AS ProductionLine,
  cast(_ProductionLineVH._WorkCenterTextBySemanticKey[ 1: Language = $session.system_language ].WorkCenterText as productionlinetext preserving type) AS ProductionLineText,
  I_CacheMRPMfgOrder.ProductionSupervisor AS ProductionSupervisor,
  _ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  I_CacheMRPMfgOrder.ProductionVersion AS ProductionVersion,
  I_CacheMRPMfgOrder.ProductionVersionText AS ProductionVersionText,
  I_CacheMRPMfgOrder.StorageLocation AS StorageLocation,
  I_CacheMRPMfgOrder.ComponentShortageDefinition AS ComponentShortageDefinition,
  I_CacheMRPMfgOrder.MaterialBaseUnit AS MaterialBaseUnit,
  I_CacheMRPMfgOrder.ProductionUnit AS ProductionUnit,
  I_CacheMRPMfgOrder.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  I_CacheMRPMfgOrder.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  cast( I_CacheMRPMfgOrder.NumberOfUncoveredDemandItems as missingcomponents preserving type) AS NumberOfComponentsWithProblems,
  I_CacheMRPMfgOrder.MaximumDelayInDays AS MaximumDelayInDays,
  I_CacheMRPMfgOrder.MaximumDelayInWorkdays AS 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,
  I_CacheMRPMfgOrder.LateSupplyLatenessWorkdays AS LateSupplyLatenessWorkdays,
  cast(I_CacheMRPMfgOrder._CacheSupDemItem.MRPElementDelayedQuantity as latesupplyquantity) AS LateSupplyQuantity,
  cast(I_CacheMRPMfgOrder._CacheSupDemItem.MaximumDelayDate as requirementdate preserving type) AS LateSupplyEarliestDemandDate,
  I_CacheMRPMfgOrder.ManufacturingOrderIsLate AS ManufacturingOrderIsLate,
  I_CacheMRPMfgOrder.MfgOrderStatusActualDate AS MfgOrderStatusActualDate,
  I_CacheMRPMfgOrder.MfgOrderNextStatusPlannedDate AS MfgOrderNextStatusPlannedDate,
  I_CacheMRPMfgOrder.MfgOrderPlannedReleaseDate AS MfgOrderPlannedReleaseDate,
  cast( '' as mfgordernextstatusdate ) AS MfgOrderNextStatusDate,
  cast( 0 as durnplndstatustotodayindays) AS DurnPlndStatusToTodayInDays,
  I_CacheMRPMfgOrder.DurnPlndStatusToTodayInWrkdays AS 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,
  I_CacheMRPMfgOrder.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  I_CacheMRPMfgOrder.MaterialCompIsProcuredDirectly AS MaterialCompIsProcuredDirectly,
  cast(I_CacheMRPMfgOrder.ProjectNetwork as ps_pspid_edit) AS MatlPlngProjectNetwork,
  I_CacheMRPMfgOrder.WBSElementInternalID AS WBSElementInternalID,
  I_CacheMRPMfgOrder.WBSElement AS WBSElement,
  I_CacheMRPMfgOrder.PlanningSegmentDocument AS PlanningSegmentDocument,
  I_CacheMRPMfgOrder.PlanningSegmentDocumentItem AS PlanningSegmentDocumentItem,
  cast( '' as mrpindividualsegment) AS MRPPlanningSegmentExternalCode,
  _MaterialShortageDef.MaterialShortageDefinitionName AS MaterialShortageDefinitionName,
  I_CacheMRPMfgOrder._StorageLocation AS _StorageLocation,
  I_CacheMRPMfgOrder._Material AS _Material
FROM I_CacheMRPMfgOrder
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]
;