HAHA学院(7)--01在HANA Studio中货币转换
来源:互联网 发布:没有好奇心 知乎 编辑:程序博客网 时间:2024/05/01 18:24
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
- HAHA学院(7)--01在HANA Studio中货币转换
- HANA学院(7)-02使用HANA Studio在属性视图中创建一个层次结构
- HANA学院(07) - (04)在HANA Studio中使用ABC分类功能
- HANA学院(7)- (5)从SAP HANA Studio连接到SAP HANA
- HANA学院(7)-03 使用SAP HANA Studio中的Explain Plan
- HANA 创建Triggers在SAP HANA Studio
- HANA学院(04)-其他相关视频教程-01 SAP HANA建模练习
- HANA学院(05)_- SAP HANA分析基础使用-01SAP BusinessObjects Explorer
- 如何在Excel或sqlserver中写用户函数实现数字货币向英文转换集锦
- 货币转换
- 货币转换
- 货币转换
- SAP HANA Studio 2
- HANA STUDIO常用快捷键
- HANA学院(3)-Create(创建)
- haha
- haha
- haha
- C++ 的输入输出
- 人脸检测--基于Adaboost算法的实现
- 数据挖掘十大经典算法
- 大话设计模式c++实现之一 简单工厂模式
- PrepareStatement 中in like的用法
- HAHA学院(7)--01在HANA Studio中货币转换
- 给id那个一个数组,请调整数组中数的顺序,使得所有奇数位于数组的前半部分,所有偶数位于数组的后半部分。
- jquery刷新页面
- Android Google开源库——Volley的简单使用
- 机器学习9
- Python快速入门
- 如何通过实现parcelable接口传递值对象
- 1040 最大公约数之和 (STL)
- kepware 发生 Setup was unable to initialize your PC错误解决办法