RSODP_ABAP_CDS_ODPNAME

CDS View

Derive ODP Name

RSODP_ABAP_CDS_ODPNAME is a CDS View in S/4HANA. Derive ODP Name. It contains 9 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 9 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
RSODP_ABAP_CDS_EXTR_odpname view from ODP name of CDS extraction entities
RSODP_ABAP_CDS_ODPNAME_LIST view_entity from Derive ODP Name
RSRTS_QF4_QueryProvider_All view_entity inner
RSRTS_QF4_QUERYWOPROVIDER view_entity from Queries (without Provider Info)
RSRTS_QF4_QUERYWOPROVIDER view_entity union_all Queries (without Provider Info)

Fields (9)

KeyField CDS FieldsUsed in Views
KEY cdsViewName queryCDSName 1
_changedBy _changedBy 1
changedAtDate changedAtDate 1
changedAtTime changedAtTime 1
changedBy changedBy 1
createdOnDate createdOnDate 1
ddlName cubeDDLname,ddlname,queryDDLName 4
devClass cubeDevclass,devClass,queryDevClass 3
sourceType sourceType 1 
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Derive ODP Name'
define view entity RSODP_ABAP_CDS_ODPNAME as 
select from RSODP_ABAP_CDS_ODPNAME_CNT as o 
/* 
   if 2 views have the same ODP name take the one with lower createdOnDate
   if the createdOnDate is equal take the view which CDSViewName comes first
*/

inner join RSODP_ABAP_CDS_ODPNAME_ALL as a on a.odpName       = o.odpName 
                                          and a.createdOnDate = o.minCreatedOnDate
                                          and a.cdsViewName   = o.minCDSViewName
{
  key o.odpName,
  a.cdsViewName,
  a.ddlName,
  a.sourceType,
  a.devClass,
  a.createdOnDate,
  a.changedAtDate,
  a.changedAtTime,
  a.changedBy,
  //o

  o.minPrio,
  cast( case o.cnt when 1 then ' ' else 'X' end as rs_bool ) as hasDuplicate,
  a._changedBy as _changedBy
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RSODP_ABAP_CDS_ODPNAME_ALL",
"RSODP_ABAP_CDS_ODPNAME_CNT"
],
"ASSOCIATED":
[
"I_USER"
],
"BASE":
[
"RSODP_ABAP_CDS_ODPNAME_ALL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More