Sadl_V_Aunit_So_C

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_Aunit_So_C.
-- 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: SADLVASOC

CREATE VIEW Sadl_V_Aunit_So_C AS
SELECT
  SalesOrderID,
  SalesOrder.created_by AS created_by,
  CurrencyTab.ktext AS CurrencyTabText,
  created_at,
  changed_by,
  changed_at,
  buyer_guid,
  currency_code AS Currency,
  currency_code AS CurrencyAgain,
  currency_code AS CurrencyConsumption,
  currency_code AS CurrencyWithFK,
  gross_amount,
  net_amount,
  tax_amount,
  node_key,
  _Currency.spras AS CurrencySpras,
  _Currency._Language AS _CurrencyLanguageCons
FROM SADL_V_AUnit_SO_TP AS SalesOrder
LEFT OUTER JOIN tcurt AS CurrencyTab ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Sadl_V_Aunit_Soi_C AS _Items ON SalesOrder.node_key = _Items.parent_key  -- association [0..*]
LEFT OUTER JOIN Sadl_V_Aunit_Soi_C AS _Items2 ON SalesOrder.node_key = _Items2.parent_key  -- association [0..*]
;