P_ConfignTraceHeaderParamSrch

DDL: P_CONFIGNTRACEHEADERPARAMSRCH SQL: PVCHTRHDPARSRCH Type: view BASIC Package: VCH_HL_TRACE
7 Fields 1 Data Sources 1 Associations

VCH Trace: Search view for Header Parameters

P_ConfignTraceHeaderParamSrch is a Basic CDS View that provides data about "VCH Trace: Search view for Header Parameters" in SAP S/4HANA. It reads from 1 data source (P_ConfignTraceRefParameter) and exposes 7 fields with key fields trace_guid, roundtrip_no, entry_no, text_no. It has 1 association to related views. Part of development package VCH_HL_TRACE.

Data Sources (1)

SourceAliasJoin Type
P_ConfignTraceRefParameter RefParameters from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_ConfignTraceParamCsticSearch _Characteristics RefParameters.trace_guid = _Characteristics.trace_guid and RefParameters.roundtrip_no = _Characteristics.roundtrip_no and RefParameters.entry_no = _Characteristics.entry_no and RefParameters.parameter_no = _Characteristics.parameter_no and ( RefParameters.referenced_object_type = 'CSV' or RefParameters.referenced_object_type = 'CRE' or RefParameters.referenced_object_type = 'PFR' )

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PVCHTRHDPARSRCH 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 (7)

KeyFieldSource TableSource FieldDescription
KEY trace_guid P_ConfignTraceRefParameter trace_guid Trace ID
KEY roundtrip_no P_ConfignTraceRefParameter roundtrip_no Roundtrip Number
KEY entry_no P_ConfignTraceRefParameter entry_no INT4
KEY text_no P_ConfignTraceRefParameter text_no Text Number
instance_id _Characteristics instance_id Instance ID
cstic_id _Characteristics cstic_id Internal Cstic Id
cstic_name _Characteristics cstic_name Characteristic

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_ConfignTraceHeaderParamSrch.
-- 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: PVCHTRHDPARSRCH

CREATE VIEW P_ConfignTraceHeaderParamSrch AS
SELECT
  RefParameters.trace_guid AS trace_guid,
  RefParameters.roundtrip_no AS roundtrip_no,
  RefParameters.entry_no AS entry_no,
  RefParameters.text_no AS text_no,
  _Characteristics.instance_id AS instance_id,
  _Characteristics.cstic_id AS cstic_id,
  _Characteristics.cstic_name AS cstic_name
FROM P_ConfignTraceRefParameter AS RefParameters
LEFT OUTER JOIN P_ConfignTraceParamCsticSearch AS _Characteristics ON RefParameters.trace_guid = _Characteristics.trace_guid AND RefParameters.roundtrip_no = _Characteristics.roundtrip_no AND RefParameters.entry_no = _Characteristics.entry_no AND RefParameters.parameter_no = _Characteristics.parameter_no AND ( RefParameters.referenced_object_type = 'CSV' OR RefParameters.referenced_object_type = 'CRE' OR RefParameters.referenced_object_type = 'PFR' )  -- association [0..1]
;

Learn More