SFPM_IDA_TEST_CDS_EVENT

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 SFPM_IDA_TEST_CDS_EVENT.
-- 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: SFPM_IDA_TEST_ET
-- Parameters: idx_par_from : abap.int4, idx_par_to : abap.int4

CREATE VIEW SFPM_IDA_TEST_CDS_EVENT AS
SELECT
  event_id,
  ADRESS,
  RESSOURCE,
  location_id,
  description,
  amount,
  curr,
  curr_local,
  date_from,
  date_to,
  first_name,
  last_name,
  fpm_ida_test_evt.amount AS amount_cds,
  fpm_ida_test_evt.curr AS curr_cds,
  fpm_ida_test_evt.amount AS amount_api,
  fpm_ida_test_evt.curr AS curr_api,
  quantity,
  unit,
  timestamp,
  time,
  fpm_ida_test_evt.quantity AS quantity_cds,
  unit AS unit_cds,
  amount AS TestAmount,
  amount + amount AS doubleamount
FROM fpm_ida_test_evt
LEFT OUTER JOIN SFPM_IDA_TEST_CDS_RESSOURCE AS RESSOURCE ON fpm_ida_test_evt.event_id = RESSOURCE.event_id  -- association [*]
;