I_BuEvLgObjNodeOutbRelshpEnhcd

DDL: I_BUEVLGOBJNODEOUTBRELSHPENHCD Type: view_entity COMPOSITE

Bus Evt Log Object Node Outb Relshp

I_BuEvLgObjNodeOutbRelshpEnhcd is a Composite CDS View that provides data about "Bus Evt Log Object Node Outb Relshp" in SAP S/4HANA. It reads from 1 data source (I_BusEvtLogObjectNodeRelshp) and exposes 29 fields with key fields BusEvtLogObjectNodeID, BusEvtLogRelatedObjectNodeID, BusEvtLogAssociationName. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusEvtLogObjectNodeRelshp I_BusEvtLogObjectNodeRelshp from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_SAPObjectTypeText _SAPObjectTypeText $projection.RelatedSAPObjectType = _SAPObjectTypeText.SAPObjectType
[0..*] I_SAPObjectNodeTypeText _SAPObjectNodeTypeText $projection.RelatedSAPObjectNodeType = _SAPObjectNodeTypeText.SAPObjectNodeType

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bus Evt Log Object Node Outb Relshp view
Analytics.technicalName IBELORELNODE view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey BusEvtLogObjectNodeID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
Feature BEL_PROCESS_RELATIONSHIP view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY BusEvtLogObjectNodeID I_BusEvtLogObjectNodeRelshp BusEvtLogObjectNodeID Node ID
KEY BusEvtLogRelatedObjectNodeID I_BusEvtLogObjectNodeRelshp BusEvtLogRelatedObjectNodeID Related Node ID
KEY BusEvtLogAssociationName
SAPObjectType I_BusEvtLogObjectNodeRelshp SAPObjectType Object Type
SAPObjectNodeType I_BusEvtLogObjectNodeRelshp SAPObjectNodeType Node Type
SAPBusinessObjectNodeKey1 I_BusEvtLogObjectNodeRelshp SAPBusinessObjectNodeKey1 Key (part) 1
SAPBusinessObjectNodeKey2 I_BusEvtLogObjectNodeRelshp SAPBusinessObjectNodeKey2 Key (part) 2
SAPBusinessObjectNodeKey3 I_BusEvtLogObjectNodeRelshp SAPBusinessObjectNodeKey3 Key (part) 3
SAPBusinessObjectNodeKey4 I_BusEvtLogObjectNodeRelshp SAPBusinessObjectNodeKey4 Key (part) 4
SAPBusinessObjectNodeKey5 I_BusEvtLogObjectNodeRelshp SAPBusinessObjectNodeKey5 Key (part) 5
SAPBusinessObjectNodeKey6 I_BusEvtLogObjectNodeRelshp SAPBusinessObjectNodeKey6 Key (part) 6
SAPBusinessObjectNodeKey7 I_BusEvtLogObjectNodeRelshp SAPBusinessObjectNodeKey7 Key (part) 7
SAPBusinessObjectNodeKey8 I_BusEvtLogObjectNodeRelshp SAPBusinessObjectNodeKey8 Key (part) 8
RelatedSAPObjectType I_BusEvtLogObjectNodeRelshp RelatedSAPObjectType Related Object Type
RelatedSAPObjectNodeType I_BusEvtLogObjectNodeRelshp RelatedSAPObjectNodeType Related Node Type
BuEvLgReltdSAPBusObjNodeKey _BusEvtLogObjectRelatedNode SAPObjectNodeConcatenatedKey
BuEvLgReltdSAPBusObjNodeKey1 I_BusEvtLogObjectNodeRelshp BuEvLgReltdSAPBusObjNodeKey1 Related Key (part) 1
BuEvLgReltdSAPBusObjNodeKey2 I_BusEvtLogObjectNodeRelshp BuEvLgReltdSAPBusObjNodeKey2 Related Key (part) 2
BuEvLgReltdSAPBusObjNodeKey3 I_BusEvtLogObjectNodeRelshp BuEvLgReltdSAPBusObjNodeKey3 Related Key (part) 3
BuEvLgReltdSAPBusObjNodeKey4 I_BusEvtLogObjectNodeRelshp BuEvLgReltdSAPBusObjNodeKey4 Related Key (part) 4
BuEvLgReltdSAPBusObjNodeKey5 I_BusEvtLogObjectNodeRelshp BuEvLgReltdSAPBusObjNodeKey5 Related Key (part) 5
BuEvLgReltdSAPBusObjNodeKey6 I_BusEvtLogObjectNodeRelshp BuEvLgReltdSAPBusObjNodeKey6 Related Key (part) 6
BuEvLgReltdSAPBusObjNodeKey7 I_BusEvtLogObjectNodeRelshp BuEvLgReltdSAPBusObjNodeKey7 Related Key (part) 7
BuEvLgReltdSAPBusObjNodeKey8 I_BusEvtLogObjectNodeRelshp BuEvLgReltdSAPBusObjNodeKey8 Related Key (part) 8
BusEvtLogRelatedProcIsOutdated I_BusEvtLogObjectNodeRelshp BusEvtLogRelatedProcIsOutdated Outdated
BusEvtLogLastChangedDateTime I_BusEvtLogObjectNodeRelshp BusEvtLogLastChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
SAPObjectTypeendasSAPObjectTypeName
_SAPObjectTypeText _SAPObjectTypeText
_SAPObjectNodeTypeText _SAPObjectNodeTypeText

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_BuEvLgObjNodeOutbRelshpEnhcd.
-- 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_BuEvLgObjNodeOutbRelshpEnhcd AS
SELECT
  I_BusEvtLogObjectNodeRelshp.BusEvtLogObjectNodeID AS BusEvtLogObjectNodeID,
  I_BusEvtLogObjectNodeRelshp.BusEvtLogRelatedObjectNodeID AS BusEvtLogRelatedObjectNodeID,
  cast(I_BusEvtLogObjectNodeRelshp.BusEvtLogAssociationName as abap.char(30)) AS BusEvtLogAssociationName,
  I_BusEvtLogObjectNodeRelshp.SAPObjectType AS SAPObjectType,
  I_BusEvtLogObjectNodeRelshp.SAPObjectNodeType AS SAPObjectNodeType,
  I_BusEvtLogObjectNodeRelshp.SAPBusinessObjectNodeKey1 AS SAPBusinessObjectNodeKey1,
  I_BusEvtLogObjectNodeRelshp.SAPBusinessObjectNodeKey2 AS SAPBusinessObjectNodeKey2,
  I_BusEvtLogObjectNodeRelshp.SAPBusinessObjectNodeKey3 AS SAPBusinessObjectNodeKey3,
  I_BusEvtLogObjectNodeRelshp.SAPBusinessObjectNodeKey4 AS SAPBusinessObjectNodeKey4,
  I_BusEvtLogObjectNodeRelshp.SAPBusinessObjectNodeKey5 AS SAPBusinessObjectNodeKey5,
  I_BusEvtLogObjectNodeRelshp.SAPBusinessObjectNodeKey6 AS SAPBusinessObjectNodeKey6,
  I_BusEvtLogObjectNodeRelshp.SAPBusinessObjectNodeKey7 AS SAPBusinessObjectNodeKey7,
  I_BusEvtLogObjectNodeRelshp.SAPBusinessObjectNodeKey8 AS SAPBusinessObjectNodeKey8,
  I_BusEvtLogObjectNodeRelshp.RelatedSAPObjectType AS RelatedSAPObjectType,
  I_BusEvtLogObjectNodeRelshp.RelatedSAPObjectNodeType AS RelatedSAPObjectNodeType,
  _BusEvtLogObjectRelatedNode.SAPObjectNodeConcatenatedKey AS BuEvLgReltdSAPBusObjNodeKey,
  I_BusEvtLogObjectNodeRelshp.BuEvLgReltdSAPBusObjNodeKey1 AS BuEvLgReltdSAPBusObjNodeKey1,
  I_BusEvtLogObjectNodeRelshp.BuEvLgReltdSAPBusObjNodeKey2 AS BuEvLgReltdSAPBusObjNodeKey2,
  I_BusEvtLogObjectNodeRelshp.BuEvLgReltdSAPBusObjNodeKey3 AS BuEvLgReltdSAPBusObjNodeKey3,
  I_BusEvtLogObjectNodeRelshp.BuEvLgReltdSAPBusObjNodeKey4 AS BuEvLgReltdSAPBusObjNodeKey4,
  I_BusEvtLogObjectNodeRelshp.BuEvLgReltdSAPBusObjNodeKey5 AS BuEvLgReltdSAPBusObjNodeKey5,
  I_BusEvtLogObjectNodeRelshp.BuEvLgReltdSAPBusObjNodeKey6 AS BuEvLgReltdSAPBusObjNodeKey6,
  I_BusEvtLogObjectNodeRelshp.BuEvLgReltdSAPBusObjNodeKey7 AS BuEvLgReltdSAPBusObjNodeKey7,
  I_BusEvtLogObjectNodeRelshp.BuEvLgReltdSAPBusObjNodeKey8 AS BuEvLgReltdSAPBusObjNodeKey8,
  I_BusEvtLogObjectNodeRelshp.BusEvtLogRelatedProcIsOutdated AS BusEvtLogRelatedProcIsOutdated,
  I_BusEvtLogObjectNodeRelshp.BusEvtLogLastChangedDateTime AS BusEvtLogLastChangedDateTime,
  case when _SAPObjectTypeText[1:Language = $session.system_language].SAPObjectTypeName is not initial then _SAPObjectTypeText[1:Language = $session.system_language].SAPObjectTypeName else I_BusEvtLogObjectNodeRelshp.SAPObjectType end as SAPObjectTypeName AS SAPObjectTypeendasSAPObjectTypeName
FROM I_BusEvtLogObjectNodeRelshp
LEFT OUTER JOIN I_SAPObjectTypeText AS _SAPObjectTypeText ON RelatedSAPObjectType = _SAPObjectTypeText.SAPObjectType  -- association [0..*]
LEFT OUTER JOIN I_SAPObjectNodeTypeText AS _SAPObjectNodeTypeText ON RelatedSAPObjectNodeType = _SAPObjectNodeTypeText.SAPObjectNodeType  -- association [0..*]
;