P_CDSVIEWATTR

DDL: P_CDSVIEWATTR SQL: PCDSVIEWATTR Type: view BASIC

P_CDSVIEWATTR is a Basic CDS View in SAP S/4HANA. It reads from 5 data sources (P_CdsViewPkgAppComp, ddddlsrc02bt, ddldependency, ddldependency, ddddlsrc) and exposes 12 fields with key field DDLName.

5 data source(s) 12 fields

Data Sources (5)

SourceAliasJoin Type
P_CdsViewPkgAppComp _CdsViewPkgAppComp left_outer
ddddlsrc02bt _TXTSRC left_outer
ddldependency CDSSQLVIEW left_outer
ddldependency CDSVIEW inner
ddddlsrc DDL from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCDSVIEWATTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #CLIENT_INDEPENDENT view
ClientHandling.algorithm #NONE view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #P view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY DDLName ddddlsrc ddlname
LastChangeUser ddddlsrc as4user
LastChangeDate ddddlsrc as4date
LastChangeTime ddddlsrc as4time
Origin ddddlsrc source_origin
SQLViewName ddldependency objectname
CDSViewName ddldependency objectname
ViewDescription ddddlsrc02bt ddtext
ApplicationComponent P_CdsViewPkgAppComp ApplicationComponent
ApplicationComponentName P_CdsViewPkgAppComp ApplicationComponentName
ApplicationComponentText P_CdsViewPkgAppComp ApplicationComponentText
CDSPackage P_CdsViewPkgAppComp CDSPackage 
@AbapCatalog.sqlViewName: 'PCDSVIEWATTR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Attributes of CDS View'


@ClientHandling.type: #CLIENT_INDEPENDENT
@ClientHandling.algorithm: #NONE

@VDM.private: true
@VDM.viewType: #BASIC

@ObjectModel.usageType.serviceQuality: #P

define view P_CDSVIEWATTR
  as select from ddddlsrc      as DDL

    left outer join   ddldependency as CDSSQLVIEW on  DDL.ddlname           = CDSSQLVIEW.ddlname
                                             and CDSSQLVIEW.state      = 'A'
                                             and CDSSQLVIEW.objecttype = 'VIEW'

    inner join   ddldependency as CDSVIEW    on  DDL.ddlname        = CDSVIEW.ddlname
                                             and CDSVIEW.state      = 'A'
                                             and CDSVIEW.objecttype = 'STOB'
                                             
    left outer join P_CdsViewPkgAppComp as _CdsViewPkgAppComp   on DDL.ddlname = _CdsViewPkgAppComp.DDLName
    
    left outer join ddddlsrc02bt as _TXTSRC on  DDL.ddlname = _TXTSRC.ddlname
                                            and DDL.ddlname = _TXTSRC.strucobjn 
                                            and _TXTSRC.as4local = 'A'
                                            and _TXTSRC.ddlanguage = $session.system_language
     
{
  key DDL.ddlname           as DDLName,
      DDL.as4user           as LastChangeUser,
      DDL.as4date           as LastChangeDate,
      DDL.as4time           as LastChangeTime,
      DDL.source_origin     as Origin,

      CDSSQLVIEW.objectname as SQLViewName,
      CDSVIEW.objectname as CDSViewName,
      
      _TXTSRC.ddtext as ViewDescription,
      
      _CdsViewPkgAppComp.ApplicationComponent, 
      _CdsViewPkgAppComp.ApplicationComponentName, 
      _CdsViewPkgAppComp.ApplicationComponentText, 
      _CdsViewPkgAppComp.CDSPackage
}
where
  DDL.as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CDSVIEWPKGAPPCOMP",
"DDDDLSRC",
"DDDDLSRC02BT",
"DDLDEPENDENCY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More