P_ConfignTraceEntryRefParams

DDL: P_CONFIGNTRACEENTRYREFPARAMS SQL: PVCHTRENTWREFPAR Type: view BASIC
7 Fields 4 Data Sources

P_ConfignTraceEntryRefParams is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (P_ConfignTraceParameter, P_ConfignTraceEntry, P_ConfignTraceMsgType, P_ConfignTraceRefParameter) and exposes 7 fields with key fields trace_guid, roundtrip_no, entry_no, text_no, parameter_no.

Data Sources (4)

SourceAliasJoin Type
P_ConfignTraceParameter Parameters inner
P_ConfignTraceEntry TraceEntry from
P_ConfignTraceMsgType TraceMessageTypes inner
P_ConfignTraceRefParameter TraceRefParam inner

Annotations (7)

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

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY trace_guid P_ConfignTraceEntry trace_guid Trace ID
KEY roundtrip_no P_ConfignTraceEntry roundtrip_no Roundtrip Number
KEY entry_no P_ConfignTraceEntry entry_no INT4
KEY text_no P_ConfignTraceEntry text_no Text Number
KEY parameter_no P_ConfignTraceParameter parameter_no ParamNo
io_type P_ConfignTraceParameter io_type Input/Output
cstic_view P_ConfignTraceMsgType cstic_view Characteristic View

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_ConfignTraceEntryRefParams.
-- 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: PVCHTRENTWREFPAR

CREATE VIEW P_ConfignTraceEntryRefParams AS
SELECT
  TraceEntry.trace_guid AS trace_guid,
  TraceEntry.roundtrip_no AS roundtrip_no,
  TraceEntry.entry_no AS entry_no,
  TraceEntry.text_no AS text_no,
  Parameters.parameter_no AS parameter_no,
  Parameters.io_type AS io_type,
  TraceMessageTypes.cstic_view AS cstic_view
FROM P_ConfignTraceEntry AS TraceEntry
INNER JOIN P_ConfignTraceRefParameter AS TraceRefParam ON /* join condition not captured in parsed metadata */
INNER JOIN P_ConfignTraceParameter AS Parameters ON /* join condition not captured in parsed metadata */
INNER JOIN P_ConfignTraceMsgType AS TraceMessageTypes ON /* join condition not captured in parsed metadata */
;

Learn More