3345843 - Custom CDS View is showing incorrect values for currency amount - SAP S/4HANA Cloud

When previewing the Custom CDS View and the amount shown for a specific column is incorrect because it's shown with decimals or with a different ratio.

For example: In the Purchase Order app, the price of Item XX should be 4000 TWD. However, when viewing it in the Custom CDS View, the amount is 40 instead of 4000.

SAP S/4HANA Cloud

1. Go to Custom CDS Views app.
2. Open the Custom CDS View.
3. Click on "Preview".

For historical reasons, SAP stores most of the amounts with two decimals in the database, independent of the actual number of decimals maintained for the currency.

As Custom CDS Views are supposed to be used in other tools, the values shown in the Data Preview are the raw line item data.

When using the Custom CDS View in standard consumption channels, for example OData and Custom Analytical Queries, an output conversion is applied that shifts the decimals according to the currency and the report is shown as expected with the correct amount. This means that when using the Custom CDS View, the conversion will take place and the amount will be as expected.

It's possible to have a report using this Custom CDS View, by creating a Custom Analytical Query or expose it as External API. 

SAP Help Portal | How to Create Custom Queries

SAP Help Portal | External API: Exposing a Custom CDS View as OData API

preview, Custom CDS View, amount, incorrect, decimals, ratio, price, currency , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem

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