Symptom
- 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.
- A HCPR is built on the HANA view.
- A Query is built on the HCPR and display the amount value in Query result.
- When running the Query, 1 JPY is returned instead of 1.23 JPY or 123 JPY.
Read more...
Environment
SAP NetWeaver 7.4 and above
Product
SAP BW/4HANA all versions ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5
Keywords
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
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.