RSODP_ABAP_CDS_ODPNAME_LIST

DDL: RSODP_ABAP_CDS_ODPNAME_LIST Type: view_entity

Derive ODP Name

RSODP_ABAP_CDS_ODPNAME_LIST is a CDS View that provides data about "Derive ODP Name" in SAP S/4HANA. It reads from 7 data sources and exposes 17 fields with key field odpPrefix.

7 data source(s) 17 fields

Data Sources (7)

SourceAliasJoin Type
ddheadanno h1 left_outer
ddheadanno h2 left_outer
ddheadanno h3 left_outer
ddheadanno h4 left_outer
ddheadanno h5 left_outer
RSODP_ABAP_CDS_ODPNAME o from
ddddlsrc02bt t left_outer

Parameters (2)

NameTypeDefault
defaultCategory rodps_semantics
langu sylangu

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Derive ODP Name view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY odpPrefix
cdsViewName
ddlName RSODP_ABAP_CDS_ODPNAME ddlName
sourceType RSODP_ABAP_CDS_ODPNAME sourceType
devClass RSODP_ABAP_CDS_ODPNAME devClass
createdOnDate RSODP_ABAP_CDS_ODPNAME createdOnDate
changedAtDate RSODP_ABAP_CDS_ODPNAME changedAtDate
changedAtTime RSODP_ABAP_CDS_ODPNAME changedAtTime
changedBy RSODP_ABAP_CDS_ODPNAME changedBy
dataCategory
isQuery
valueFACTthenelseXendasrs_boolasisCube
isExtractor
isHidden
odpNameFendasrodps_odpnameasodpName
odpDescr
_changedBy RSODP_ABAP_CDS_ODPNAME _changedBy 
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Derive ODP Name'
define view entity RSODP_ABAP_CDS_ODPNAME_LIST
with parameters defaultCategory :rodps_semantics,
                langu :sylangu
as select from RSODP_ABAP_CDS_ODPNAME as o
left outer join ddheadanno as h1 on h1.strucobjn = o.cdsViewName and h1.name = 'ANALYTICS.DATACATEGORY'
left outer join ddheadanno as h2 on h2.strucobjn = o.cdsViewName and h2.name = 'OBJECTMODEL.DATACATEGORY'
left outer join ddheadanno as h3 on h3.strucobjn = o.cdsViewName and h3.name = 'ANALYTICS.QUERY'
left outer join ddheadanno as h4 on h4.strucobjn = o.cdsViewName and h4.name = 'ANALYTICS.DATAEXTRACTION.ENABLED'
left outer join ddheadanno as h5 on h5.strucobjn = o.cdsViewName and h4.name = 'ANALYTICS.HIDDEN'
left outer join ddddlsrc02bt as t on o.ddlName = t.ddlname and o.cdsViewName = t.strucobjn and t.ddlanguage = $parameters.langu and t.as4local = 'A'

{
  key cast( o.odpName as rodps_odpname ) as odpPrefix,
  cast(o.cdsViewName as ddstrucobjname ) as cdsViewName,
  o.ddlName,
  o.sourceType,
  o.devClass,
  o.createdOnDate,
  o.changedAtDate,
  o.changedAtTime,
  o.changedBy,
  coalesce( h1.value, h2.value ) as dataCategory,
  cast( case when h3.value is null or h3.value = 'false' then ' ' else 'X' end as rs_bool ) as isQuery,
  cast( case when h1.value is null then ' '
             when h1.value = '#FACT' then ' '
             else 'X'
        end as rs_bool ) as isCube,
  cast( case when h4.value is null or h4.value = 'false' then ' ' else 'X' end as rs_bool ) as isExtractor,
  cast( case when h5.value is null or h5.value = 'false' then ' ' else 'X' end as rs_bool ) as isHidden,
  cast( case when h3.value = '' or h3.value = 'true' then ''
             when h1.value is null and h2.value is null then $parameters.defaultCategory
             when h1.value is null and h2.value = '#TEXT'       then 'T'
             when h1.value is null and h2.value = '#HIERARCHY'  then 'H'
             when h1.value is null and h2.value = '#VALUE_HELP' then 'V'
             when h1.value = '#DIMENSION' then 'P'
             else 'F'
        end as rodps_semantics ) as semantics,
  cast( case when h3.value = '' or h3.value = 'true' then o.odpName
             when h1.value is null and h2.value is null then concat( o.odpName, concat( '$', $parameters.defaultCategory ) )
             when h1.value is null and h2.value = '#TEXT'       then concat( o.odpName, '$T' )
             when h1.value is null and h2.value = '#HIERARCHY'  then concat( o.odpName, '$H' )
             when h1.value is null and h2.value = '#VALUE_HELP' then concat( o.odpName, '$V' )
             when h1.value = '#DIMENSION' then concat( o.odpName, '$P' )
             else concat( o.odpName, '$F' )
        end as rodps_odpname ) as odpName,
  coalesce( t.ddtext, o.cdsViewName ) as odpDescr,
  o._changedBy as _changedBy
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RSODP_ABAP_CDS_ODPNAME",
"DDDDLSRC02BT",
"DDHEADANNO"
],
"ASSOCIATED":
[
"I_USER"
],
"BASE":
[
"RSODP_ABAP_CDS_ODPNAME"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More