I_BuEvLgSAPBusObjNdePrptyChg

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_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 I_BuEvLgSAPBusObjNdePrptyChg AS
SELECT
  _Event.event_guid AS BusinessEventUUID,
  _Event.object_node_id AS BusEvtLogObjectNodeID,
  _Payload.fieldname AS BusEvtLogFieldName,
  _Event.bo_type AS SAPObjectType,
  _Event.object_node_type AS SAPObjectNodeType,
  _Event.key1_char AS SAPObjectNodeCharacterKey1,
  _Event.key1 AS SAPBusinessObjectNodeKey1,
  _Event.key2 AS SAPBusinessObjectNodeKey2,
  _Event.key3 AS SAPBusinessObjectNodeKey3,
  _Event.key4 AS SAPBusinessObjectNodeKey4,
  _Event.key5 AS SAPBusinessObjectNodeKey5,
  _Event.key6 AS SAPBusinessObjectNodeKey6,
  _Event.key7 AS SAPBusinessObjectNodeKey7,
  _Event.key8 AS SAPBusinessObjectNodeKey8,
  _Event.exec_timestamp AS BusEvtLogCreationDateTime,
  _Payload.fieldname_gfn AS BusEvtLogGlobalFieldName,
  _Payload.fieldname_raw AS BuEvLgGlobalFieldNameUpperCase,
  _Event.bo_task AS EventOperation,
  _Payload.old_value AS BusEvtLogOldFieldValue,
  _Payload.old_unit AS BusEvtLogOldFieldUnit,
  _Payload.new_value AS BusEvtLogNewFieldValue,
  _Payload.new_unit AS BusEvtLogNewFieldUnit,
  _Payload.currency_old AS BusEvtLogOldFieldCurrency,
  _Payload.currency_new AS BusEvtLogNewFieldCurrency,
  _Payload.path AS BusEvtLogPayloadFieldPath,
  _Payload.cd_tabname AS ChangeDocumentDatabaseTable,
  _Payload.cd_fieldname AS ChangeDocDatabaseTableField,
  _Event.uname AS CreatedByUser,
  _Event.exec_date AS BusEvtLogCreationDate,
  _Event.event_source AS BusinessEventLogSource,
  _Event.transaction_id AS BusEvtLogTransactionID,
  _RAPEvent.entity_name AS BusEvtLogEntityName,
  _RAPEvent.entity_event_name AS BusEvtLogEntityEventName,
  _Producer.evtb_name AS BusEvtLogEventBinding,
  _Event.event_version AS BusinessEventLogEventVersion,
  _Event.key_concat AS BusEvtLogSAPBusObjNodeKey
FROM bel_d_event AS _Event
LEFT OUTER JOIN I_BusEvtLogEventSourceText AS _BusEvtLogEventSourceText ON BusinessEventLogSource = _BusEvtLogEventSourceText.BusinessEventLogSource  -- association [0..*]
;