SAP Knowledge Base Article - Preview

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.
  • 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.



SAP NetWeaver 7.4 and above


SAP BW/4HANA all versions ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5


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.