I_ProductionOrderSequence

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_ProductionOrderSequence.
-- 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_ProductionOrderSequence AS
SELECT
  cast(affl.OrderID as vdm_manufacturingorder preserving type) AS ProductionOrder,
  cast(affl.Sequence as vdm_prodnordersequence preserving type) AS ProductionOrderSequence,
  affl.OrderInternalID AS OrderInternalID,
  affl.SequenceInternalID AS SequenceInternalID,
  affl.SequenceCategory AS SequenceCategory,
  cast(affl.OrderType as vdm_prodnordertype preserving type) AS ProductionOrderType,
  cast(affl.SequenceText as vdm_flgtext preserving type) AS ProductionOrderSequenceText,
  affl.SequenceHasLongText AS SequenceHasLongText,
  cast(affl.Language as pph_longtextlang preserving type) AS LongTextLanguage,
  cast(vornr1.Operation_2 as vdm_vornr1 preserving type) AS SequenceBranchOperation,
  cast(vornr2.Operation_2 as vdm_vornr2 preserving type) AS SequenceReturnOperation,
  affl.ProductionPlant AS ProductionPlant,
  affl.BillOfOperationsType AS BillOfOperationsType,
  affl.BillOfOperationsGroup AS BillOfOperationsGroup,
  affl.BillOfOperations AS BillOfOperationsVariant,
  affl.ReferenceSequence AS BillOfOperationsSequence,
  affl.SequenceSchedulingAlignment AS SequenceSchedulingAlignment,
  affl.ObjectInternalID AS ObjectInternalID,
  affl.BillOfOperationsUnit AS BillOfOperationsUnit,
  affl.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  affl.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  affl._OrderInternalID AS _OrderInternalID,
  affl._OrderSequence AS _SequenceInternalID,
  affl._SequenceCategory AS _SequenceCategory,
  affl._SequenceSchedulingAlignment AS _SequenceSchedulingAlignment,
  affl._Plant AS _Plant,
  affl._BillOfOperationsType AS _BillOfOperationsType,
  affl._BillOfOperationsGroup AS _BillOfOperationsGroup,
  affl._BillOfOperationsUnit AS _BillOfOperationsUnit,
  affl._Language AS _Language
FROM I_OrderSequenceBySemKey AS affl
LEFT OUTER JOIN I_ProductionOrderType AS _ProductionOrderType ON ProductionOrderType = _ProductionOrderType.ProductionOrderType  -- association [1..1]
LEFT OUTER JOIN I_MfgBillOfOperations AS _BillOfOperationsVariant ON BillOfOperationsType = _BillOfOperationsVariant.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsVariant.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsVariant.BillOfOperationsVariant  -- association [0..1]
LEFT OUTER JOIN I_MfgBillOfOperationsSequence AS _BillOfOperationsSequence ON BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsSequence.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsSequence.BillOfOperationsVariant AND BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON ObjectInternalID = _StatusObject.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrder AS _ProductionOrderText ON ProductionOrder = _ProductionOrderText.ProductionOrder  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlantText ON ProductionPlant = _ProductionPlantText.Plant  -- association [1..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObjectText ON ObjectInternalID = _StatusObjectText.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrderOperation_2 AS _ProductionOrderOperation ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProdnOrderSequenceLongText AS _LongText ON /* condition not available in parsed metadata */  -- association [0..*]
;