P_Ddl_Viewname

DDL: P_DDL_VIEWNAME SQL: PDDLVIEWNAME Type: view BASIC Package: FCLM_PLANNING

DDLView and sqlView

P_Ddl_Viewname is a Basic CDS View that provides data about "DDLView and sqlView" in SAP S/4HANA. It reads from 2 data sources (ddldependency, ddldependency) and exposes 3 fields. Part of development package FCLM_PLANNING.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
ddldependency sqlview inner
ddldependency stob from

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PDDLVIEWNAME view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (3)

KeyFieldSource TableSource FieldDescription
stob_name ddldependency objectname
view_name ddldependency objectname
ddl_name ddldependency ddlname 
@VDM.private: true
@VDM.viewType: #BASIC 
@AbapCatalog.sqlViewName: 'PDDLVIEWNAME'
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_Ddl_Viewname as select from ddldependency as stob
inner join ddldependency as sqlview 
  on stob.ddlname = sqlview.ddlname and 
     stob.objecttype = 'STOB' and 
     stob.state = 'A' and 
     sqlview.state = 'A' and 
     stob.objecttype <> sqlview.objecttype
{
    stob.objectname as stob_name,
    sqlview.objectname as view_name,
    stob.ddlname as ddl_name
}

Learn More