Cds_View_Type

DDL: CDS_VIEW_TYPE SQL: CDSVIEWTYPE Type: view

CDS View Type

Cds_View_Type is a CDS View that provides data about "CDS View Type" in SAP S/4HANA. It reads from 1 data source (ddheadanno) and exposes 2 fields with key field CDSName.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
ddheadanno ddheadanno from

Annotations (5)

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

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CDSName ddheadanno strucobjn
char20asCdsViewType 
@AbapCatalog.sqlViewName: 'CDSVIEWTYPE'
@EndUserText.label: 'CDS View Type'
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Cds_View_Type
  as select from ddheadanno {
  key ddheadanno.strucobjn as CDSName,
  // Reducing the length for CdsViewType from CHAR1300 to CHAR20 as per performance guidelines.

  cast ( case ddheadanno.value
    when '#BASIC' then 'BASIC'
    when '#COMPOSITE' then 'COMPOSITE'
    when '#CONSUMPTION' then 'CONSUMPTION'
    when '#EXTENSION' then 'EXTENSION'
    else 'NA'
  end as abap.char(20) ) as CdsViewType,
  case ddheadanno.value
    when '#CONSUMPTION' then 1
    else 2
  end as ViewTypeAppType
} where ddheadanno.name = 'VDM.VIEWTYPE'       
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDHEADANNO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More