C_PFW_InstancesAndTrace

DDL: C_PFW_INSTANCESANDTRACE Type: view_entity
9 Fields 1 Data Sources 1 Associations

PFW instance with corresponding traces

C_PFW_InstancesAndTrace is a CDS View that provides data about "PFW instance with corresponding traces" in SAP S/4HANA. It reads from 1 data source (C_Pfw_Instance) and exposes 9 fields with key fields Instance, Application. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
C_Pfw_Instance C_Pfw_Instance from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_PFW_Trace _Trace _Trace.Instance = C_Pfw_Instance.Instance and _Trace.ApplName = C_Pfw_Instance.Application

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PFW instance with corresponding traces view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName PFW Trace view
UI.headerInfo.typeNamePlural PFW Traces view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value Application view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value Instance view
Metadata.allowExtensions true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Instance Instance Instance
KEY Application Application Application
TraceLines TraceLines Trace
tasks Tasks Tasks
packages PackageCount Packages
elseOKendasStatus State
Trace_Start TraceStart Start timestamp
Trace_End TraceEnd End timestamp
_Trace _Trace

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 C_PFW_InstancesAndTrace.
-- 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.

CREATE VIEW C_PFW_InstancesAndTrace AS
SELECT
  Instance,
  Application,
  TraceLines,
  tasks,
  PackageCount AS packages,
  case left( concat( cast(Min_TraceLevel as abap.char(3)),running ), 2 ) when '0n' then 'ERROR' when '1n' then 'WARNING' when '0P' then 'Running...' when '1P' then 'Running...' when '2P' then 'Running...' else 'OK' end as Status AS elseOKendasStatus,
  TraceStart AS Trace_Start,
  TraceEnd AS Trace_End
FROM C_Pfw_Instance
LEFT OUTER JOIN C_PFW_Trace AS _Trace ON _Trace.Instance = C_Pfw_Instance.Instance AND _Trace.ApplName = C_Pfw_Instance.Application  -- association [0..*]
;

Learn More