I_OrderSequence

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_OrderSequence.
-- 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: IORDERSEQUENCE

CREATE VIEW I_OrderSequence AS
SELECT
  cast(affl.aufpl as pph_aufpl preserving type) AS OrderInternalID,
  aufv.aufnr AS OrderID,
  affl.plnfl AS Sequence,
  affl.ltxa1 AS SequenceText,
  affl.txtsp AS Language,
  cast(aufv.autyp as pph_autyp preserving type) AS OrderCategory,
  cast(aufv.auart as aufart preserving type) AS OrderType,
  affl.flgat AS SequenceCategory,
  cast(aufv.werks as pwwrk preserving type) AS ProductionPlant,
  cast(aufv.fevor as pph_fevor preserving type) AS ProductionSupervisor,
  cast(affl.plnty as billofoperationstype preserving type) AS BillOfOperationsType,
  cast(affl.plnnr as billofoperations preserving type) AS BillOfOperations,
  cast(affl.plnnr as billofoperationsgroup preserving type) AS BillOfOperationsGroup,
  cast(affl.plnal as billofoperationsvariant preserving type) AS BillOfOperationsVariant,
  affl.auschl AS SequenceSchedulingAlignment,
  affl.bezfl AS ReferenceSequence,
  affl.objnr AS ObjectInternalID,
  affl.bknt1 AS BranchOperationInternalID,
  affl.bknt2 AS ReturnOperationInternalID,
  aufv.plnme AS BillOfOperationsUnit,
  affl.losvn AS MinimumLotSizeQuantity,
  affl.losbs AS MaximumLotSizeQuantity
FROM affl
INNER JOIN caufv AS aufv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LogisticsOrder AS _Order ON OrderID = _Order.OrderID  -- association [1..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [1..1]
LEFT OUTER JOIN I_OrderType AS _OrderType ON OrderType= _OrderType.OrderType  -- association [1..1]
LEFT OUTER JOIN I_OrderSequenceBySemKey AS _ReferenceSequence ON OrderID = _ReferenceSequence.OrderID AND ReferenceSequence = _ReferenceSequence.Sequence  -- association [0..1]
LEFT OUTER JOIN I_SequenceCategory AS _SequenceCategory ON SequenceCategory = _SequenceCategory.SequenceCategory  -- association [1..1]
LEFT OUTER JOIN I_SequenceSchedulingAlignment AS _SequenceSchedulingAlignment ON SequenceSchedulingAlignment = _SequenceSchedulingAlignment.SequenceSchedulingAlignment  -- association [0..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON ProductionPlant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON ProductionPlant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperations AS _BillOfOperationsVariant ON BillOfOperationsType = _BillOfOperationsVariant.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsVariant.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsVariant.BillOfOperationsVariant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BillOfOperationsUnit ON BillOfOperationsUnit = _BillOfOperationsUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON ObjectInternalID = _StatusObject.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_OrderSequenceLongText AS _LongText ON OrderInternalID = _LongText.OrderInternalID AND SequenceInternalID = _LongText.SequenceInternalID  -- association [0..1]
;