I_IHBEndOfDayProcessLog

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_IHBEndOfDayProcessLog.
-- 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_IHBEndOfDayProcessLog AS
SELECT
  log_uuid AS IHBEndOfDayLogUUID,
  bank_area AS IHBBankArea,
  process AS IHBEndOfDayProcessID,
  status AS IHBEndOfDayProcessStatusID,
  start_timestamp AS IHBEndOfDayProcessStrtDateTime,
  end_timestamp AS IHBEndOfDayProcessEndDateTime,
  user_name AS IHBEndOfDayProcessUserName,
  log_number AS IHBEndOfDayLogNumber,
  cast(log_handle as abap.char(22) ) AS IHBEndOfDayLogHandle,
  extnumber AS IHBEndOfDayLogExtNumber,
  start_date AS IHBEndOfDayProcessDate,
  tstmp_to_tims(cast((start_timestamp) as abap.dec( 15, 0 )), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as IHBEndOfDayProcessTime AS clientNULLasIHBEndOfDayProcessTime,
  programm AS IHBEndOfDayProg,
  variant AS IHBEndOfDayVariant
FROM /pf1/db_eod_log
;