demo_cds_sumdist

DDL: DEMO_CDS_SUMDIST SQL: DEMO_CDS_SUDI Type: view

demo_cds_sumdist is a CDS View in SAP S/4HANA. It reads from 1 data source (scarr) and exposes 4 fields with key fields mandt, carrname, distid.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
scarr s from

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName DEMO_CDS_SUDI view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY mandt scarr mandt
KEY carrname scarr carrname
KEY distid p distid
distance 
@AbapCatalog.sqlViewName: 'DEMO_CDS_SUDI'
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view demo_cds_sumdist(
    client,
    carrname,
    distid,
    sum_distance
  )
  as select from scarr as s
    join         spfli as p on s.carrid = p.carrid
{
  key s.mandt,
  key s.carrname,
  key p.distid,
      sum(p.distance)
}
group by
  s.mandt,
  s.carrname,
  p.distid
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SCARR",
"SPFLI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More