Cds_View_Crossreference

DDL: CDS_VIEW_CROSSREFERENCE SQL: CDSVIEWCROSSREF Type: view

CDS View CrossReference

Cds_View_Crossreference is a CDS View that provides data about "CDS View CrossReference" in SAP S/4HANA. It reads from 3 data sources (ddldependency, dd26s, ddldependency) and exposes 10 fields with key fields SQLViewName, ReferredObject, ViewPosition.

3 data source(s) 10 fields

Data Sources (3)

SourceAliasJoin Type
ddldependency currentObject left_outer
dd26s dd26s from
ddldependency referrencedObject left_outer

Annotations (5)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SQLViewName dd26s viewname
KEY ReferredObject dd26s tabname
KEY ViewPosition dd26s tabpos
ReferredObjectType _ReferredObjectType tabclass
ReferredObjectDDLSourceName ddldependency ddlname
ObjectDDLSourceName ddldependency ddlname
_ReferredTableDescription _ReferredTableDescription
_ReferredViewDescription _ReferredViewDescription
CReferredObject
CSQLViewName 
@AbapCatalog.sqlViewName: 'CDSVIEWCROSSREF'
@EndUserText.label: 'CDS View CrossReference'
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Cds_View_Crossreference as select from dd26s

left outer join ddldependency as referrencedObject
on referrencedObject.objectname = dd26s.tabname
and referrencedObject.objecttype = 'VIEW'
and referrencedObject.state = 'A'

left outer join ddldependency as currentObject
on currentObject.objectname = dd26s.viewname
and currentObject.objecttype = 'VIEW'
and currentObject.state = 'A'

association[1..1] to dd02l as _ReferredObjectType on $projection.ReferredObject = _ReferredObjectType.tabname
association[1] to dd02t as _ReferredTableDescription on $projection.ReferredObject = _ReferredTableDescription.tabname
association[1] to ddddlsrct as _ReferredViewDescription on $projection.ReferredObjectDDLSourceName = _ReferredViewDescription.ddlname {
  key dd26s.viewname as SQLViewName,
  key dd26s.tabname as ReferredObject,
  key dd26s.tabpos as ViewPosition,
  _ReferredObjectType.tabclass as ReferredObjectType,
  referrencedObject.ddlname as ReferredObjectDDLSourceName,
  currentObject.ddlname as ObjectDDLSourceName,
  _ReferredTableDescription,
  _ReferredViewDescription,
  concat('2C',dd26s.tabname) as CReferredObject,
  concat('2C',dd26s.viewname) as CSQLViewName
} 
where dd26s.as4local = 'A' 
    and dd26s.tabname != 'DDDDLCHARTYPES'
    and dd26s.tabname != 'DDDDLNUMTYPES'
    and dd26s.tabname != 'DDDDLCURRTYPES'
    and dd26s.tabname != 'DDDDLDECTYPES'
    and dd26s.tabname != 'DDDDLQUANTYPES'

Learn More