P_ConfignTraceParamDepSearch

DDL: P_CONFIGNTRACEPARAMDEPSEARCH SQL: PVCHTRPOBJDEP4S Type: view BASIC

P_ConfignTraceParamDepSearch is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (P_ConfignTraceParamObjDep) and exposes 19 fields with key fields trace_guid, roundtrip_no, entry_no, parameter_no, roundtrip_no. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_ConfignTraceParamObjDep P_ConfignTraceParamObjDep from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ObjectDependency _ObjectDependency $projection.dependency_id = _ObjectDependency.ObjectDependency

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PVCHTRPOBJDEP4S view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #AUTOMATED view
VDM.viewType #BASIC view
VDM.private true view

Fields (19)

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
value_id value_id Value ID
bom_item bom_item Item
ObjectDependencykeytrace_guid
KEY roundtrip_no roundtrip_no Roundtrip Number
KEY entry_no entry_no INT4
KEY parameter_no parameter_no ParamNo
instance_id Instance ID
cstic_id Internal Cstic Id
cstic_name Characteristic
value_id Value ID
bom_item Item
sub_idx sub_idx Sub Index

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_ConfignTraceParamDepSearch.
-- 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: PVCHTRPOBJDEP4S

CREATE VIEW P_ConfignTraceParamDepSearch AS
SELECT
  trace_guid,
  roundtrip_no,
  entry_no,
  parameter_no,
  instance_id,
  cstic_id,
  cstic_name,
  value_id,
  bom_item,
  sub_idx AS ObjectDependencykeytrace_guid,
  sub_idx
FROM P_ConfignTraceParamObjDep
LEFT OUTER JOIN I_ObjectDependency AS _ObjectDependency ON dependency_id = _ObjectDependency.ObjectDependency  -- association [0..1]
;