I_ADM_LOGHIST

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 I_ADM_LOGHIST.
-- 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: IADMLOGHIST

CREATE VIEW I_ADM_LOGHIST AS
SELECT
  swwloghist.wi_id AS WiId,
  swwloghist.method AS Method,
  swwloghist.meth_edate AS MethEdate,
  swwloghist.meth_etime AS MethEtime,
  swwloghist.log_count AS LogCount,
  case when User.PersonFullName is null or User.PersonFullName is initial then swwloghist.meth_user else User.PersonFullName end as Agent AS PersonFullNameendasAgent,
  bintohex(swwloghist.chi_logkey) AS chi_logkey,
  bintohex(swwloghist.par_logkey) AS par_logkey,
  swwloghist.workarea AS workarea,
  swwloghist.message AS message,
  swwloghist.variable1 AS variable1,
  swwloghist.variable2 AS variable2,
  swwloghist.variable3 AS variable3,
  swwloghist.variable4 AS variable4,
  DATS_TIMS_TO_TSTMP(swwloghist.meth_edate,swwloghist.meth_etime, abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL') as meth_edate_time AS clientNULLasmeth_edate_time,
  swwloghist.log_count AS log_count,
  swwloghist.meth_user AS meth_user,
  swwloghist.msgtype AS msgtype,
  meth_text.fb_text AS fb_text
FROM swwloghist
LEFT OUTER JOIN swwfbatext AS meth_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessUserBasic AS User ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ADM_LOGHIST AS _parent ON _parent.entry_node_id = entry_parent_id  -- association [0..*]
;