P_BusEvtLogObjectNodeAnlys

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 P_BusEvtLogObjectNodeAnlys.
-- 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 P_BusEvtLogObjectNodeAnlys AS
SELECT
  I_BusEvtLogObjectNode.BusEvtLogObjectNodeID AS BusEvtLogObjectNodeID,
  I_BusEvtLogObjectNode.SAPObjectType AS SAPObjectType,
  I_BusEvtLogObjectNode.BusinessObject AS BusinessObject,
  I_BusEvtLogObjectNode.SAPObjectNodeType AS SAPObjectNodeType,
  I_BusEvtLogObjectNode.SAPObjectNodeConcatenatedKey AS BusEvtLogSAPBusObjNodeKey,
  I_BusEvtLogObjectNode.SAPObjectNodeCharacterKey1 AS SAPObjectNodeCharacterKey1,
  I_BusEvtLogObjectNode.SAPObjectNodeCharacterKey1 AS SAPBusinessObjectNodeKey1,
  I_BusEvtLogObjectNode.SAPBusinessObjectNodeKey2 AS SAPBusinessObjectNodeKey2,
  I_BusEvtLogObjectNode.SAPBusinessObjectNodeKey3 AS SAPBusinessObjectNodeKey3,
  I_BusEvtLogObjectNode.SAPBusinessObjectNodeKey4 AS SAPBusinessObjectNodeKey4,
  I_BusEvtLogObjectNode.SAPBusinessObjectNodeKey5 AS SAPBusinessObjectNodeKey5,
  I_BusEvtLogObjectNode.SAPBusinessObjectNodeKey6 AS SAPBusinessObjectNodeKey6,
  I_BusEvtLogObjectNode.SAPBusinessObjectNodeKey7 AS SAPBusinessObjectNodeKey7,
  I_BusEvtLogObjectNode.SAPBusinessObjectNodeKey8 AS SAPBusinessObjectNodeKey8,
  I_BusEvtLogObjectNode.StartingBusinessEventUUID AS StartingBusinessEventUUID,
  _FirstBusinessEvent.BusEvtLogEventTypeName AS BusEvtLogStartEvtTskTypeName,
  I_BusEvtLogObjectNode.BusEvtLogCreationDateTime AS BusEvtLogCreationDateTime,
  I_BusEvtLogObjectNode.BusEvtLogCreationDate AS BusEvtLogCreationDate,
  I_BusEvtLogObjectNode.BusEvtLogCreationTime AS BusEvtLogCreationTime,
  I_BusEvtLogObjectNode.BusEvtLogProcessVariant AS BusEvtLogProcessVariant,
  I_BusEvtLogObjectNode.LastBusinessEventUUID AS LastBusinessEventUUID,
  _LastBusinessEvent.BusEvtLogEventTypeName AS BusEvtLogLastEvtTskTypeName,
  I_BusEvtLogObjectNode.BusEvtLogLastEventDateTime AS BusEvtLogLastEventDateTime,
  I_BusEvtLogObjectNode.BusEvtLogLastEventDate AS BusEvtLogLastEventDate,
  I_BusEvtLogObjectNode.BusEvtLogLastEventTime AS BusEvtLogLastEventTime,
  I_BusEvtLogObjectNode.BuEvLgNodeLastChangedDateTime AS BuEvLgNodeLastChangedDateTime,
  _EventCount.BusEvtLogNumberOfEvents AS BusEvtLogNumberOfEvents,
  I_BusEvtLogObjectNode.BuEvLgObjNodeCycTmeInSeconds AS BuEvLgObjNodeCycTmeInSeconds,
  I_BusEvtLogObjectNode.UnitOfMeasure AS UnitOfMeasure,
  _CalendarDate.YearWeek AS YearWeek,
  cast( 1 as bel_process_count ) AS BusEvtLogNumberOfProcess,
  cast( 1 as bel_variant_count ) AS BusEvtLogNumberOfVariants,
  _ProcessVariant.BusEvtLogProcVariantLength AS BusEvtLogProcVariantLength,
  _ProcessVariant.BusEvtLogProcVariantStepText AS BusEvtLogProcVariantStepText,
  concat_with_space( SAPObjectNodeTypeDescription, concat_with_space( '|', I_BusEvtLogObjectNode.SAPObjectNodeConcatenatedKey, 1), 1 ) AS BuEvLgCnctntdSONTAndKey
FROM I_BusEvtLogObjectNode
LEFT OUTER JOIN I_BuEvLgObjNodeOutbRelshpEnhcd AS _ObjectNodeOutboundRelshp ON BusEvtLogObjectNodeID = _ObjectNodeOutboundRelshp.BusEvtLogObjectNodeID AND SAPObjectType = _ObjectNodeOutboundRelshp.SAPObjectType  -- association [0..*]
LEFT OUTER JOIN I_BuEvLgObjNodeInbRelshpEnhcd AS _ObjectNodeInboundRelshp ON BusEvtLogObjectNodeID = _ObjectNodeInboundRelshp.BusEvtLogRelatedObjectNodeID AND SAPObjectType = _ObjectNodeInboundRelshp.RelatedSAPObjectType  -- association [0..*]
LEFT OUTER JOIN I_BusEventLogEventEnhcd AS _BusinessEvent ON BusEvtLogObjectNodeID = _BusinessEvent.BusEvtLogObjectNodeID AND SAPObjectType = _BusinessEvent.SAPObjectType  -- association [0..*]
LEFT OUTER JOIN I_SAPObjectType_2 AS _SAPObjectType_2 ON SAPObjectType = _SAPObjectType_2.SAPObjectType  -- association [0..1]
LEFT OUTER JOIN I_SAPObjectNodeType_2 AS _SAPObjectNodeType_2 ON SAPObjectNodeType = _SAPObjectNodeType_2.SAPObjectNodeType  -- association [0..1]
;