P_SCLT_CBO_PARAM

DDL: P_SCLT_CBO_PARAM SQL: P_SCLT_CBOPRM_V Type: view

CLT: CBO parameter

P_SCLT_CBO_PARAM is a CDS View that provides data about "CLT: CBO parameter" in SAP S/4HANA. It reads from 1 data source (sclt_cbo_param) and exposes 15 fields with key fields TraceID, OrdinalNumber, ParameterName.

Data Sources (1)

SourceAliasJoin Type
sclt_cbo_param sclt_cbo_param from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName P_SCLT_CBOPRM_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CLT: CBO parameter view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY TraceID trace_id Trace ID
KEY OrdinalNumber ordinal_number Ordinal Number
KEY ParameterName parameter_name Support Parameter
CBONodeID
ElementID
BusinessObjectID
ValueIn
ValueOut parameter_value Value
Type
Kind
ParentNodeID
NodeID parameter_name Support Parameter
HierarchyLevel 0
DrillState
ListOrder 2

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_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_CBOPRM_V

CREATE VIEW P_SCLT_CBO_PARAM AS
SELECT
  trace_id AS TraceID,
  ordinal_number AS OrdinalNumber,
  parameter_name AS ParameterName,
  '' AS CBONodeID,
  '' AS ElementID,
  '' AS BusinessObjectID,
  '' AS ValueIn,
  parameter_value AS ValueOut,
  '' AS Type,
  'Exporting' AS Kind,
  '' AS ParentNodeID,
  parameter_name AS NodeID,
  0 AS HierarchyLevel,
  'leaf' AS DrillState,
  2 AS ListOrder
FROM sclt_cbo_param
;