I_OrderSequenceBasic

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_OrderSequenceBasic.
-- 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_OrderSequenceBasic AS
SELECT
  cast(affl.aufpl as pph_aufpl preserving type) AS OrderInternalID,
  affl.plnfl AS Sequence,
  affl.ltxa1 AS SequenceText,
  affl.txtsp AS Language,
  affl.flgat AS SequenceCategory,
  cast(affl.plnty as billofoperationstype preserving type) AS BillOfOperationsType,
  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
FROM affl
LEFT OUTER JOIN I_LogisticsOrder AS _LogisticsOrder ON OrderInternalID = _LogisticsOrder.OrderInternalBillOfOperations  -- association [1..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_OrderSequenceBasic AS _ReferenceSequence ON OrderInternalID = _ReferenceSequence.OrderInternalID AND ReferenceSequence = _ReferenceSequence.Sequence  -- association [0..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..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_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]
;