P_SCLT_CBO_NODE_HEADER

DDL: P_SCLT_CBO_NODE_HEADER SQL: P_SCLT_NODH_T_V Type: view

CLT: CBO Node Header

P_SCLT_CBO_NODE_HEADER is a CDS View that provides data about "CLT: CBO Node Header" in SAP S/4HANA. It reads from 1 data source (P_SCLT_CBO_NODE_HEADER_ID) and exposes 14 fields with key fields TraceID, OrdinalNumber, CBONodeID.

Data Sources (1)

SourceAliasJoin Type
P_SCLT_CBO_NODE_HEADER_ID P_SCLT_CBO_NODE_HEADER_ID from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName P_SCLT_NODH_T_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CLT: CBO Node Header view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY TraceID TraceID Trace ID
KEY OrdinalNumber OrdinalNumber Sequence Number
KEY CBONodeID CBONodeID Workflow Step
ElementID
BusinessObjectID BusinessObjectID Business Object ID
ParameterName CBONodeID Workflow Step
ValueIn
ValueOut
Type
ParentNodeID
NodeID CBONodeID Workflow Step
HierarchyLevel 0
DrillState
ListOrder 1

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_SCLT_CBO_NODE_HEADER.
-- 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: P_SCLT_NODH_T_V

CREATE VIEW P_SCLT_CBO_NODE_HEADER AS
SELECT
  TraceID,
  OrdinalNumber,
  CBONodeID,
  '' AS ElementID,
  BusinessObjectID,
  CBONodeID AS ParameterName,
  '' AS ValueIn,
  '' AS ValueOut,
  '' AS Type,
  '' AS ParentNodeID,
  CBONodeID AS NodeID,
  0 AS HierarchyLevel,
  'expanded' AS DrillState,
  1 AS ListOrder
FROM P_SCLT_CBO_NODE_HEADER_ID
;