I_IHBEndOfDayProcessLogCmpst

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_IHBEndOfDayProcessLogCmpst.
-- 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_IHBEndOfDayProcessLogCmpst AS
SELECT
  IHBEndOfDayLogUUID,
  IHBBankArea,
  IHBEndOfDayProcessID,
  IHBEndOfDayProcessStatusID,
  IHBEndOfDayProcessStrtDateTime,
  IHBEndOfDayProcessEndDateTime,
  IHBEndOfDayProcessUserName,
  IHBEndOfDayProcessCriticality,
  IHBEndOfDayProcessDate,
  IHBEndOfDayProcessTime,
  IHBEndOfDayLogNumber,
  IHBEndOfDayLogHandle,
  IHBEndOfDayLogExtNumber,
  IHBEndOfDayProg,
  IHBEndOfDayVariant
FROM I_IHBEndOfDayProcessLog
LEFT OUTER JOIN I_IHBEndOfDayProcessText AS _IHBEndOfDayProcessText ON IHBEndOfDayProcessID = _IHBEndOfDayProcessText.IHBEndOfDayProcessID  -- association [0..1]
LEFT OUTER JOIN I_IHBEndOfDayProcessStatusText AS _IHBEndOfDayProcessStatusText ON IHBEndOfDayProcessStatusID = _IHBEndOfDayProcessStatusText.IHBEndOfDayProcessStatusID  -- association [0..1]
LEFT OUTER JOIN I_IHBEndOfDayProcessApplLog AS _IHBEndOfDayProcessApplLog ON IHBEndOfDayLogNumber = _IHBEndOfDayProcessApplLog.ApplicationLog  -- association [0..1]
LEFT OUTER JOIN I_IHBBankAreaT AS _IHBBankAreaText ON IHBBankArea = _IHBBankAreaText.IHBBankArea  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedBy ON IHBEndOfDayProcessUserName = _CreatedBy.UserID  -- association [0..1]
;