@AbapCatalog.sqlViewName: 'RSRTS_CDS_RPD'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter: true
define view Rsrts_Cds_Repdir
as select from rsrrepdir
{
key infocube,
key compid,
SUBSTRING( infocube, 3, 28 ) as sqlNameCube,
SUBSTRING( compid, 3, 28 ) as sqlNameQuery,
count( * ) as compuidCount
}
where
objvers = 'A'
and infocube like '2C%'
and compid like '2C%'
and comptype = 'REP'
group by
infocube,
compid
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RSRREPDIR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/