Cds_View_Parameter

DDL: CDS_VIEW_PARAMETER SQL: CDSVIEWPARAM Type: view

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.

2 data source(s) 7 fields

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
KEY ParameterName dd10b parametername
DataType dd10b datatype
Length dd10b leng
Scale dd10b decimals
ParameterPosition dd10b posnr
DataElement dd10b rollname 
@AbapCatalog.sqlViewName: 'CDSVIEWPARAM'
@EndUserText.label: 'CDS View Parameter'
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Cds_View_Parameter as select from dd10b 
left outer join Cds_View_Hidden_Param on dd10b.strucobjn = Cds_View_Hidden_Param.strucobjn 
  and dd10b.parametername = Cds_View_Hidden_Param.parametername {
    key dd10b.strucobjn as CDSName,
    key dd10b.parametername as ParameterName,
    dd10b.datatype as DataType,
    dd10b.leng as Length,
    dd10b.decimals as Scale,
    dd10b.posnr as ParameterPosition,
    dd10b.rollname as DataElement
} where dd10b.as4local = 'A' and Cds_View_Hidden_Param.strucobjn is null  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"CDS_VIEW_HIDDEN_PARAM",
"DD10B"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More