I_BusEventLogActivityHierarchy

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_BusEventLogActivityHierarchy.
-- 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_BusEventLogActivityHierarchy AS
SELECT
  I_BusinessEventLogActivity.BusEvtLogBusinessActivity AS BusEvtLogBusActivityNodeID,
  cast('' as bel_activity_id) AS BusEvtLogBusActyParentNodeID,
  I_BusinessEventLogActivity.BusEvtLogBusinessActivity AS BusEvtLogBusinessActivity,
  I_BusinessEventLogActivity.BusinessEventUUID AS BusinessEventUUID,
  I_BusinessEventLogActivity.SAPObjectType AS SAPObjectType,
  I_BusinessEventLogActivity.BusEvtLogObjectNodeID AS BusEvtLogObjectNodeID,
  I_BusinessEventLogActivity.BusEvtLogCreationDate AS BusEvtLogCreationDate,
  I_BusinessEventLogActivity.BusEvtLogReferenceEventUUID AS BusEvtLogReferenceEventUUID,
  I_BusinessEventLogActivity.BusinessObject AS BusinessObject,
  I_BusinessEventLogActivity.SAPObjectNodeType AS SAPObjectNodeType,
  I_BusinessEventLogActivity.BusinessEventType AS BusinessEventType,
  I_BusinessEventLogActivity.EventOperation AS EventOperation,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey1 AS SAPBusinessObjectNodeKey1,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey2 AS SAPBusinessObjectNodeKey2,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey3 AS SAPBusinessObjectNodeKey3,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey4 AS SAPBusinessObjectNodeKey4,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey5 AS SAPBusinessObjectNodeKey5,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey6 AS SAPBusinessObjectNodeKey6,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey7 AS SAPBusinessObjectNodeKey7,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey8 AS SAPBusinessObjectNodeKey8,
  I_BusinessEventLogActivity.BusEvtLogObjectNodeKey1UUID AS BusEvtLogObjectNodeKey1UUID,
  I_BusinessEventLogActivity.CreatedByUser AS CreatedByUser,
  cast('0' as abap.int1) AS HierarchyLevel,
  'expanded' AS DrillState,
  cast( 'Y' as bel_event_src ) AS BusinessEventLogSource,
  I_BusinessEventLogActivity.BusEvtLogCreationDateTime AS BusEvtLogCreationDateTime,
  I_BusinessEventLogActivity.BusEvtLogCreationTime AS BusEvtLogCreationTime,
  I_BusinessEventLogActivity.BusinessEventLogLogicalSystem AS BusinessEventLogLogicalSystem,
  I_BusinessEventLogActivity.BusEvtLogIsDeleted AS BusEvtLogIsDeleted,
  I_BusinessEventLogActivity.BusEvtLogTransactionID AS BusEvtLogTransactionID,
  I_BusinessEventLogActivity.BusEvtLogLastChangedDateTime AS BusEvtLogLastChangedDateTime,
  I_BusinessEventLogActivity.SAPObjectNodeCharacterKey1 AS SAPObjectNodeCharacterKey1,
  cast('' as bel_event_ver ) AS BusinessEventLogEventVersion,
  cast('' as bel_producer_namespace ) AS EventProducerNamespace,
  I_BusinessEventLogActivity.BuEvLgEvtBindgContr2RelState AS BuEvLgEvtBindgContr2RelState,
  I_BusinessEventLogActivity.BusEvtLogEventHasFullPayload AS BusEvtLogEventHasFullPayload,
  I_BusinessEventLogActivity.BusEvtLogUserInteractionType AS BusEvtLogUserInteractionType,
  I_BusinessEventLogActivity.BusEvtLgUsrIntactnTypeValue AS BusEvtLgUsrIntactnTypeValue,
  I_BusinessEventLogActivity.ChangeDocument AS ChangeDocument,
  I_BusinessEventLogActivity.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  I_BusinessEventLogActivity.BusEvtLogReferenceEntityName AS BusEvtLogReferenceEntityName,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey1Name AS SAPBusinessObjectNodeKey1Name,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey2Name AS SAPBusinessObjectNodeKey2Name,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey3Name AS SAPBusinessObjectNodeKey3Name,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey4Name AS SAPBusinessObjectNodeKey4Name,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey5Name AS SAPBusinessObjectNodeKey5Name,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey6Name AS SAPBusinessObjectNodeKey6Name,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey7Name AS SAPBusinessObjectNodeKey7Name,
  I_BusinessEventLogActivity.SAPBusinessObjectNodeKey8Name AS SAPBusinessObjectNodeKey8Name,
  I_BusinessEventLogActivity.BusEvtLogEventAbstractEntity AS BusEvtLogEventAbstractEntity,
  I_BusinessEventLogActivity.BuEvLgTimeSinceLastEvent AS BuEvLgTimeSinceLastEvent,
  I_BusinessEventLogActivity.BusEvtLogPrdcssrBusActivity AS BusEvtLogPrdcssrBusActivity,
  I_BusinessEventLogActivity.UnitOfMeasure AS UnitOfMeasure
FROM I_BusinessEventLogActivity
INNER JOIN I_BusinessEventLogEvent AS _EventLog ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_BusinessEventLogActivity
;