I_CURRENCYTEXT

CDS View

Currency Text

I_CURRENCYTEXT is a CDS View in S/4HANA. Currency Text. It contains 5 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 5 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
A_CnsldtnGroupCurrencyT view from COMPOSITE Consolidation Group Currency - Text
A_CnsldtnLocalCurrencyT view from BASIC Local Currency - Text
A_CnsldtnTransCurrencyT view from COMPOSITE Transaction Currency - Text
C_Currencytextvhtemp view from CONSUMPTION Currency Value Help Text
C_CurrencyValueHelp view from CONSUMPTION Currency Value help
Tddl_Api_Union_With_Assoc_Defs view from Test object
Tddl_Api_Union_With_Assoc_Defs view union_all Test object

Fields (5)

KeyField CDS FieldsUsed in Views
KEY Currency Currency 2
KEY Language Language 2
_Currency _Currency 1
CurrencyName CurrencyName 2
CurrencyShortName CurrencyShortName 2 
@EndUserText.label: 'Currency Text'
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'Currency'
@Analytics.dataExtraction.enabled: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IFICURRENCYTEXT'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Search.searchable: true

define view I_CurrencyText
  as select from tcurt

  association[1..1] to I_Currency as _Currency
    on $projection.Currency = _Currency.Currency
  association[0..1] to I_Language as _Language
    on $projection.Language = _Language.Language
{
    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_Language'
    key spras as Language,
    _Language,

    @Semantics.currencyCode: true
    @ObjectModel.foreignKey.association: '_Currency'
    key waers as Currency,
    _Currency,

    @Semantics.text: true
    @Search.defaultSearchElement: true
    @Search.ranking: #HIGH
    @Search.fuzzinessThreshold: 0.8
    
    cast(ltext as ltext_cds preserving type) as CurrencyName,

    @Semantics.text: true
    ktext as CurrencyShortName


};
      
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TCURT"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_LANGUAGE"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More