C_CurrencyRateCalculation

DDL: C_CURRENCYRATECALCULATION SQL: CRCYRATECALC Type: view CONSUMPTION

Currency Exchange Rate Calculation

C_CurrencyRateCalculation is a Consumption CDS View that provides data about "Currency Exchange Rate Calculation" in SAP S/4HANA. It reads from 1 data source (I_Language) and exposes 2 fields with key field TargetCurrency.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_Language I_Language from

Parameters (5)

NameTypeDefault
P_Date sydatum
P_SAPClient symandt
P_SourceCurrency vdm_v_display_currency
P_TargetCurrency vdm_v_display_currency
P_AmountInSourceCurrency fis_revenue_hsl_p

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CRCYRATECALC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Currency Exchange Rate Calculation view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY TargetCurrency
trueasRecalculatedAmountInTargetCrcy 
@AbapCatalog.sqlViewName: 'CRCYRATECALC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel: {
    usageType: {
        dataClass: #MIXED,
        serviceQuality: #B,
        sizeCategory: #S
    }
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Currency Exchange Rate Calculation'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
define view C_CurrencyRateCalculation 
with parameters @Consumption.hidden: true
                @Environment.systemField: #SYSTEM_DATE
                P_Date : sydatum,
                @Consumption.hidden: true
                @Environment.systemField: #CLIENT
                P_SAPClient : symandt,
                P_SourceCurrency : vdm_v_display_currency,
                P_TargetCurrency : vdm_v_display_currency,
                P_AmountInSourceCurrency : fis_revenue_hsl_p 
                
as select from I_Language 
{    
        @Semantics.currencyCode: true
 key    :P_TargetCurrency as TargetCurrency,
       
        @Semantics.amount.currencyCode: 'TargetCurrency'     
        currency_conversion(
            client => :P_SAPClient,
            amount => :P_AmountInSourceCurrency,
            source_currency => :P_SourceCurrency, 
            target_currency => :P_TargetCurrency,
            exchange_rate_date => :P_Date,
            exchange_rate_type => 'M', 
            round => #CDSBoolean.true,
            decimal_shift => #CDSBoolean.true,
            decimal_shift_back => #CDSBoolean.true
        ) as RecalculatedAmountInTargetCrcy
}
where I_Language.Language = $session.system_language

Learn More