SAP Knowledge Base Article - Public

3531058 - Problem with retrieving data from the S4 app through the CDS view I_FinTransFlow

Symptom

The fields payment amount in local currency and the local currency exchange rates is displayed 0.00 in the custom CDS view using the data source "I_FinTransFlow".

Environment

SAP S/4HANA Cloud Public Edition.

Reproducing the Issue

  1. Go to App Custom CDS Views.
  2. Press the create button to create a custom CDS View.
  3. In the data source provide the CDS View I_FinTransFlow.
  4. Go to the Elements tab.
  5. Include the fields "FinTransFlowLoclCrcyCnvrsnRate"(Local Currency Rates) and "FinTransFlowInLoCLCrcyPaytAmt"(Payment Amount in Local Currency) and any other required fields.
  6. Publish the custom CDS view.
  7. Preview the results.

Cause

View the currency exchange rates in the App Currency Exchange Rates. The exchange rates for the currency pair (foreign currency/local currency ex. USD/JPY) is not present in the system.

Resolution

The ask is to maintain currency exchange rates for the currency pair (ex. USD/JPY) on the cash flow dates and retry.

Keywords

I_FinTransFlow, FinTransFlowLoclCrcyCnvrsnRate, FinTransFlowInLoCLCrcyPaytAmt, USD/JPY, F3616, currency, exchange, rate, rates, 0.00, zero, no, conversion, in local, currency, amount, 0, custom, cds, view  , KBA , FIN-FSCM-TRM-2CL , Treasury and Risk Management (Public Cloud) , How To

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions