ACE_ACEDSOH_VIEW_01

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 ACE_ACEDSOH_VIEW_01.
-- 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: ACEV_ACEDSOH1

CREATE VIEW ACE_ACEDSOH_VIEW_01 AS
SELECT
  acesobj_item.comp AS comp,
  acesobj_item.bukrs AS bukrs,
  acesobj.objid AS objid,
  acesobj.subid AS subid,
  acesobj_item.date_to AS date_to,
  acesobj_item.ref_subkey AS ref_subkey,
  acesobj_item.date_from AS date_from,
  acesobj_item.life_start_date AS vality_from,
  acesobj_item.life_end_date AS vality_to,
  acesobj.uname AS uname,
  tstmp_to_dats( acesobj.timestmp, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as cpudt AS clientNULLascpudt,
  tstmp_to_tims( acesobj.timestmp, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as cputm AS clientNULLascputm
FROM acesobj_item
LEFT OUTER JOIN acesobj ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): acesobj_item
;