I_CURRENCY

CDS View

Currency

I_CURRENCY is a CDS View in S/4HANA. Currency. It contains 6 fields. 45 CDS views read from this table.

Used by 45 CDS view(s) 6 fields

CDS Views using this table (45)

ViewTypeJoinVDMDescription
A_CnsldtnGroupCurrency view from COMPOSITE Consolidation Group Currency
A_CnsldtnTransactionCurrency view from COMPOSITE Transaction Currency
C_BadDebtReserveCurrencyVH view from CONSUMPTION Display Currency
C_CN_TaxCurrency view from CONSUMPTION China Tax Currency
C_ConditionRateValueUnit_VH view from CONSUMPTION Condition Rate Value Unit Value Help
C_CshBkChrgAcctISOCrcyCodeVH view_entity from CONSUMPTION Cash Bank Charge Account Currency ISO Code
C_Currencyvhtemp view from CONSUMPTION Value Help for Purchase Order Currency
C_DbtflAcctsValnCurrencyVH view from CONSUMPTION DAV Display Currency
C_FxdAstOvwDisplayCurrencyVH view from CONSUMPTION Display Currency Value Helper
C_InfoRecordManageCrcyVH view from CONSUMPTION Value Help Currency for Info Record Manage App
C_PricingElement view left_outer CONSUMPTION Consumption View for Pricing Element
C_PurOrdMaintainCrcyValHelp view from CONSUMPTION PO Maintenance: Value Help for Currency
C_RealTimeWrkInProcCurrencyVH view from CONSUMPTION Display Currency
C_RevnVarDspCrcyVH view from CONSUMPTION Value help for Display Currency
C_SalesInsightCrcyVH view from CONSUMPTION Sales Insight: Currency Value Help
C_ShrtTrmCshPosActualFlow view cross CONSUMPTION Overdue Actual Flows
C_ShrtTrmCshPosLatestBalance view cross CONSUMPTION Latest Balance of Bank Account
FTR_PAYMENT_REASON_SA_SOURCE view_entity from SubVal Payment Reason Source
FTR_PAYMENT_REASON_SOURCE view_entity from SubVal Payment Reason Source
FTR_PAYMENT_REASON_TARGET view_entity from SubVal Payment Reason Source
I_BalanceSheetExposure view from COMPOSITE Balance Sheet Exposure
I_CurrencyPairMDVH view inner COMPOSITE Currency Pair Value Help
I_CurrencyPairMDVH view from COMPOSITE Currency Pair Value Help
I_CurrencyStdVH view from COMPOSITE Currency
I_DigitalVehicleCurrency view_entity from BASIC Digital Vehicle Currency
I_FinancialStatusCube view_entity from COMPOSITE Financial Status Cube
I_FixedAssetTaxItem view left_outer COMPOSITE Tax Items for Fixed Asset
I_HistFinancialStatusCube view_entity from COMPOSITE Financial Status Cube by Period
P_RU_InvoiceJournal5 view left_outer CONSUMPTION
P_TW_TaxItemConsume view left_outer CONSUMPTION Private Consumption View for TAX ITEM
SEPM_C_RAMP_Currency view from Currency
SEPMRA_C_CurrencyValueHelp view from Currency
SEPMRA_C_PO_Currency view from Currency
TRAC_ACCNT_KEYFIG_SOURCE view_entity from Additional Account Assignment Source
TRAC_ACCNT_KEYFIG_TARGET view_entity from Additional Account Assignment Target
TRAC_ADTL_COMMON view from Common Data
TRAC_ADTL_EX_BUSINESS_PARTNER view from Business Partner
TRAC_ADTL_EXP_MASTER_DATA view from Master Data
TRAC_ADTL_EXP_MISC view from Miscellaneous Data
TRAC_ADTL_OC_BUSINESS_PARTNER view from Business Partner
TRAC_ADTL_OC_MASTER_DATA view from Master Data
TRAC_ADTL_OC_MISC view from Miscellaneous Data
TRAC_ADTL_SE_BUSINESS_PARTNER view from Business Partner
TRAC_ADTL_SE_MASTER_DATA view from Master Data
TRAC_ADTL_SE_MISC view from Miscellaneous Data

Fields (6)

KeyField CDS FieldsUsed in Views
KEY Currency CashPositionDisplayCurrency,ConditionRateValueUnit,Currency,DisplayCurrency,SourceCurrency,TargetCurrency 8
KEY CurrencyISOCode Code,CurrencyISOCode 2
_Text _Text 2
AlternativeCurrencyKey AlternativeCurrencyKey 1
Decimals Decimals 1
IsPrimaryCurrencyForISOCrcy IsPrimaryCurrencyForISOCrcy 1 
@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