VB_CDS_SQLVIEWNAME_EXTN

DDL: VB_CDS_SQLVIEWNAME_EXTN SQL: VBCDSSQLVIEWEXTN Type: view Package: S_DICT_VB

CDS SQL View Name with Extension

VB_CDS_SQLVIEWNAME_EXTN is a CDS View that provides data about "CDS SQL View Name with Extension" in SAP S/4HANA. It reads from 8 data sources and exposes 17 fields with key field DDLSourceName. Part of development package S_DICT_VB.

8 data source(s) 17 fields

Data Sources (8)

SourceAliasJoin Type
ddheadanno anno inner
ddheadanno anno inner
ddheadanno anno left_outer
ddheadanno anno left_outer
ddddlsrc Views from
ddddlsrc Views union_all
ddddlsrc Views union_all
ddddlsrc Views union_all

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName VBCDSSQLVIEWEXTN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label CDS SQL View Name with Extension view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName ddddlsrc ddlname
SQLViewName
CDSName ddddlsrc ddlname
CDSOriginKey ddddlsrc source_origin
ddlnameasDDLSourceName
SQLViewName ddddlsrc ddlname
CDSName ddddlsrc ddlname
CDSOriginKey ddddlsrc source_origin
ddlnameasDDLSourceName
SQLViewName ddddlsrc ddlname
CDSName ddddlsrc ddlname
CDSOriginKey ddddlsrc source_origin
ddlnameasDDLSourceName
SQLViewName ddddlsrc ddlname
CDSName ddddlsrc ddlname
CDSOriginKey ddddlsrc source_origin
SourceType ddddlsrc source_type 
@AbapCatalog.sqlViewName: 'VBCDSSQLVIEWEXTN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #P
@ObjectModel.usageType.sizeCategory:  #L
@EndUserText.label: 'CDS SQL View Name with Extension'

define view VB_CDS_SQLVIEWNAME_EXTN
  as select from  ddddlsrc as Views
    inner join ddheadanno as anno on Views.ddlname  = anno.strucobjn and anno.name = 'ANALYTICS.TECHNICALNAME' and  anno.value not like '''' and ( anno.value is not null 
                or anno.value <> '' )
  { // Entities with technical name annotation maintained

    key Views.ddlname         as DDLSourceName,
    upper( anno.value ) as SQLViewName,
    Views.ddlname       as CDSName,
    Views.source_origin as CDSOriginKey,
    Views.source_type as SourceType
  } where Views.source_type = 'W' and  Views.as4local = 'A' 
  union all
  select from ddddlsrc  as Views
    inner join ddheadanno as anno on Views.ddlname  = anno.strucobjn and anno.name = 'ANALYTICS.TECHNICALNAME'  and (anno.value is  null 
             or    anno.value = ''  or  anno.value  like '''') 
  { // Entities with the annotation maintained, but value is empty

    key Views.ddlname         as DDLSourceName,
    Views.ddlname as SQLViewName,
    Views.ddlname       as CDSName,
    Views.source_origin as CDSOriginKey,
    Views.source_type as SourceType
  } where Views.source_type = 'W' and  Views.as4local = 'A'
  union all
  select from ddddlsrc  as Views
    left outer join ddheadanno as anno on Views.ddlname  = anno.strucobjn and anno.name = 'ANALYTICS.TECHNICALNAME'
  { // Entities without the annotation

    key Views.ddlname         as DDLSourceName,
    Views.ddlname as SQLViewName,
    Views.ddlname       as CDSName,
    Views.source_origin as CDSOriginKey,
    Views.source_type as SourceType
  } where Views.source_type = 'W' and  Views.as4local = 'A' and anno.name is null 
  
  union all
  select from ddddlsrc  as Views
    left outer join ddheadanno as anno on Views.ddlname  = anno.strucobjn and anno.name = 'ANALYTICS.TECHNICALNAME'
  { // Entities without the annotation

    key Views.ddlname         as DDLSourceName,
    Views.ddlname as SQLViewName,
    Views.ddlname       as CDSName,
    Views.source_origin as CDSOriginKey,
    Views.source_type as SourceType
  } where Views.source_type = 'X' and  Views.as4local = 'A' and anno.name is null 
  
   
//  

//  left outer join ddheadanno as anno on Views.ddlname = anno.strucobjn and anno.name = 'ANALYTICS.TECHNICALNAME'

//  

//{

//  key Views.ddlname         as DDLSourceName,

//  case when anno.value is null then Views.ddlname

//       when anno.value = '' then Views.ddlname

//       else replace( upper( anno.value ), '''', '')

//  end as SQLViewName,

//  Views.ddlname       as CDSName,

//  Views.source_origin as CDSOriginKey,

//  Views.source_type as SourceType

Learn More