Sadl_V_Exp_Vocan_SOI

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 Sadl_V_Exp_Vocan_SOI.
-- 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: SADL_V_EVOC_SOI

CREATE VIEW Sadl_V_Exp_Vocan_SOI AS
SELECT
  node_key AS NodeKey,
  parent_key AS ParentKey,
  _SalesOrder.SalesOrderId AS SalesOrderId,
  so_item_pos AS ItemPosition,
  currency_code AS CurrencyCode,
  gross_amount AS GrossAmount,
  net_amount AS NetAmount,
  tax_amount AS TaxAmount
FROM snwd_so_i
LEFT OUTER JOIN Sadl_V_Exp_Vocan_SO AS _SalesOrder ON ParentKey = _SalesOrder.NodeKey  -- association [1..1]
;