I_MfgOrderSequence

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_MfgOrderSequence.
-- 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: IPPMFGORDSEQ

CREATE VIEW I_MfgOrderSequence 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.Language AS Language,
  cast(vornr1.Operation as vornr1 preserving type) AS MfgOrderSequenceBrnchOperation,
  cast(vornr1.Operation_2 as vdm_vornr1 preserving type) AS MfgOrderSqncBranchOperation_2,
  cast(vornr2.Operation as vornr2 preserving type) AS MfgOrderSequenceRetOperation,
  cast(vornr2.Operation_2 as vdm_vornr2 preserving type) AS MfgOrderSqncReturnOperation_2,
  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.BillOfOperationsType AS BillOfOperationsType,
  affl.BillOfOperations AS BillOfOperations,
  affl.BillOfOperationsGroup AS BillOfOperationsGroup,
  affl.BillOfOperationsVariant AS BillOfOperationsVariant,
  affl.SequenceSchedulingAlignment AS SequenceSchedulingAlignment,
  affl.ObjectInternalID AS ObjectInternalID,
  affl.BillOfOperationsUnit AS BillOfOperationsUnit,
  affl.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  affl.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  affl._StatusObject AS _StatusObject,
  affl._OrderInternalID AS _OrderInternalID,
  affl._SequenceCategory AS _SequenceCategory,
  affl._SequenceSchedulingAlignment AS _SequenceSchedulingAlignment,
  affl._Plant AS _Plant,
  affl._BillOfOperationsType AS _BillOfOperationsType,
  affl._BillOfOperationsVariant AS _BillOfOperationsVariant,
  affl._BillOfOperationsUnit AS _BillOfOperationsUnit,
  affl._LongText AS _LongText,
  affl._Language AS _Language
FROM I_OrderSequence AS affl
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
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_MfgOrderSequence AS _ReferenceSequence ON ManufacturingOrder = _ReferenceSequence.ManufacturingOrder AND ReferenceSequence = _ReferenceSequence.ManufacturingOrderSequence  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperations = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup2 ON BillOfOperationsType = _BillOfOperationsGroup2.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup2.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN I_MfgBillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperations = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [0..1]
LEFT OUTER JOIN I_MfgBillOfOperations AS _BillOfOperations2 ON BillOfOperationsType = _BillOfOperations2.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations2.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations2.BillOfOperationsVariant  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.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 Language = _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]
;