P_BuEvLgSAPBusObjNdePrptyEnhcd

DDL: P_BUEVLGSAPBUSOBJNDEPRPTYENHCD Type: view_entity COMPOSITE
45 Fields 2 Data Sources 2 Associations

P_BuEvLgSAPBusObjNdePrptyEnhcd is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_BusinessEventLogActivity, P_BuEvLgSAPBusObjNdePrpty) and exposes 45 fields with key fields BusinessEventUUID, BusEvtLogObjectNodeID, BusEvtLogFieldName. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BusinessEventLogActivity _Activity inner
P_BuEvLgSAPBusObjNdePrpty _Payload from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_BusEvtLogEventSourceText _BusEvtLogEventSourceText $projection.BusinessEventLogSource = _BusEvtLogEventSourceText.BusinessEventLogSource
[0..*] I_BusEvtLogPayloadStatusText _BusEvtLogPayloadStatusText $projection.BusEvtLogPayloadStatus = _BusEvtLogPayloadStatusText.BusEvtLogPayloadStatus

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY BusinessEventUUID I_BusinessEventLogActivity BusinessEventUUID
KEY BusEvtLogObjectNodeID I_BusinessEventLogActivity BusEvtLogObjectNodeID
KEY BusEvtLogFieldName P_BuEvLgSAPBusObjNdePrpty BusEvtLogFieldName
SAPObjectType I_BusinessEventLogActivity SAPObjectType SOT Name
SAPObjectNodeType I_BusinessEventLogActivity SAPObjectNodeType SONT Name
SAPObjectNodeCharacterKey1 I_BusinessEventLogActivity SAPObjectNodeCharacterKey1
SAPBusinessObjectNodeKey1 I_BusinessEventLogActivity SAPBusinessObjectNodeKey1
SAPBusinessObjectNodeKey2 I_BusinessEventLogActivity SAPBusinessObjectNodeKey2
SAPBusinessObjectNodeKey3 I_BusinessEventLogActivity SAPBusinessObjectNodeKey3
SAPBusinessObjectNodeKey4 I_BusinessEventLogActivity SAPBusinessObjectNodeKey4
SAPBusinessObjectNodeKey5 I_BusinessEventLogActivity SAPBusinessObjectNodeKey5
SAPBusinessObjectNodeKey6 I_BusinessEventLogActivity SAPBusinessObjectNodeKey6
SAPBusinessObjectNodeKey7 I_BusinessEventLogActivity SAPBusinessObjectNodeKey7
SAPBusinessObjectNodeKey8 I_BusinessEventLogActivity SAPBusinessObjectNodeKey8
BuEvLgEvtBindgContr2RelState I_BusinessEventLogActivity BuEvLgEvtBindgContr2RelState
BusinessEventLogLogicalSystem I_BusinessEventLogActivity BusinessEventLogLogicalSystem
BusEvtLogUserInteractionType I_BusinessEventLogActivity BusEvtLogUserInteractionType
BusEvtLgUsrIntactnTypeValue I_BusinessEventLogActivity BusEvtLgUsrIntactnTypeValue
BusEvtLogReferenceEntityName I_BusinessEventLogActivity BusEvtLogReferenceEntityName
BusEvtLogReferenceEventUUID I_BusinessEventLogActivity BusEvtLogReferenceEventUUID
BusEvtLogCreationDateTime I_BusinessEventLogActivity BusEvtLogCreationDateTime
EventOperation I_BusinessEventLogActivity EventOperation
CreatedByUser I_BusinessEventLogActivity CreatedByUser User Name
BusEvtLogCreationDate I_BusinessEventLogActivity BusEvtLogCreationDate
BusEvtLogTransactionID I_BusinessEventLogActivity BusEvtLogTransactionID
BusEvtLogSAPBusObjNodeKey I_BusinessEventLogActivity SAPObjectNodeConcatenatedKey
BusEvtLogBusinessActivity I_BusinessEventLogActivity BusEvtLogBusinessActivity
BusEvtLogEventAbstractEntity I_BusinessEventLogActivity BusEvtLogEventAbstractEntity
BusEvtLogGlobalFieldName P_BuEvLgSAPBusObjNdePrpty BusEvtLogGlobalFieldName
BusEvtLogChgDocFieldName P_BuEvLgSAPBusObjNdePrpty BusEvtLogGlobalFieldName
BuEvLgGlobalFieldNameUpperCase P_BuEvLgSAPBusObjNdePrpty BuEvLgGlobalFieldNameUpperCase
BusEvtLogOldFieldValue P_BuEvLgSAPBusObjNdePrpty BusEvtLogOldFieldValue
BusEvtLogOldFieldUnit P_BuEvLgSAPBusObjNdePrpty BusEvtLogOldFieldUnit
BusEvtLogNewFieldValue P_BuEvLgSAPBusObjNdePrpty BusEvtLogNewFieldValue
BusEvtLogNewFieldUnit P_BuEvLgSAPBusObjNdePrpty BusEvtLogNewFieldUnit
BusEvtLogOldFieldCurrency P_BuEvLgSAPBusObjNdePrpty BusEvtLogOldFieldCurrency
BusEvtLogNewFieldCurrency P_BuEvLgSAPBusObjNdePrpty BusEvtLogNewFieldCurrency
ChangeDocumentDatabaseTable P_BuEvLgSAPBusObjNdePrpty ChangeDocumentDatabaseTable
ChangeDocDatabaseTableField P_BuEvLgSAPBusObjNdePrpty ChangeDocDatabaseTableField
BusEvtLogEntityName _RAPEvent BusEvtLogEntityName
BusEvtLogEventBinding _Producer BusEvtLogEventBinding
ABAPDataElementendasABAPDataElement
ABAPDomainendasABAPDomain
_BusEvtLogEventSourceText _BusEvtLogEventSourceText
_BusEvtLogPayloadStatusText _BusEvtLogPayloadStatusText

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_BuEvLgSAPBusObjNdePrptyEnhcd.
-- 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_BuEvLgSAPBusObjNdePrptyEnhcd AS
SELECT
  _Activity.BusinessEventUUID AS BusinessEventUUID,
  _Activity.BusEvtLogObjectNodeID AS BusEvtLogObjectNodeID,
  _Payload.BusEvtLogFieldName AS BusEvtLogFieldName,
  _Activity.SAPObjectType AS SAPObjectType,
  _Activity.SAPObjectNodeType AS SAPObjectNodeType,
  _Activity.SAPObjectNodeCharacterKey1 AS SAPObjectNodeCharacterKey1,
  _Activity.SAPBusinessObjectNodeKey1 AS SAPBusinessObjectNodeKey1,
  _Activity.SAPBusinessObjectNodeKey2 AS SAPBusinessObjectNodeKey2,
  _Activity.SAPBusinessObjectNodeKey3 AS SAPBusinessObjectNodeKey3,
  _Activity.SAPBusinessObjectNodeKey4 AS SAPBusinessObjectNodeKey4,
  _Activity.SAPBusinessObjectNodeKey5 AS SAPBusinessObjectNodeKey5,
  _Activity.SAPBusinessObjectNodeKey6 AS SAPBusinessObjectNodeKey6,
  _Activity.SAPBusinessObjectNodeKey7 AS SAPBusinessObjectNodeKey7,
  _Activity.SAPBusinessObjectNodeKey8 AS SAPBusinessObjectNodeKey8,
  _Activity.BuEvLgEvtBindgContr2RelState AS BuEvLgEvtBindgContr2RelState,
  _Activity.BusinessEventLogLogicalSystem AS BusinessEventLogLogicalSystem,
  _Activity.BusEvtLogUserInteractionType AS BusEvtLogUserInteractionType,
  _Activity.BusEvtLgUsrIntactnTypeValue AS BusEvtLgUsrIntactnTypeValue,
  _Activity.BusEvtLogReferenceEntityName AS BusEvtLogReferenceEntityName,
  _Activity.BusEvtLogReferenceEventUUID AS BusEvtLogReferenceEventUUID,
  _Activity.BusEvtLogCreationDateTime AS BusEvtLogCreationDateTime,
  _Activity.EventOperation AS EventOperation,
  _Activity.CreatedByUser AS CreatedByUser,
  _Activity.BusEvtLogCreationDate AS BusEvtLogCreationDate,
  _Activity.BusEvtLogTransactionID AS BusEvtLogTransactionID,
  _Activity.SAPObjectNodeConcatenatedKey AS BusEvtLogSAPBusObjNodeKey,
  _Activity.BusEvtLogBusinessActivity AS BusEvtLogBusinessActivity,
  _Activity.BusEvtLogEventAbstractEntity AS BusEvtLogEventAbstractEntity,
  _Payload.BusEvtLogGlobalFieldName AS BusEvtLogGlobalFieldName,
  _Payload.BusEvtLogGlobalFieldName AS BusEvtLogChgDocFieldName,
  _Payload.BuEvLgGlobalFieldNameUpperCase AS BuEvLgGlobalFieldNameUpperCase,
  _Payload.BusEvtLogOldFieldValue AS BusEvtLogOldFieldValue,
  _Payload.BusEvtLogOldFieldUnit AS BusEvtLogOldFieldUnit,
  _Payload.BusEvtLogNewFieldValue AS BusEvtLogNewFieldValue,
  _Payload.BusEvtLogNewFieldUnit AS BusEvtLogNewFieldUnit,
  _Payload.BusEvtLogOldFieldCurrency AS BusEvtLogOldFieldCurrency,
  _Payload.BusEvtLogNewFieldCurrency AS BusEvtLogNewFieldCurrency,
  _Payload.ChangeDocumentDatabaseTable AS ChangeDocumentDatabaseTable,
  _Payload.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  _RAPEvent.BusEvtLogEntityName AS BusEvtLogEntityName,
  _Producer.BusEvtLogEventBinding AS BusEvtLogEventBinding,
  case when OldText.ABAPDataElement is null or OldText.ABAPDataElement is initial then OldTextAbs.ABAPDataElement else OldText.ABAPDataElement end as ABAPDataElement AS ABAPDataElementendasABAPDataElement,
  case when OldText.ABAPDomain is null or OldText.ABAPDomain is initial then OldTextAbs.ABAPDomain else OldText.ABAPDomain end as ABAPDomain AS ABAPDomainendasABAPDomain
FROM P_BuEvLgSAPBusObjNdePrpty AS _Payload
INNER JOIN I_BusinessEventLogActivity AS _Activity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusEvtLogEventSourceText AS _BusEvtLogEventSourceText ON BusinessEventLogSource = _BusEvtLogEventSourceText.BusinessEventLogSource  -- association [0..*]
LEFT OUTER JOIN I_BusEvtLogPayloadStatusText AS _BusEvtLogPayloadStatusText ON BusEvtLogPayloadStatus = _BusEvtLogPayloadStatusText.BusEvtLogPayloadStatus  -- association [0..*]
;

Learn More