SFPM_IDA_TEST_CDS_RESSOURCE

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_RESSOURCE.
-- 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_RS

CREATE VIEW SFPM_IDA_TEST_CDS_RESSOURCE AS
SELECT
  ressource_id,
  location_id,
  event_id,
  description,
  amount,
  curr,
  fpm_ida_test_res.amount AS amount_cds,
  fpm_ida_test_res.curr AS curr_cds,
  quantity,
  unit,
  category,
  rank,
  fpm_ida_test_res.quantity AS quantity_cds,
  unit AS unit_cds,
  amount AS TestAmount
FROM fpm_ida_test_res
LEFT OUTER JOIN SFPM_IDA_TEST_CDS_RESSOURCE AS ressource_item ON fpm_ida_test_res.ressource_item_id = ressource_item.ressource_id  -- association [0..*]
;