P_ConfignTraceParamSearch

DDL: P_CONFIGNTRACEPARAMSEARCH SQL: PVCHTRPARSEARCH Type: view BASIC
9 Fields 1 Data Sources 3 Associations

P_ConfignTraceParamSearch is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (P_ConfignTraceEntry) and exposes 9 fields with key fields trace_guid, roundtrip_no, entry_no, text_no. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ConfignTraceEntry TraceEntry from

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_ConfignTraceMsgType _MsgTypes TraceEntry.message_type_id = _MsgTypes.message_type_id
[0..1] P_ConfignTraceHeaderParamSrch _HeaderParameters TraceEntry.trace_guid = _HeaderParameters.trace_guid and TraceEntry.roundtrip_no = _HeaderParameters.roundtrip_no and TraceEntry.entry_no = _HeaderParameters.entry_no and TraceEntry.text_no = _HeaderParameters.text_no
[0..1] P_ConfignTraceAllParamSrch _AllParameters TraceEntry.trace_guid = _AllParameters.trace_guid and TraceEntry.roundtrip_no = _AllParameters.roundtrip_no and TraceEntry.entry_no = _AllParameters.entry_no

Annotations (7)

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

Fields (9)

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
trace_level P_ConfignTraceEntry trace_level Trace Level
trace_topic P_ConfignTraceEntry trace_topic Trace Topic
cstic_view _MsgTypes cstic_view Characteristic View
_HeaderParameters _HeaderParameters
_AllParameters _AllParameters

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_ConfignTraceParamSearch.
-- 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: PVCHTRPARSEARCH

CREATE VIEW P_ConfignTraceParamSearch 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,
  TraceEntry.trace_level AS trace_level,
  TraceEntry.trace_topic AS trace_topic,
  _MsgTypes.cstic_view AS cstic_view
FROM P_ConfignTraceEntry AS TraceEntry
LEFT OUTER JOIN P_ConfignTraceMsgType AS _MsgTypes ON TraceEntry.message_type_id = _MsgTypes.message_type_id  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceHeaderParamSrch AS _HeaderParameters ON TraceEntry.trace_guid = _HeaderParameters.trace_guid AND TraceEntry.roundtrip_no = _HeaderParameters.roundtrip_no AND TraceEntry.entry_no = _HeaderParameters.entry_no AND TraceEntry.text_no = _HeaderParameters.text_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceAllParamSrch AS _AllParameters ON TraceEntry.trace_guid = _AllParameters.trace_guid AND TraceEntry.roundtrip_no = _AllParameters.roundtrip_no AND TraceEntry.entry_no = _AllParameters.entry_no  -- association [0..1]
;

Learn More