APS_V_RCV_SQLVIEW_LIST

DDL: APS_V_RCV_SQLVIEW_LIST SQL: V_RCV_SQLVIEW Type: view

Get List of SQL View Names

APS_V_RCV_SQLVIEW_LIST is a CDS View that provides data about "Get List of SQL View Names" in SAP S/4HANA. It reads from 1 data source (ddldependency) and exposes 3 fields with key fields DDLSourceName, SQLViewName, state.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
ddldependency ddldependency from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName V_RCV_SQLVIEW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Get List of SQL View Names view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName ddldependency ddlname
KEY SQLViewName ddldependency objectname
KEY state ddldependency state 
@AbapCatalog.sqlViewName: 'V_RCV_SQLVIEW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Get List of SQL View Names'
define view APS_V_RCV_SQLVIEW_LIST as select from ddldependency {
key ddldependency.ddlname as DDLSourceName,
key  ddldependency.objectname as SQLViewName,
key  ddldependency.state
} where ddldependency.objecttype = 'VIEW' 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDLDEPENDENCY"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More