P_PE_PurLdgrAltExchRateType

DDL: P_PE_PURLDGRALTEXCHRATETYPE Type: view_entity CONSUMPTION Package: GLO_FIN_IS_PE

Purchase Ledger Alternative Exchange Rate Type

P_PE_PurLdgrAltExchRateType is a Consumption CDS View that provides data about "Purchase Ledger Alternative Exchange Rate Type" in SAP S/4HANA. It reads from 2 data sources (I_ExchangeRate, I_ExchangeRateFactorsRawData) and exposes 5 fields with key fields ExchangeRateType, SourceCurrency, TargetCurrency. Part of development package GLO_FIN_IS_PE.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_ExchangeRate ExchangeRate inner
I_ExchangeRateFactorsRawData ExchangeRateFactor from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ExchangeRateType I_ExchangeRateFactorsRawData ExchangeRateType
KEY SourceCurrency I_ExchangeRateFactorsRawData SourceCurrency
KEY TargetCurrency I_ExchangeRateFactorsRawData TargetCurrency
AlternativeExchangeRateType I_ExchangeRateFactorsRawData AlternativeExchangeRateType
ExchangeRateEffectiveDate I_ExchangeRate ExchangeRateEffectiveDate 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM: {
  private: true,
  viewType: #CONSUMPTION
}
define view entity P_PE_PurLdgrAltExchRateType 
  as select from I_ExchangeRateFactorsRawData as ExchangeRateFactor
    inner join   I_ExchangeRate               as ExchangeRate on  ExchangeRate.ExchangeRateType                  =  ExchangeRateFactor.AlternativeExchangeRateType
                                                              and ExchangeRate.SourceCurrency                    =  ExchangeRateFactor.SourceCurrency
                                                              and ExchangeRate.TargetCurrency                    =  ExchangeRateFactor.TargetCurrency
                                                              and ExchangeRateFactor.AlternativeExchangeRateType <> ''
{
  key ExchangeRateFactor.ExchangeRateType,
  key ExchangeRateFactor.SourceCurrency,
  key ExchangeRateFactor.TargetCurrency,
  
      ExchangeRateFactor.AlternativeExchangeRateType,
      ExchangeRate.ExchangeRateEffectiveDate
}

Learn More