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

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

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

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