Remote table not reflecting measures properly in SAP Datasphere

[aalbis]

Dear SAP colleagues,

We are facing an issue with one remote table in SAP Datasphere which is based on ICJRNLENTRITMDEX CDS View (Consolidation Group Journal Entry Item for Data Extraction).

The issue more exactly is with Amount in Local Currency/Amount in Transaction currency measures, but only for some specific currencies (JPY, VND, NTD). I suspect it might be because of the decimals, even though the same data type was reflected in SAP Datasphere while importing the remote table (DEC 23,2)

The amounts are reduced with 2 zeros. For example, 5.000.000 in source table in S/4 system is getting reflected as 50.000 in SAP Datasphere.

• SAP Datasphere

• Source CDS view

The data was replicated as snapshot.

Did anyone else faced this issue or is aware of any KBA?

Any input is welcomed.

Thank you!

[Martin_Kuma]

Hi,

In your CDS view you have to join with the TCURX and alter the value accordingly. 

These currencies have only 1 decimal place, instead of 3. This causes issues in change logs, etc. for example. You have to catch this in the CDS, or create a DB view and then redirect your CDS to that DB view. 

Cheers,

Martin 

[aalbis]

Hey Martin!

Thank you very much for your tips! It makes sense, although I was hoping for an actual fix like a KBA or something from SAP. We opened a ticket for this meanwhile as well.
What I noticed further is that the measures are affected when the data is pushed to the ODQ data units.
I am wondering if the issue relies somehow on the SAP HANA SDI subscriber.

Thank you again for taking from your time to give an advice!

Kind regards!