P_BusEvtLogFieldChange

DDL: P_BUSEVTLOGFIELDCHANGE Type: view_entity
4 Fields 5 Data Sources

P_BusEvtLogFieldChange

P_BusEvtLogFieldChange is a CDS View that provides data about "P_BusEvtLogFieldChange" in SAP S/4HANA. It reads from 5 data sources (ddheadanno, dd02b, dd03nd, bel_d_event, bel_d_payload) and exposes 4 fields with key fields BusinessEventUUID, SAPObjectType, BusEvtLogChgDocFieldName.

Data Sources (5)

SourceAliasJoin Type
ddheadanno Anno inner
dd02b dd02b inner
dd03nd dd03nd inner
bel_d_event Event inner
bel_d_payload Payload from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label P_BusEvtLogFieldChange view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY BusinessEventUUID bel_d_payload event_guid Event GUID
KEY SAPObjectType bel_d_payload bo_type SOT Name
KEY BusEvtLogChgDocFieldName bel_d_payload fieldname UI Group FieldName
BusEvtLogGlobalFieldName

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_BusEvtLogFieldChange.
-- 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_BusEvtLogFieldChange AS
SELECT
  Payload.event_guid AS BusinessEventUUID,
  Payload.bo_type AS SAPObjectType,
  Payload.fieldname AS BusEvtLogChgDocFieldName,
  min(dd03nd.fieldname_raw) AS BusEvtLogGlobalFieldName
FROM bel_d_payload AS Payload
INNER JOIN bel_d_event AS Event ON /* join condition not captured in parsed metadata */
INNER JOIN ddheadanno AS Anno ON /* join condition not captured in parsed metadata */
INNER JOIN dd02b ON /* join condition not captured in parsed metadata */
INNER JOIN dd03nd ON /* join condition not captured in parsed metadata */
;

Learn More