I_MRPPlanningSegment

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_MRPPlanningSegment.
-- 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: IMRPPLANSEGMENT

CREATE VIEW I_MRPPlanningSegment AS
SELECT
  MRPPlant,
  Material,
  MRPArea,
  MRPPlanningSegmentType,
  mrpplanningsegmentnumber AS MRPPlanningSegment,
  MaterialShortageProfile,
  mrpplanningsegmentnumberext AS MRPPlanningSegmentExternalCode,
  substring(pph_cache_plseg.mrpplanningsegmentnumber, 1, 10) AS Reservation,
  substring(pph_cache_plseg.mrpplanningsegmentnumber, 11, 4) AS ReservationItem,
  mrpavailablestockquantity AS MRPAvailableStockQty,
  pastdueopeningdateelements AS NmbrOfPastDueOpeningDateElmnts,
  pastduestartdateelements AS NumberOfPastDueStartDateElmnts,
  pastduefinishdateelements AS NumberOfPastDueEndDateElements,
  MaterialHasMRPNote,
  '' AS MRPMaterialNoteText,
  reschedulein AS NumberOfRescheduleInElements,
  rescheduleout AS NumberOfRescheduleOutElements,
  cancelprocess AS NumberOfCancelProcesses
FROM pph_cache_plseg
LEFT OUTER JOIN I_Plant AS _Plant ON MRPPlant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- association [0..1]
LEFT OUTER JOIN I_ReservationItem AS _Reservation ON Reservation = _Reservation.Reservation AND ReservationItem = _Reservation.ReservationItem AND _Reservation.RecordType = ''  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;