Cds_View_Parameter

DDL: CDS_VIEW_PARAMETER SQL: CDSVIEWPARAM Type: view
7 Fields 2 Data Sources

CDS View Parameter

Cds_View_Parameter is a CDS View that provides data about "CDS View Parameter" in SAP S/4HANA. It reads from 2 data sources (Cds_View_Hidden_Param, dd10b) and exposes 7 fields with key fields CDSName, ParameterName.

Data Sources (2)

SourceAliasJoin Type
Cds_View_Hidden_Param Cds_View_Hidden_Param left_outer
dd10b dd10b from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CDSVIEWPARAM view
EndUserText.label CDS View Parameter view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CDSName dd10b strucobjn DD: Name of a structured object (e.g. entity, context)
KEY ParameterName dd10b parametername Rule Parameter
DataType dd10b datatype Field Type
Length dd10b leng No. of Characters
Scale dd10b decimals Rounding Places
ParameterPosition dd10b posnr WBS Element
DataElement dd10b rollname Repr. Data Elem

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 Cds_View_Parameter.
-- 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: CDSVIEWPARAM

CREATE VIEW Cds_View_Parameter AS
SELECT
  dd10b.strucobjn AS CDSName,
  dd10b.parametername AS ParameterName,
  dd10b.datatype AS DataType,
  dd10b.leng AS Length,
  dd10b.decimals AS Scale,
  dd10b.posnr AS ParameterPosition,
  dd10b.rollname AS DataElement
FROM dd10b
LEFT OUTER JOIN Cds_View_Hidden_Param ON /* join condition not captured in parsed metadata */
;

Learn More