CDS_WITH_SCALAR_FUNCTION

DDL: CDS_WITH_SCALAR_FUNCTION Type: view_entity Package: SABP_UNIT_DOUBLE_CDS_DEMO

CDS view with cds scalar functions

CDS_WITH_SCALAR_FUNCTION is a CDS View that provides data about "CDS view with cds scalar functions" in SAP S/4HANA. It reads from 1 data source (sflight) and exposes 9 fields with key fields Carrid, Connid, Fldate. Part of development package SABP_UNIT_DOUBLE_CDS_DEMO.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
sflight sflight from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS view with cds scalar functions view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Carrid carrid
KEY Connid connid
KEY Fldate fldate
Seatsmax seatsmax
Seatsocc seatsocc
SeatsmaxB seatsmax_b
Greeting
decfloat34asEconomy_Occupancy_ratio
decfloat34asBusiness_Occupancy_ratio 
@AbapCatalog.viewEnhancementCategory: [ #NONE ]

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'CDS view with cds scalar functions'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: { serviceQuality: #X, sizeCategory: #S, dataClass: #MIXED }

define view entity CDS_WITH_SCALAR_FUNCTION
  as select from sflight

{
  key carrid                                                                  as Carrid,
  key connid                                                                  as Connid,
  key fldate                                                                  as Fldate,

      seatsmax                                                                as Seatsmax,
      seatsocc                                                                as Seatsocc,
      seatsmax_b                                                              as SeatsmaxB,
      DEMO_CDS_SCALAR_HELLOWORLD()                                            as Greeting,

      DEMO_CDS_DECFLOAT_RATIO(portion => cast(seatsocc as abap.decfloat34),
                              base    => cast(seatsmax as abap.decfloat34)) as Economy_Occupancy_ratio,
                              
      DEMO_CDS_DECFLOAT_RATIO(portion => cast( seatsocc_b as abap.decfloat34),
                              base    => cast(seatsmax_b as abap.decfloat34)) as Business_Occupancy_ratio
}

Learn More