Test_Cds_Astcheck_11

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 Test_Cds_Astcheck_11.
-- 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: testcdsac11

CREATE VIEW Test_Cds_Astcheck_11 AS
SELECT
  node_key,
  so_id,
  buyer_guid,
  gross_amount - net_amount AS tax,
  currency_conversion( amount => gross_amount, source_currency => currency_code, target_currency => cast('EUR' as abap.cuky(5) ), exchange_rate_date => cast(substring(cast(created_at as abap.char(23) ),1,8 ) as abap.dats ), error_handling => 'SET_TO_NULL' ) as amount AS datserror_handlingSET_TO_NULLasamount,
  cast( net_amount as snwd_ttl_gross_amount ) AS net1,
  cast( net_amount as snwd_ttl_gross_amount preserving type ) AS net2,
  'X' AS x,
  1 AS one,
  net_amount AS net
FROM snwd_so
LEFT OUTER JOIN qlast_sddl_bpa AS _buyer ON buyer_guid = _buyer.node_key  -- association [1]
;