C_IHBEndOfDayProcessLogTP

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 C_IHBEndOfDayProcessLogTP.
-- 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 C_IHBEndOfDayProcessLogTP AS
SELECT
  IHBEndOfDayLogUUID,
  _IHBBankAreaText[1:IHBBankAreaLanguage = $session.system_language ].IHBBankAreaDescription AS IHBBankAreaDescription,
  IHBBankArea,
  IHBEndOfDayProcessID,
  _IHBEndOfDayProcessText.IHBEndOfDayProcessText AS IHBEndOfDayProcessText,
  IHBEndOfDayProcessStatusID,
  _IHBEndOfDayProcessStatusText.IHBEndOfDayProcessStatusText AS IHBEndOfDayProcessStatusText,
  IHBEndOfDayProcessStrtDateTime,
  IHBEndOfDayProcessEndDateTime,
  IHBEndOfDayProcessCriticality,
  IHBEndOfDayProcessDate,
  IHBEndOfDayProcessTime,
  IHBEndOfDayLogNumber,
  IHBEndOfDayLogHandle,
  IHBEndOfDayLogExtNumber,
  IHBEndOfDayProg,
  IHBEndOfDayVariant,
  _IHBEndOfDayProcessApplLog.IHBAppLogNumberOfMessages AS IHBAppLogNumberOfMessages,
  _IHBEndOfDayProcessApplLog.IHBAppLogNumberOfAbortMessages AS IHBAppLogNumberOfAbortMessages,
  _IHBEndOfDayProcessApplLog.IHBAppLogNumberOfErrMessages AS IHBAppLogNumberOfErrMessages,
  _IHBEndOfDayProcessApplLog.IHBAppLogNumberOfSuccMessages AS IHBAppLogNumberOfSuccMessages,
  _IHBEndOfDayProcessApplLog.IHBAppLogNumberOfWarnMessages AS IHBAppLogNumberOfWarnMessages,
  _IHBEndOfDayProcessApplLog.IHBAppLogNumberOfInfoMessages AS IHBAppLogNumberOfInfoMessages,
  _CreatedBy.UserDescription AS IHBEndOfDayProcessUserName
FROM R_IHBEndOfDayProcessLogTP
LEFT OUTER JOIN C_IHBBankAreaCard AS _IHBBankAreaCard ON IHBBankArea = _IHBBankAreaCard.IHBBankArea  -- association [0..1]
;