I_BusinessEventLogEventAddlDet

DDL: I_BUSINESSEVENTLOGEVENTADDLDET Type: view_entity COMPOSITE

BEL Event Additional Details

I_BusinessEventLogEventAddlDet is a Composite CDS View that provides data about "BEL Event Additional Details" in SAP S/4HANA. It reads from 3 data sources (I_BusinessEventLogEvent, I_BusinessEventLogEvent, P_BEL_EVENT_PHASE_BADI_AMDP_TF) and exposes 73 fields with key fields BusinessEventUUID, SAPObjectType, BusEvtLogCreationDate, SAPObjectType, BusEvtLogCreationDate.

Data Sources (3)

SourceAliasJoin Type
I_BusinessEventLogEvent EventLog from
I_BusinessEventLogEvent EventLog union_all
P_BEL_EVENT_PHASE_BADI_AMDP_TF tf inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BEL Event Additional Details view
Analytics.technicalName IBUSEVTLOGADET view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY BusinessEventUUID I_BusinessEventLogEvent BusinessEventUUID Event GUID
KEY SAPObjectType I_BusinessEventLogEvent SAPObjectType SOT Name
KEY BusEvtLogCreationDate I_BusinessEventLogEvent BusEvtLogCreationDate Executed Date
BusinessObject I_BusinessEventLogEvent BusinessObject Business Object
SAPObjectNodeType I_BusinessEventLogEvent SAPObjectNodeType SONT Name
BusinessEventType I_BusinessEventLogEvent BusinessEventType
EventOperation I_BusinessEventLogEvent EventOperation SAP Object Task Type
BusEvtLogObjectNodeID I_BusinessEventLogEvent BusEvtLogObjectNodeID BEL Object Node ID
SAPBusinessObjectNodeKey1 I_BusinessEventLogEvent SAPBusinessObjectNodeKey1 INT4
SAPBusinessObjectNodeKey2 I_BusinessEventLogEvent SAPBusinessObjectNodeKey2 Character Field of Length 12
SAPBusinessObjectNodeKey3 I_BusinessEventLogEvent SAPBusinessObjectNodeKey3 INT2
SAPBusinessObjectNodeKey4 I_BusinessEventLogEvent SAPBusinessObjectNodeKey4 BO Key Part (4)
SAPBusinessObjectNodeKey5 I_BusinessEventLogEvent SAPBusinessObjectNodeKey5 BO Key Part (5)
SAPBusinessObjectNodeKey6 I_BusinessEventLogEvent SAPBusinessObjectNodeKey6 BO Key Part (6)
SAPBusinessObjectNodeKey7 I_BusinessEventLogEvent SAPBusinessObjectNodeKey7 Business Object Key
SAPBusinessObjectNodeKey8 I_BusinessEventLogEvent SAPBusinessObjectNodeKey8 BO Key Part (8)
BusEvtLogObjectNodeKey1UUID I_BusinessEventLogEvent BusEvtLogObjectNodeKey1UUID Key1 Raw-16
BusEvtLogCreationDateTime I_BusinessEventLogEvent BusEvtLogCreationDateTime Executed Time Stamp
BusEvtLogCreationTime I_BusinessEventLogEvent BusEvtLogCreationTime Time
BusEvtLogLastChangedDateTime I_BusinessEventLogEvent BusEvtLogLastChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
PredecessorBusinessEventUUID _EventSequence PredecessorBusinessEventUUID Event GUID
BuEvLgTimeSinceLastEvent _EventSequence BuEvLgTimeSinceLastEvent LeadTime
UnitOfMeasure _EventSequence UnitOfMeasure Unit Protected Qty
SAPObjectNodeCharacterKey1 I_BusinessEventLogEvent SAPObjectNodeCharacterKey1 BO Key Part (1)
BusinessEventLogEventVersion I_BusinessEventLogEvent BusinessEventLogEventVersion EVTB Version
EventProducerNamespace I_BusinessEventLogEvent EventProducerNamespace Producer Event Nsps
BusinessEventLogLogicalSystem I_BusinessEventLogEvent BusinessEventLogLogicalSystem Source System
BusEvtLogIsDeleted I_BusinessEventLogEvent BusEvtLogIsDeleted Truth Value
BusEvtLogTransactionID I_BusinessEventLogEvent BusEvtLogTransactionID Update key
CreatedByUser I_BusinessEventLogEvent CreatedByUser User Name
BusinessEventLogSource I_BusinessEventLogEvent BusinessEventLogSource Evt Source
BuEvLgEvtBindgContr2RelState I_BusinessEventLogEvent BuEvLgEvtBindgContr2RelState Ext. Rel. Status
BusEvtLogEventHasFullPayload I_BusinessEventLogEvent BusEvtLogEventHasFullPayload Full Payload
BusEvtLogUserInteractionType I_BusinessEventLogEvent BusEvtLogUserInteractionType User Interaction Typ
BusEvtLgUsrIntactnTypeValue I_BusinessEventLogEvent BusEvtLgUsrIntactnTypeValue UsrIntactn Tp Val
ChangeDocument I_BusinessEventLogEvent ChangeDocument Document Number
BusinessEventUUID Event GUID
KEY SAPObjectType I_BusinessEventLogEvent SAPObjectType SOT Name
KEY BusEvtLogCreationDate I_BusinessEventLogEvent BusEvtLogCreationDate Executed Date
BusinessObject I_BusinessEventLogEvent BusinessObject Business Object
SAPObjectNodeType I_BusinessEventLogEvent SAPObjectNodeType SONT Name
BusinessEventType I_BusinessEventLogEvent BusinessEventType
EventOperation I_BusinessEventLogEvent EventOperation SAP Object Task Type
BusEvtLogObjectNodeID I_BusinessEventLogEvent BusEvtLogObjectNodeID BEL Object Node ID
SAPBusinessObjectNodeKey1 I_BusinessEventLogEvent SAPBusinessObjectNodeKey1 INT4
SAPBusinessObjectNodeKey2 I_BusinessEventLogEvent SAPBusinessObjectNodeKey2 Character Field of Length 12
SAPBusinessObjectNodeKey3 I_BusinessEventLogEvent SAPBusinessObjectNodeKey3 INT2
SAPBusinessObjectNodeKey4 I_BusinessEventLogEvent SAPBusinessObjectNodeKey4 BO Key Part (4)
SAPBusinessObjectNodeKey5 I_BusinessEventLogEvent SAPBusinessObjectNodeKey5 BO Key Part (5)
SAPBusinessObjectNodeKey6 I_BusinessEventLogEvent SAPBusinessObjectNodeKey6 BO Key Part (6)
SAPBusinessObjectNodeKey7 I_BusinessEventLogEvent SAPBusinessObjectNodeKey7 Business Object Key
SAPBusinessObjectNodeKey8 I_BusinessEventLogEvent SAPBusinessObjectNodeKey8 BO Key Part (8)
BusEvtLogObjectNodeKey1UUID I_BusinessEventLogEvent BusEvtLogObjectNodeKey1UUID Key1 Raw-16
BusEvtLogCreationDateTime I_BusinessEventLogEvent BusEvtLogCreationDateTime Executed Time Stamp
BusEvtLogCreationTime I_BusinessEventLogEvent BusEvtLogCreationTime Time
BusEvtLogLastChangedDateTime I_BusinessEventLogEvent BusEvtLogLastChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
PredecessorBusinessEventUUID I_BusinessEventLogEvent PredecessorBusinessEventUUID Event GUID
BuEvLgTimeSinceLastEvent I_BusinessEventLogEvent BuEvLgTimeSinceLastEvent LeadTime
UnitOfMeasure I_BusinessEventLogEvent UnitOfMeasure Unit Protected Qty
SAPObjectNodeCharacterKey1 I_BusinessEventLogEvent SAPObjectNodeCharacterKey1 BO Key Part (1)
BusinessEventLogEventVersion I_BusinessEventLogEvent BusinessEventLogEventVersion EVTB Version
EventProducerNamespace I_BusinessEventLogEvent EventProducerNamespace Producer Event Nsps
BusinessEventLogLogicalSystem I_BusinessEventLogEvent BusinessEventLogLogicalSystem Source System
BusEvtLogIsDeleted I_BusinessEventLogEvent BusEvtLogIsDeleted Truth Value
BusEvtLogTransactionID I_BusinessEventLogEvent BusEvtLogTransactionID Update key
CreatedByUser I_BusinessEventLogEvent CreatedByUser User Name
BusinessEventLogSource I_BusinessEventLogEvent BusinessEventLogSource Evt Source
BuEvLgEvtBindgContr2RelState I_BusinessEventLogEvent BuEvLgEvtBindgContr2RelState Ext. Rel. Status
BusEvtLogEventHasFullPayload I_BusinessEventLogEvent BusEvtLogEventHasFullPayload Full Payload
BusEvtLogUserInteractionType I_BusinessEventLogEvent BusEvtLogUserInteractionType User Interaction Typ
BusEvtLgUsrIntactnTypeValue I_BusinessEventLogEvent BusEvtLgUsrIntactnTypeValue UsrIntactn Tp Val
ChangeDocument I_BusinessEventLogEvent ChangeDocument Document Number
ChangeDocItemChangeType I_BusinessEventLogEvent ChangeDocItemChangeType Change Indicator

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_BusinessEventLogEventAddlDet.
-- 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_BusinessEventLogEventAddlDet 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.SAPBusinessObjectNodeKey1 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.BusEvtLogObjectNodeKey1UUID AS BusEvtLogObjectNodeKey1UUID,
  EventLog.BusEvtLogCreationDateTime AS BusEvtLogCreationDateTime,
  EventLog.BusEvtLogCreationTime AS BusEvtLogCreationTime,
  EventLog.BusEvtLogLastChangedDateTime AS BusEvtLogLastChangedDateTime,
  _EventSequence.PredecessorBusinessEventUUID AS PredecessorBusinessEventUUID,
  _EventSequence.BuEvLgTimeSinceLastEvent AS BuEvLgTimeSinceLastEvent,
  _EventSequence.UnitOfMeasure AS UnitOfMeasure,
  EventLog.SAPObjectNodeCharacterKey1 AS SAPObjectNodeCharacterKey1,
  EventLog.BusinessEventLogEventVersion AS BusinessEventLogEventVersion,
  EventLog.EventProducerNamespace AS EventProducerNamespace,
  EventLog.BusinessEventLogLogicalSystem AS BusinessEventLogLogicalSystem,
  EventLog.BusEvtLogIsDeleted AS BusEvtLogIsDeleted,
  EventLog.BusEvtLogTransactionID AS BusEvtLogTransactionID,
  EventLog.CreatedByUser AS CreatedByUser,
  EventLog.BusinessEventLogSource AS BusinessEventLogSource,
  EventLog.BuEvLgEvtBindgContr2RelState AS BuEvLgEvtBindgContr2RelState,
  EventLog.BusEvtLogEventHasFullPayload AS BusEvtLogEventHasFullPayload,
  EventLog.BusEvtLogUserInteractionType AS BusEvtLogUserInteractionType,
  EventLog.BusEvtLgUsrIntactnTypeValue AS BusEvtLgUsrIntactnTypeValue,
  EventLog.ChangeDocument AS ChangeDocument,
  EventLog.ChangeDocItemChangeType AS ChangeDocItemChangeType
FROM I_BusinessEventLogEvent AS EventLog
INNER JOIN P_BEL_EVENT_PHASE_BADI_AMDP_TF AS tf ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_BusinessEventLogEvent
;