RSODP_ABAP_CDS_ODPNAME_ANNO

DDL: RSODP_ABAP_CDS_ODPNAME_ANNO Type: view_entity

Derive ODP Name

RSODP_ABAP_CDS_ODPNAME_ANNO is a CDS View that provides data about "Derive ODP Name" in SAP S/4HANA. It reads from 3 data sources (ddheadanno, ddddlsrc, tadir) and exposes 8 fields with key field cdsViewName.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
ddheadanno h inner
ddddlsrc s from
tadir t inner

Annotations (2)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY cdsViewName
ddlName ddddlsrc ddlname
sourceType ddddlsrc source_type
odpName
length
createdOnDate tadir created_on
changedAtDate ddddlsrc as4date
changedAtTime ddddlsrc as4time 
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Derive ODP Name'
define view entity RSODP_ABAP_CDS_ODPNAME_ANNO as 
select from ddddlsrc as s
inner join tadir as t on t.obj_name = s.ddlname 
inner join ddheadanno as h on s.ddlname = h.strucobjn
{
  key cast( s.ddlname as ddstrucobjname ) as cdsViewName,
  s.ddlname as ddlName,
  s.source_type as sourceType,
  cast( replace( upper( h.value ), '''', '') as rodps_odpname ) as odpName,
  length( h.value ) - 2  as length,
  @Semantics.systemDate.createdAt: true
  t.created_on as createdOnDate,
  @Semantics.systemDate.lastChangedAt: true
  s.as4date as changedAtDate,
  @Semantics.systemTime.lastChangedAt: true
  s.as4time as changedAtTime
} where t.pgmid = 'R3TR' and t.object = 'DDLS' and s.as4local = 'A' and s.source_type = 'W' and h.name = 'ANALYTICS.TECHNICALNAME'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDDDLSRC",
"DDHEADANNO",
"TADIR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More