rsodp_abap_cds_vte2stob

DDL: RSODP_ABAP_CDS_VTE2STOB SQL: RSODPABAPCDSVTE Type: view

ABAP CDS: SQL View + Struct Object including ana.techname

rsodp_abap_cds_vte2stob is a CDS View that provides data about "ABAP CDS: SQL View + Struct Object including ana.techname" in SAP S/4HANA. It reads from 2 data sources (RSODP_ABAP_CDS_VIEWE2STOB, ddheadanno) and exposes 4 fields with key field StructObjName.

Data Sources (2)

SourceAliasJoin Type
RSODP_ABAP_CDS_VIEWE2STOB a from
ddheadanno b left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName RSODPABAPCDSVTE view
ClientHandling.type #CLIENT_INDEPENDENT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label ABAP CDS: SQL View + Struct Object including ana.techname view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY StructObjName RSODP_ABAP_CDS_VIEWE2STOB StructObjName
ddlname RSODP_ABAP_CDS_VIEWE2STOB DDLName
SQLViewName RSODP_ABAP_CDS_VIEWE2STOB SQLViewName
valueendasrodps_odpnameasEntityTechname
@AbapCatalog.sqlViewName: 'RSODPABAPCDSVTE'
@ClientHandling.type: #CLIENT_INDEPENDENT
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'ABAP CDS: SQL View + Struct Object including ana.techname'
define view rsodp_abap_cds_vte2stob  as select from RSODP_ABAP_CDS_VIEWE2STOB as a
left outer join ddheadanno as b
 on a.StructObjName = b.strucobjn and
    b.name          = 'ANALYTICS.TECHNICALNAME'
{ key a.StructObjName as StructObjName,
      a.DDLName       as ddlname,
      a.SQLViewName   as SQLViewName,
      cast( case when b.value is null then a.SQLViewName
        when b.value = '' then a.SQLViewName
        else replace( upper( b.value ), '''', '')
      end as rodps_odpname ) as EntityTechname }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RSODP_ABAP_CDS_VIEWE2STOB",
"DDHEADANNO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/