SAP Knowledge Base Article - Preview

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

Symptom

  • In a BW query, you want to display an amount value with currency dependent decimal places. E.g., in a structure element, a JPY amount value should be displayed with 0 decimal places and an EUR amount value with 2 decimal places.
  • You want to display a quantity value with unit dependent decimal places. For example, for a structure element, a ST quantity has 0 decimal places and a KG quantity has 3 decimal places.
  • However, in the query result all different currency or unit values of the same structure element display the same number of decimal places.


Read more...

Environment

  • SAP BW/4HANA All versions
  • SAP NetWeaver All versions

Product

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

Keywords

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 , BW4-AE-CORE , Core Services , BW-BEX-OT-OLAP , Analyzing Data , 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.