DEMO_CDS_DATA_SOURCE

DDL: DEMO_CDS_DATA_SOURCE Type: view_entity

CDS view entity data source example

DEMO_CDS_DATA_SOURCE is a CDS View that provides data about "CDS view entity data source example" in SAP S/4HANA. It reads from 2 data sources (scarr, Demo_Cds_Param_View_Entity) and exposes 9 fields with key fields carrid, connid.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
scarr _source2 inner
Demo_Cds_Param_View_Entity Demo_Cds_Param_View_Entity from

Annotations (1)

NameValueLevelField
EndUserText.label CDS view entity data source example view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY carrid source1 carrid
KEY connid source1 connid
cityfrom source1 cityfrom
cityto source1 cityto
distance source1 distance
distid source1 distid
carrname scarr carrname
currcode scarr currcode
url scarr url 
@EndUserText.label: 'CDS view entity data source example'
define view entity DEMO_CDS_DATA_SOURCE
  as select from Demo_Cds_Param_View_Entity
                 ( p_distance_l:12, p_distance_u:23, p_unit:'kms' ) 
                                           as source1
    inner join   scarr                     as _source2
      on source1.carrid = _source2.carrid
  {       
    key source1.carrid,
    key source1.connid,
        source1.cityfrom,
        source1.cityto,
        source1.distance,
        source1.distid,
        //scarr

        _source2.carrname,
        _source2.currcode,
        _source2.url
  }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DEMO_CDS_PARAM_VIEW_ENTITY",
"SCARR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More