CdsFrwk_Sales_Order_Item

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 CdsFrwk_Sales_Order_Item.
-- 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: CDSFRWK_DEMO_1

CREATE VIEW CdsFrwk_Sales_Order_Item AS
SELECT
  snwd_so_i.node_key AS so_item_guid,
  parent_key AS so_guid,
  snwd_so_i.product_guid AS product_guid,
  snwd_so_i.so_item_pos AS so_item_pos,
  gross_amount,
  division( tax_amount, net_amount, 4 ) * 100 AS demo
FROM snwd_so_i
LEFT OUTER JOIN snwd_pd AS _product ON snwd_so_i.product_guid = _product.node_key  -- association [1]
;