HAHA学院(7)--01在HANA Studio中货币转换

1. SAP HANA Studio里的货币转换

1.1 standard sap table regarding currency

TCURR: Exchange reates

TCURV: Exchange rate types for currency translation

TCURF: Conversion Factors

TCURN: Quatations

TCURX: Currency Decimals

1.2 create a analytic view with fixed currency

1.2.1 add 'gross_amount' as measure and rename it as 'gross_amount_eur', change its measure type as "amount with currency" and currency: "ERU"

1.2.2 add 'gross_amount' as measure and rename it as 'gross_amount_usd',change its measure type as "amount with currency" and currency: "USD", input conversion parameter.

1.2.3 activate the analytic view

1.3 variable currency

1.3.1 add PO ID and  CURRENCY_CODE as the attribute,  add gross amount as measure

1.3.2 change the gross amount to gross_amount_base, measure type: amount with currency, currency: attribute- currency code

add gross amount as measure and change it to gross_amount_usd

apply a filter

apply  filter during selection