Rsodp_Abap_Cds_Aggrlevel

DDL: RSODP_ABAP_CDS_AGGRLEVEL SQL: RSODPABAPCDSVWAL Type: view

ABAP CDS: Aggregation Level

Rsodp_Abap_Cds_Aggrlevel is a CDS View that provides data about "ABAP CDS: Aggregation Level" in SAP S/4HANA. It reads from 3 data sources (ddldependency, ddldependency, ddheadanno) and exposes 3 fields with key fields objectname, dataCategory.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
ddldependency t0 from
ddldependency t1 inner
ddheadanno t2 inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName RSODPABAPCDSVWAL view
ClientHandling.type #CLIENT_INDEPENDENT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #SINGLE view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label ABAP CDS: Aggregation Level view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY objectname ddldependency objectname
KEY dataCategory
viewname ddldependency objectname 
@AbapCatalog.sqlViewName: 'RSODPABAPCDSVWAL'
@ClientHandling.type: #CLIENT_INDEPENDENT
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering: { status: #ACTIVE, type: #SINGLE }
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'ABAP CDS: Aggregation Level'
define view Rsodp_Abap_Cds_Aggrlevel as select from ddldependency as t0
          inner join ddldependency as t1 on t1.ddlname = t0.ddlname
          inner join ddheadanno as t2 on t2.strucobjn = t1.objectname
{
    key t0.objectname as objectname,
    key cast( left( t2.value, 255 ) as char255 ) as dataCategory,
    t1.objectname as viewname
}
          where t0.state = 'A' and t0.objecttype = 'VIEW'
            and t1.state = 'A' and t1.objecttype = 'STOB'
            and t2.name = 'ANALYTICS.DATACATEGORY'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDHEADANNO",
"DDLDEPENDENCY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More