I_BusinessEventLogEventDetail

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_BusinessEventLogEventDetail.
-- 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: IBELEVENTDL

CREATE VIEW I_BusinessEventLogEventDetail AS
SELECT
  EventLog.BusinessEventUUID AS BusinessEventUUID,
  EventLog.SAPObjectType AS SAPObjectType,
  EventLog.BusEvtLogCreationDate AS BusEvtLogCreationDate,
  EventLog.BusinessObject AS BusinessObject,
  EventLog.SAPObjectNodeType AS SAPObjectNodeType,
  EventLog.BusinessEventType AS BusinessEventType,
  EventLog.EventOperation AS EventOperation,
  EventLog.BusEvtLogObjectNodeID AS BusEvtLogObjectNodeID,
  EventLog.SAPObjectNodeCharacterKey1 AS SAPBusinessObjectNodeKey1,
  EventLog.SAPBusinessObjectNodeKey2 AS SAPBusinessObjectNodeKey2,
  EventLog.SAPBusinessObjectNodeKey3 AS SAPBusinessObjectNodeKey3,
  EventLog.SAPBusinessObjectNodeKey4 AS SAPBusinessObjectNodeKey4,
  EventLog.SAPBusinessObjectNodeKey5 AS SAPBusinessObjectNodeKey5,
  EventLog.SAPBusinessObjectNodeKey6 AS SAPBusinessObjectNodeKey6,
  EventLog.SAPBusinessObjectNodeKey7 AS SAPBusinessObjectNodeKey7,
  EventLog.SAPBusinessObjectNodeKey8 AS SAPBusinessObjectNodeKey8,
  EventLog.BusEvtLogCreationDateTime AS BusEvtLogCreationDateTime,
  EventLog.BusEvtLogCreationTime AS BusEvtLogCreationTime,
  EventLog.PredecessorBusinessEventUUID AS PredecessorBusinessEventUUID,
  EventLog.BuEvLgTimeSinceLastEvent AS BuEvLgTimeSinceLastEvent,
  EventLog.UnitOfMeasure AS UnitOfMeasure,
  EventLog.SAPObjectNodeCharacterKey1 AS SAPObjectNodeCharacterKey1,
  EventLog.BusinessEventLogEventVersion AS BusinessEventLogEventVersion,
  EventLog.EventProducerNamespace AS EventProducerNamespace,
  EventProducer.BusEvtLogEventBinding AS BusEvtLogEventBinding,
  EventBinding._HeaderText[1:Language = $session.system_language].BusEvtLogEventTypeName AS BusEvtLogEventTypeName,
  EventLog.BusinessEventLogLogicalSystem AS BusinessEventLogLogicalSystem,
  EventLog.BusEvtLogIsDeleted AS BusEvtLogIsDeleted,
  EventLog.BusEvtLogTransactionID AS BusEvtLogTransactionID,
  EventLog.BusEvtLogLastChangedDateTime AS BusEvtLogLastChangedDateTime,
  EventLog.CreatedByUser AS UserID,
  cast( _UserDescription.UserID as bel_executed_by) AS CreatedByUser,
  _UserDescription.IsTechnicalUser AS IsTechnicalUser,
  EventLog.BusinessEventLogSource AS BusinessEventLogSource,
  EventLog.BusEvtLogUserInteractionType AS BusEvtLogUserInteractionType,
  EventLog.BusEvtLgUsrIntactnTypeValue AS BusEvtLgUsrIntactnTypeValue,
  EventLog.ChangeDocument AS ChangeDocument,
  EventLog.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  EventLog.BusEvtLogReferenceEntityName AS BusEvtLogReferenceEntityName
FROM I_BusinessEventLogEvent AS EventLog
LEFT OUTER JOIN I_UserDescription AS _UserDescription ON EventLog.CreatedByUser = _UserDescription.UserID  -- association [0..1]
;