I_Currency

DDL: I_CURRENCY SQL: IFICURRENCY Type: view BASIC

Currency

I_Currency is a Basic CDS View (Dimension) that provides data about "Currency" in SAP S/4HANA. It reads from 2 data sources (tcurc, tcurx) and exposes 6 fields with key field Currency. It has 1 association to related views.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
tcurc tcurc from
tcurx tcurx left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CurrencyText _Text $projection.Currency = _Text.Currency

Annotations (9)

NameValueLevelField
EndUserText.label Currency view
ObjectModel.representativeKey Currency view
ObjectModel.sapObjectNodeType.name Currency view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFICURRENCY view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Currency tcurc waers
_Text _Text
Decimals
CurrencyISOCode
AlternativeCurrencyKey
IsPrimaryCurrencyForISOCrcy tcurc xprimary 
@EndUserText.label: 'Currency'
@ObjectModel.representativeKey: 'Currency'
@ObjectModel.sapObjectNodeType.name: 'Currency' 
@Analytics: {dataCategory: #DIMENSION, dataExtraction.enabled: true}
@VDM.viewType: #BASIC 
@AbapCatalog.sqlViewName: 'IFICURRENCY'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Search.searchable: true

define view I_Currency 
  as select from tcurc
  left outer join tcurx on tcurc.waers = tcurx.currkey
  
  association [0..*] to I_CurrencyText as _Text 
    on $projection.Currency = _Text.Currency
{
    
    @Semantics.currencyCode: true
    @ObjectModel.text.association: '_Text' 
    key tcurc.waers as Currency,
    _Text,
    
    cast(COALESCE(tcurx.currdec, 2) as currdec_cds) as Decimals,
           
    @Search.defaultSearchElement: true
    @Search.ranking: #HIGH
    @Search.fuzzinessThreshold: 0.8
    cast(tcurc.isocd  as isocd_cds) as CurrencyISOCode,
    cast(tcurc.altwr  as altwr_cds) as AlternativeCurrencyKey,
    tcurc.xprimary    as IsPrimaryCurrencyForISOCrcy
       
};             
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"TCURC",
"TCURX"
],
"ASSOCIATED":
[
"I_CURRENCYTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More