P_ConfignTraceParamCsticResult

DDL: P_CONFIGNTRACEPARAMCSTICRESULT SQL: PVCHTRPCSTRES Type: view BASIC Package: VCH_HL_TRACE

VCH Trace: Entry Param - Characteristic Results

P_ConfignTraceParamCsticResult is a Basic CDS View that provides data about "VCH Trace: Entry Param - Characteristic Results" in SAP S/4HANA. It reads from 1 data source (vch_tr_p_cst_res) and exposes 8 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 (1)

SourceAliasJoin Type
vch_tr_p_cst_res vch_tr_p_cst_res from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_VarConfignValueListText _ResultType $projection.result_type = _ResultType.DomainValue and _ResultType.Language = $session.system_language and _ResultType.SAPDataDictionaryDomain = 'VCH_HL_TRACE_CSTIC_RESULT_TYPE'

Annotations (7)

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

KeyFieldSource TableSource FieldDescription
KEY trace_guid trace_guid Trace ID
KEY roundtrip_no roundtrip_no Roundtrip Number
KEY entry_no entry_no INT4
KEY parameter_no parameter_no ParamNo
instance_id instance_id Instance ID
cstic_id cstic_id Internal Cstic Id
cstic_name cstic_name Characteristic
result_type result_type Result Type

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_ConfignTraceParamCsticResult.
-- 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: PVCHTRPCSTRES

CREATE VIEW P_ConfignTraceParamCsticResult AS
SELECT
  trace_guid,
  roundtrip_no,
  entry_no,
  parameter_no,
  instance_id,
  cstic_id,
  cstic_name,
  result_type
FROM vch_tr_p_cst_res
LEFT OUTER JOIN P_VarConfignValueListText AS _ResultType ON result_type = _ResultType.DomainValue AND _ResultType.Language = $session.system_language AND _ResultType.SAPDataDictionaryDomain = 'VCH_HL_TRACE_CSTIC_RESULT_TYPE'  -- association [0..1]
;