P_SCLT_CBO_NODE_PARAM

DDL: P_SCLT_CBO_NODE_PARAM SQL: P_SCLT_NODP_T_V Type: view

CLT: CBO Node Parameter

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

Data Sources (1)

SourceAliasJoin Type
sclt_cbo_nod_prm sclt_cbo_nod_prm from

Annotations (4)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY TraceID trace_id Trace ID
KEY OrdinalNumber ordinal_number Ordinal Number
KEY CBONodeID node_id Workflow Step
KEY ElementID element_id OAN Element ID
ParameterName OAN Element ID
BusinessObjectID business_object_id Business Object ID
ValueIn value_in Value
ValueOut value_out Value
Type
Kind
ParentNodeID node_id Workflow Step
NodeID
HierarchyLevel 1
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_PARAM.
-- 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_NODP_T_V

CREATE VIEW P_SCLT_CBO_NODE_PARAM AS
SELECT
  trace_id AS TraceID,
  ordinal_number AS OrdinalNumber,
  node_id AS CBONodeID,
  element_id AS ElementID,
  cast ( element_id as abap.char( 30 ) ) AS ParameterName,
  business_object_id AS BusinessObjectID,
  value_in AS ValueIn,
  value_out AS ValueOut,
  cast ( '' as abap.char( 30 ) ) AS Type,
  cast ( '' as abap.char( 9 ) ) AS Kind,
  node_id AS ParentNodeID,
  cast ( concat(node_id,element_id) as abap.char( 60 ) ) AS NodeID,
  1 AS HierarchyLevel,
  cast ( 'leaf' as abap.char( 8 ) ) AS DrillState,
  1 AS ListOrder
FROM sclt_cbo_nod_prm
;