P_BuEvLgSAPBusObjNdePrptyChg

DDL: P_BUEVLGSAPBUSOBJNDEPRPTYCHG Type: view_entity COMPOSITE
41 Fields 1 Data Sources 3 Associations

P_BuEvLgSAPBusObjNdePrptyChg is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_BuEvLgSAPBusObjNdePrptyChg) and exposes 41 fields with key fields SAPObjectType, SAPObjectNodeType, SAPBusinessObjectNodeKey1, SAPBusinessObjectNodeKey2, SAPBusinessObjectNodeKey3. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BuEvLgSAPBusObjNdePrptyChg I_BuEvLgSAPBusObjNdePrptyChg from

Associations (3)

CardinalityTargetAliasCondition
[0..1] C_BusEvtLogUserContactCard _ContactCard $projection.CreatedByUser = _ContactCard.ContactCardID
[0..1] I_SAPObjectType_2 _SAPObjectType_2 $projection.SAPObjectType = _SAPObjectType_2.SAPObjectType
[0..1] I_SAPObjectNodeType_2 _SAPObjectNodeType_2 $projection.SAPObjectNodeType = _SAPObjectNodeType_2.SAPObjectNodeType

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.representativeKey SAPObjectNodeType view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY SAPObjectType I_BuEvLgSAPBusObjNdePrptyChg SAPObjectType SOT Name
KEY SAPObjectNodeType I_BuEvLgSAPBusObjNdePrptyChg SAPObjectNodeType SONT Name
KEY SAPBusinessObjectNodeKey1 I_BuEvLgSAPBusObjNdePrptyChg SAPBusinessObjectNodeKey1 INT4
KEY SAPBusinessObjectNodeKey2 I_BuEvLgSAPBusObjNdePrptyChg SAPBusinessObjectNodeKey2 Character Field of Length 12
KEY SAPBusinessObjectNodeKey3 I_BuEvLgSAPBusObjNdePrptyChg SAPBusinessObjectNodeKey3 INT2
KEY SAPBusinessObjectNodeKey4 I_BuEvLgSAPBusObjNdePrptyChg SAPBusinessObjectNodeKey4 BO Key Part (4)
KEY SAPBusinessObjectNodeKey5 I_BuEvLgSAPBusObjNdePrptyChg SAPBusinessObjectNodeKey5 BO Key Part (5)
KEY SAPBusinessObjectNodeKey6 I_BuEvLgSAPBusObjNdePrptyChg SAPBusinessObjectNodeKey6 BO Key Part (6)
KEY SAPBusinessObjectNodeKey7 I_BuEvLgSAPBusObjNdePrptyChg SAPBusinessObjectNodeKey7 Business Object Key
KEY SAPBusinessObjectNodeKey8 I_BuEvLgSAPBusObjNdePrptyChg SAPBusinessObjectNodeKey8 BO Key Part (8)
KEY BusEvtLogFieldName I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogFieldName UI Group FieldName
KEY BusEvtLogCreationDateTime I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogCreationDateTime Executed Time Stamp
SAPObjectNodeCharacterKey1 I_BuEvLgSAPBusObjNdePrptyChg SAPObjectNodeCharacterKey1 BO Key Part (1)
BuEvLgNumberOfBusEventPrprts No. of Changes to Fields
YearWeek _CalendarDate YearWeek Year and Calendar Week
FullName _UserName FullName Changed By
BusEvtLogCreationDate I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogCreationDate Executed Date
BusEvtLogSAPBusObjNodeKey I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogSAPBusObjNodeKey BO Key
BusEvtLogOldFieldValue I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogOldFieldValue Value
BusEvtLogOldFieldUnit I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogOldFieldUnit Old Unit
BusEvtLogNewFieldValue I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogNewFieldValue Value
BusEvtLogNewFieldUnit I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogNewFieldUnit New Unit
BusEvtLogOldFieldCurrency I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogOldFieldCurrency Currency Old
BusEvtLogNewFieldCurrency I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogNewFieldCurrency Currency New
BusEvtLogGlobalFieldName I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogGlobalFieldName Property Name
BuEvLgGlobalFieldNameUpperCase I_BuEvLgSAPBusObjNdePrptyChg BuEvLgGlobalFieldNameUpperCase Property Name
BusEvtLogEntityName I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogEntityName Table Name
BusEvtLogEntityEventName I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogEntityEventName Entity Event Name
BusEvtLogPayloadFieldPath I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogPayloadFieldPath Path rule
CreatedByUser I_BuEvLgSAPBusObjNdePrptyChg CreatedByUser User Name
EventOperation I_BuEvLgSAPBusObjNdePrptyChg EventOperation SAP Object Task Type
BusinessEventLogSource I_BuEvLgSAPBusObjNdePrptyChg BusinessEventLogSource Source of Data
BusEvtLogTransactionID I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogTransactionID Update key
BusEvtLogObjectNodeID I_BuEvLgSAPBusObjNdePrptyChg BusEvtLogObjectNodeID BEL Object Node ID
BusinessEventUUID I_BuEvLgSAPBusObjNdePrptyChg BusinessEventUUID Event GUID
ChangeDocumentDatabaseTable I_BuEvLgSAPBusObjNdePrptyChg ChangeDocumentDatabaseTable Table Name
ChangeDocDatabaseTableField I_BuEvLgSAPBusObjNdePrptyChg ChangeDocDatabaseTableField Field Name
BuEvLgNodeLastChangedDateTime ObjectNode BuEvLgNodeLastChangedDateTime
BusinessEventLogSourceText Source Description
_SAPObjectType_2 _SAPObjectType_2
_ContactCard _ContactCard

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_BuEvLgSAPBusObjNdePrptyChg.
-- 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_BuEvLgSAPBusObjNdePrptyChg AS
SELECT
  I_BuEvLgSAPBusObjNdePrptyChg.SAPObjectType AS SAPObjectType,
  I_BuEvLgSAPBusObjNdePrptyChg.SAPObjectNodeType AS SAPObjectNodeType,
  I_BuEvLgSAPBusObjNdePrptyChg.SAPBusinessObjectNodeKey1 AS SAPBusinessObjectNodeKey1,
  I_BuEvLgSAPBusObjNdePrptyChg.SAPBusinessObjectNodeKey2 AS SAPBusinessObjectNodeKey2,
  I_BuEvLgSAPBusObjNdePrptyChg.SAPBusinessObjectNodeKey3 AS SAPBusinessObjectNodeKey3,
  I_BuEvLgSAPBusObjNdePrptyChg.SAPBusinessObjectNodeKey4 AS SAPBusinessObjectNodeKey4,
  I_BuEvLgSAPBusObjNdePrptyChg.SAPBusinessObjectNodeKey5 AS SAPBusinessObjectNodeKey5,
  I_BuEvLgSAPBusObjNdePrptyChg.SAPBusinessObjectNodeKey6 AS SAPBusinessObjectNodeKey6,
  I_BuEvLgSAPBusObjNdePrptyChg.SAPBusinessObjectNodeKey7 AS SAPBusinessObjectNodeKey7,
  I_BuEvLgSAPBusObjNdePrptyChg.SAPBusinessObjectNodeKey8 AS SAPBusinessObjectNodeKey8,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogFieldName AS BusEvtLogFieldName,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogCreationDateTime AS BusEvtLogCreationDateTime,
  I_BuEvLgSAPBusObjNdePrptyChg.SAPObjectNodeCharacterKey1 AS SAPObjectNodeCharacterKey1,
  cast( 1 as bel_event_prop_count ) AS BuEvLgNumberOfBusEventPrprts,
  _CalendarDate.YearWeek AS YearWeek,
  _UserName.FullName AS FullName,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogCreationDate AS BusEvtLogCreationDate,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogSAPBusObjNodeKey AS BusEvtLogSAPBusObjNodeKey,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogOldFieldValue AS BusEvtLogOldFieldValue,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogOldFieldUnit AS BusEvtLogOldFieldUnit,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogNewFieldValue AS BusEvtLogNewFieldValue,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogNewFieldUnit AS BusEvtLogNewFieldUnit,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogOldFieldCurrency AS BusEvtLogOldFieldCurrency,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogNewFieldCurrency AS BusEvtLogNewFieldCurrency,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogGlobalFieldName AS BusEvtLogGlobalFieldName,
  I_BuEvLgSAPBusObjNdePrptyChg.BuEvLgGlobalFieldNameUpperCase AS BuEvLgGlobalFieldNameUpperCase,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogEntityName AS BusEvtLogEntityName,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogEntityEventName AS BusEvtLogEntityEventName,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogPayloadFieldPath AS BusEvtLogPayloadFieldPath,
  I_BuEvLgSAPBusObjNdePrptyChg.CreatedByUser AS CreatedByUser,
  I_BuEvLgSAPBusObjNdePrptyChg.EventOperation AS EventOperation,
  I_BuEvLgSAPBusObjNdePrptyChg.BusinessEventLogSource AS BusinessEventLogSource,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogTransactionID AS BusEvtLogTransactionID,
  I_BuEvLgSAPBusObjNdePrptyChg.BusEvtLogObjectNodeID AS BusEvtLogObjectNodeID,
  I_BuEvLgSAPBusObjNdePrptyChg.BusinessEventUUID AS BusinessEventUUID,
  I_BuEvLgSAPBusObjNdePrptyChg.ChangeDocumentDatabaseTable AS ChangeDocumentDatabaseTable,
  I_BuEvLgSAPBusObjNdePrptyChg.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  ObjectNode.BuEvLgNodeLastChangedDateTime AS BuEvLgNodeLastChangedDateTime,
  I_BuEvLgSAPBusObjNdePrptyChg._BusEvtLogEventSourceText[1:Language = $session.system_language].BusinessEventLogSourceText AS BusinessEventLogSourceText
FROM I_BuEvLgSAPBusObjNdePrptyChg
LEFT OUTER JOIN C_BusEvtLogUserContactCard AS _ContactCard ON CreatedByUser = _ContactCard.ContactCardID  -- association [0..1]
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]
;

Learn More