I_OrderOperationBySemKey

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_OrderOperationBySemKey.
-- 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_OrderOperationBySemKey AS
SELECT
  afko.OrderID AS OrderID,
  afvc.Sequence AS Sequence,
  afvc.Operation_2 AS OrderOperation,
  afvc.OrderInternalID AS OrderInternalID,
  afvc.OrderOperationInternalID AS OrderOperationInternalID,
  afvc.OperationText AS OperationText,
  afvc.OperationSecondText AS OperationSecondText,
  afvc._OrderInternalID AS _OrderInternalID
FROM I_OrderOperationBasic AS afvc
INNER JOIN I_LogisticsOrderBasic AS afko 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_OrderSequenceBySemKey AS _OrderSequence ON OrderID = _OrderSequence.OrderID AND Sequence = _OrderSequence.Sequence  -- association [0..1]
LEFT OUTER JOIN I_OrderOperation AS _OrderOperationInternalID ON OrderInternalID = _OrderOperationInternalID.OrderInternalID AND OrderOperationInternalID = _OrderOperationInternalID.OrderOperationInternalID  -- association [1..1]
;