SAP Knowledge Base Article - Preview

2313517 - How to Set Currency or Unit Dependent Decimal in a BW Query


  • In a BW query, you want to display an amount value with currency dependent decimal places. That is: In a structure element, a JPY amount value gets 0 decimal, and an EUR amount value gets 2 decimal.
  • Or you want to display a quantity value with unit dependent decimal places. For example, for a structure element, a ST quantity gets 0 decimal, and a KG quantity gets 3 decimal.
  • However in the query result, all different currency or unit values of the same structure element display the same decimal places.



  • BW7.*


SAP NetWeaver 7.4


DECAN, ANDEC, MAX_PREC, DFLT_PREC, DDIC_DEF, quantity, rounding, decimals , KBA , BW-BEX-OT-OLAP-CUR , Translation of Currencies or Units , BW-BEX-OT-OLAP-UOM , Unit Convertion , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.