P_ConfignTraceEntryParams

DDL: P_CONFIGNTRACEENTRYPARAMS SQL: PVCHTRENTPAR Type: view BASIC Package: VCH_HL_TRACE
11 Fields 6 Data Sources 1 Associations

VCH Trace: Trace Entries with Parameters

P_ConfignTraceEntryParams is a Basic CDS View that provides data about "VCH Trace: Trace Entries with Parameters" in SAP S/4HANA. It reads from 6 data sources and exposes 11 fields with key fields trace_guid, roundtrip_no, entry_no, parameter_no. It has 1 association to related views. Part of development package VCH_HL_TRACE.

Data Sources (6)

SourceAliasJoin Type
P_ConfignTraceParamBAdI BAdI left_outer
P_ConfignTraceParamCharc CharacteristicsValues left_outer
P_ConfignTraceParamObjDep ObjectDependenciesInput left_outer
P_ConfignTraceParamDepResult ObjectDependenciesResults left_outer
P_ConfignTraceParameter Parameters from
P_ConfignTraceParamSystemMsg T100 left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_ConfignTraceParamVariantTab VariantTables Parameters.trace_guid = VariantTables.trace_guid and Parameters.roundtrip_no = VariantTables.roundtrip_no and Parameters.entry_no = VariantTables.entry_no and Parameters.parameter_no = VariantTables.parameter_no

Annotations (6)

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

KeyFieldSource TableSource FieldDescription
KEY trace_guid P_ConfignTraceParameter trace_guid Trace ID
KEY roundtrip_no P_ConfignTraceParameter roundtrip_no Roundtrip Number
KEY entry_no P_ConfignTraceParameter entry_no INT4
KEY parameter_no P_ConfignTraceParameter parameter_no ParamNo
io_type P_ConfignTraceParameter io_type Input/Output
cstic_id P_ConfignTraceParamCharc cstic_id Internal Cstic Id
cstic_name P_ConfignTraceParamCharc cstic_name Characteristic
value_id P_ConfignTraceParamCharc value_id Value ID
instance_id P_ConfignTraceParamCharc instance_id Instance ID
badi_name P_ConfignTraceParamBAdI badi_name Name of a BAdI
message_type P_ConfignTraceParamSystemMsg message_type Para. Change Check

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_ConfignTraceEntryParams.
-- 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: PVCHTRENTPAR

CREATE VIEW P_ConfignTraceEntryParams AS
SELECT
  Parameters.trace_guid AS trace_guid,
  Parameters.roundtrip_no AS roundtrip_no,
  Parameters.entry_no AS entry_no,
  Parameters.parameter_no AS parameter_no,
  Parameters.io_type AS io_type,
  CharacteristicsValues.cstic_id AS cstic_id,
  CharacteristicsValues.cstic_name AS cstic_name,
  CharacteristicsValues.value_id AS value_id,
  CharacteristicsValues.instance_id AS instance_id,
  BAdI.badi_name AS badi_name,
  T100.message_type AS message_type
FROM P_ConfignTraceParameter AS Parameters
LEFT OUTER JOIN P_ConfignTraceParamObjDep AS ObjectDependenciesInput ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamDepResult AS ObjectDependenciesResults ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamBAdI AS BAdI ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamSystemMsg AS T100 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamCharc AS CharacteristicsValues ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamVariantTab AS VariantTables ON Parameters.trace_guid = VariantTables.trace_guid AND Parameters.roundtrip_no = VariantTables.roundtrip_no AND Parameters.entry_no = VariantTables.entry_no AND Parameters.parameter_no = VariantTables.parameter_no  -- association [0..1]
;

Learn More