I_ManufacturingOrderSequence

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_ManufacturingOrderSequence.
-- 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: IMFGORDSEQUENCE

CREATE VIEW I_ManufacturingOrderSequence AS
SELECT
  cast(affl.OrderID as manufacturingorder preserving type) AS ManufacturingOrder,
  cast(affl.Sequence as manufacturingordersequence preserving type) AS ManufacturingOrderSequence,
  affl.OrderInternalID AS OrderInternalID,
  affl.SequenceInternalID AS SequenceInternalID,
  cast(affl.SequenceText as mfgordersequencetext preserving type) AS MfgOrderSequenceText,
  affl.SequenceHasLongText AS MfgOrderSequenceHasLongText,
  cast(affl.Language as pph_longtextlang preserving type) AS LongTextLanguage,
  cast(vornr1.Operation_2 as vdm_vornr1 preserving type) AS MfgOrderSequenceBrnchOperation,
  cast(vornr2.Operation_2 as vdm_vornr2 preserving type) AS MfgOrderSequenceRetOperation,
  cast(affl.OrderCategory as manufacturingordercategory preserving type) AS ManufacturingOrderCategory,
  cast(affl.OrderType as manufacturingordertype preserving type) AS ManufacturingOrderType,
  affl.SequenceCategory AS MfgOrderSequenceCategory,
  affl.ProductionPlant AS ProductionPlant,
  affl.ReferenceSequence AS ReferenceSequence,
  affl.BillOfOperationsType AS BillOfOperationsType,
  affl.BillOfOperationsGroup AS BillOfOperationsGroup,
  affl.BillOfOperations AS BillOfOperationsVariant,
  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._LongText AS _LongText,
  affl._Language AS _Language
FROM I_OrderSequenceBySemKey AS affl
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderSequence AS _ReferenceSequence ON ManufacturingOrder = _ReferenceSequence.ManufacturingOrder AND ReferenceSequence = _ReferenceSequence.ManufacturingOrderSequence  -- association [0..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_StatusObject AS _StatusObject ON ObjectInternalID = _StatusObject.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderOperation AS _MfgOrderOperation ON OrderInternalID = _MfgOrderOperation.MfgOrderInternalID  -- association [1..*]
LEFT OUTER JOIN I_MfgOrderSequenceLongText AS _MfgOrderSequenceLongText ON OrderInternalID = _MfgOrderSequenceLongText.OrderInternalID AND SequenceInternalID = _MfgOrderSequenceLongText.SequenceInternalID AND LongTextLanguage = _MfgOrderSequenceLongText.LongTextLanguage  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrderText ON ManufacturingOrder = _MfgOrderText.ManufacturingOrder  -- 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]
;