ACE_ACESOBJ

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_ACESOBJ.
-- 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_ACESOBJ

CREATE VIEW ACE_ACESOBJ AS
SELECT
  aceobj.comp AS comp,
  aceobj.bukrs AS bukrs,
  aceobj.ref_key AS ref_key,
  acedsoh.ref_subkey AS ref_subkey,
  acedsoh.objid AS objid,
  acedsoh.subid AS subid,
  acepsoh.deactdate AS PREMTRE_FDATE,
  acepsoh.firstyear AS firstyear,
  acepsoh.lastyear AS lastyear,
  substring(aceobj.ref_key, 1, 10) AS ACAC_OBJTYPE,
  substring(aceobj.ref_key, 11, 22) AS ACAC_OBJNUMBER,
  case when acepsoh.objid is null then dats_tims_to_tstmp(acedsoh.cpudt, acedsoh.cputm, abap_system_timezone( $session.client,'NULL') , $session.client, 'NULL' ) else dats_tims_to_tstmp(acepsoh.cpudt, acepsoh.cputm, abap_system_timezone( $session.client,'NULL') , $session.client, 'NULL' ) end as TIMESTMP AS clientNULLendasTIMESTMP
FROM aceobj
INNER JOIN acedsoh ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acepsoh ON /* join condition not captured in parsed metadata */
;