P_ConfignTraceEntry

DDL: P_CONFIGNTRACEENTRY SQL: PVCHTRENTRY Type: view BASIC

P_ConfignTraceEntry is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (vch_tr_entry, vch_tr_msg_type) and exposes 10 fields with key fields trace_guid, roundtrip_no, entry_no, text_no.

Data Sources (2)

SourceAliasJoin Type
vch_tr_entry Entry from
vch_tr_msg_type MessageType left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PVCHTRENTRY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY trace_guid vch_tr_entry trace_guid Trace ID
KEY roundtrip_no vch_tr_entry roundtrip_no Roundtrip Number
KEY entry_no vch_tr_entry entry_no INT4
KEY text_no vch_tr_entry text_no Text Number
instance_id vch_tr_entry instance_id Instance ID
message_no vch_tr_msg_type message_no Message Number
trace_level vch_tr_msg_type trace_level Trace Level
trace_topic vch_tr_msg_type trace_topic Trace Topic
cstic_view vch_tr_msg_type cstic_view Characteristic View
has_details vch_tr_msg_type has_details Has details

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_ConfignTraceEntry.
-- 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.
-- SQL view name: PVCHTRENTRY

CREATE VIEW P_ConfignTraceEntry AS
SELECT
  Entry.trace_guid AS trace_guid,
  Entry.roundtrip_no AS roundtrip_no,
  Entry.entry_no AS entry_no,
  Entry.text_no AS text_no,
  Entry.instance_id AS instance_id,
  MessageType.message_no AS message_no,
  MessageType.trace_level AS trace_level,
  MessageType.trace_topic AS trace_topic,
  MessageType.cstic_view AS cstic_view,
  MessageType.has_details AS has_details
FROM vch_tr_entry AS Entry
LEFT OUTER JOIN vch_tr_msg_type AS MessageType ON /* join condition not captured in parsed metadata */
;