Your screen will look like similar to below. Give the name and Description of your new analytic view. Right Click on your Package and select Newà Analytic View. Step by step process: We will create an Analytic View that will be based on sales table VBAK and VBAP. Make sure Sales order header and item tables VBAK and VBAP have been loaded into your HANA system. Make sure Currency Conversion related tables (TCUR*) are present in your schema and has data.Ģ. Prerequisite: Please check following points before you proceed for this scenario.ġ. Report should include following information. Now company has a reporting requirement where they want to see sales amount in Local Currencyand equivalent amount in Reporting Currency INR.
Below we will see step wise step how currency conversion takes place in SAP HANA.īusiness Scenario: A multinational manufacturing company headquartered in India has their sales order information in different currencies depending on country where sales order was created.
Sap hana studio label column software#
Similarly SAP HANA software is not an exceptional and it provides functionality for Currency conversion. Talking about some of software for currency conversion, SAP BPC provides currency conversion functionality using RATE application, SAP Integrated Planning (IP) provides standard function for currency conversion, SAP BW provides currency conversion functionality at transformation and reporting level. Introduction: Currency Conversion is an important aspect of any data modelling and reporting software. Various BW/BI, BPC and BOBJ implementation/Support projects.He has also worked in SAP HANA for POCs. Prakash Kumar Sahu is a SAP BI consultant with 6 years of SAP BI/BW experience andĬurrently working with Cognizant Technology Solutions(Pune/India). This article explains in detail how you can perform currency conversion in SAP HANA.Ĭompany: Cognizant Technology Solutions(Pune/India) I hope, this article will be useful for those consultants who are new to SAP HANA. Disclaimer: This article is completely based on my learning experience and your suggestions are most welcome.
0 kommentar(er)
