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 for Me (Login required).

Search for additional results

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