2476282 - Incorrect amount decimal in a query built on HCPR using HANA view for currency JPY, HUF, etc

• A currency is set as CURRDEC<>2  in table TCURX. Such as JPY, TWD, HUF, KRW, COP, etc.
• A HANA view contains amount values in this currency. For example: 1.23 JPY. The table used in the hana view could be an ERP (R/3) table contains some transaction data.
• An HCPR is build on the HANA view.
• A query is built on the HCPR and display the amount value in query result.
• When run the query, you get 1 JPY instead of 1.23 JPY or 123 JPY.

BW 7.4 above

JPY, HUF, COP, KRW, TWD, internal/external format conversion, TCURX, EXT, INT, JOD, CLP, OMR, IDR , KBA , BW-BEX-OT-HCPR , CompositeProvider Query , How To