I_DSP_DLH_LOGHDR

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

CREATE VIEW I_DSP_DLH_LOGHDR AS
SELECT
  Loghandle,
  dlh_id AS DlhId,
  start_time AS StartTime,
  end_time AS EndTime,
  proc_entries AS ProcEntries,
  proc_failed AS ProcFailed,
  end_time-start_time AS Duration,
  proc_failed AS Status,
  dlh_client AS Client,
  dlh_info AS Info,
  proc_entries
FROM sdsp_dlh_loghdr
LEFT OUTER JOIN I_DSP_DLH_HANDLER_ID_TEXT AS _Text ON DlhId = _Text.Status  -- association [0..*]
LEFT OUTER JOIN I_DSP_DLH_LOGDATA AS _LogData ON /* condition not available in parsed metadata */  -- association [0..*]
;