CdsFrwk_Spcl_Functions

DDL: CDS_WITH_SPCL_FUNCTIONS SQL: CdsFrwk_DEMO_13 Type: view

cds having currency and unit conversion

CdsFrwk_Spcl_Functions is a CDS View that provides data about "cds having currency and unit conversion" in SAP S/4HANA. It reads from 2 data sources (sflight, spfli) and exposes 2 fields.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
sflight sflight from
spfli spfli inner

Parameters (1)

NameTypeDefault
to_currency abap.cuky( 5 )

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName CdsFrwk_DEMO_13 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label cds having currency and unit conversion view

Fields (2)

KeyFieldSource TableSource FieldDescription
amount sflight price
distance spfli distance 
@AbapCatalog.sqlViewName: 'CdsFrwk_DEMO_13'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'cds having currency and unit conversion'
define view CdsFrwk_Spcl_Functions
  with parameters
    to_currency : abap.cuky( 5 )
  as select from sflight
    inner join   spfli on sflight.carrid = spfli.carrid
{
  sflight.price  as amount,
  spfli.distance as distance,

  currency_conversion(
      amount => price,
      source_currency => currency,
      target_currency => :to_currency,
      exchange_rate_date => fldate
  )              as cnv_amount_1,

  currency_conversion(
      amount => price,
      source_currency => :to_currency,
      target_currency => cast( 'USD' as abap.cuky( 5 )),
      exchange_rate_date => fldate,
      decimal_shift =>  'X',
      error_handling => 'SET_TO_NULL'
  )              as cnv_amount_2,

  unit_conversion(  
    quantity => spfli.distance,
    source_unit => spfli.distid,
    target_unit => cast( 'KM' as abap.unit( 3 ))
  )              as cnv_distance

}          
where spfli.distid = 'MI'                    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SFLIGHT",
"SPFLI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More