P_AR_ConversionFactors

DDL: P_AR_CONVERSIONFACTORS Type: view_entity CONSUMPTION Package: GLO_FIN_IS_VAT_AR

Argentina Exchange Rate Conversion Factors

P_AR_ConversionFactors is a Consumption CDS View that provides data about "Argentina Exchange Rate Conversion Factors" in SAP S/4HANA. It reads from 1 data source (I_ExchangeRateFactorsRawData) and exposes 5 fields with key fields ExchangeRateType, SourceCurrency, TargetCurrency. Part of development package GLO_FIN_IS_VAT_AR.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_ExchangeRateFactorsRawData ConversionFactors from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ExchangeRateType I_ExchangeRateFactorsRawData ExchangeRateType
KEY SourceCurrency I_ExchangeRateFactorsRawData SourceCurrency
KEY TargetCurrency I_ExchangeRateFactorsRawData TargetCurrency
ValidityStartDate I_ExchangeRateFactorsRawData ValidityStartDate
NumberOfTargetCurrencyUnits 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view entity P_AR_ConversionFactors
  as select from            I_ExchangeRateFactorsRawData as ConversionFactors

    left outer to many join I_ExchangeRateFactorsRawData as ConversionFactorNextFromDate on  ConversionFactors.ExchangeRateType  = ConversionFactorNextFromDate.ExchangeRateType
                                                                                         and ConversionFactors.SourceCurrency    = ConversionFactorNextFromDate.SourceCurrency
                                                                                         and ConversionFactors.TargetCurrency    = ConversionFactorNextFromDate.TargetCurrency
                                                                                         and ConversionFactors.ValidityStartDate < ConversionFactorNextFromDate.ValidityStartDate

{
  key ConversionFactors.ExchangeRateType,
  key ConversionFactors.SourceCurrency,
  key ConversionFactors.TargetCurrency,

      ConversionFactors.ValidityStartDate,

      min(
        case
          when ConversionFactorNextFromDate.ValidityStartDate is null
            then '99991231'
          else dats_add_days(ConversionFactorNextFromDate.ValidityStartDate,-1,'INITIAL')
        end )                                            as ValidityEndDate,

      min(ConversionFactors.NumberOfTargetCurrencyUnits) as NumberOfTargetCurrencyUnits

}
group by
  ConversionFactors.ExchangeRateType,
  ConversionFactors.SourceCurrency,
  ConversionFactors.TargetCurrency,
  ConversionFactors.ValidityStartDate

Learn More