Create a Data Store for SAP HANA (Target)
Create Datastore for SAP R3 (source)Import any table into the SAP R3 data store (Required table)
Create a project
Create a batch job
Create workflow
Create dataflow {(Create ABAP data flow (Provide source datastore
(SAPR3), ABAP program name, ABAP program file name, Job name, and ABAP dataflow name)}
In ABAP dataflow take our imported table prom our data store (R3 DST) take query transformation, and take transport connection, in query transformation map all fields (if there is no primary key), data transport connection provides a name for the transport connection file
In data files take Query transformation, connect Query transformation to ABAP dataflow map all fields whatever you want, map Query transformation, and get a table
(take from HANA Datastore)
Right-click on the job and execute it.
After Successful execution goes to the HANA modeller (Studio)
Go to modeller quick launch
Click on SQL editor
Enter the Query
[Create Schema <schema name>]
Expand system catalog (We have created a target HANA table under the system catalog in Data Services)
Select our table, right-click and select a new view
On the Right side will get a table
Drag columns to the column pane
Provide View name and our newly created catalog and execute
Refresh our nerdy-created catalog and expand it
Under the cataloger expand the view and we will get a newly created view.
Note:
If you want to export our view to the client system in the form of CSR we can edit by selecting view preview
We can display this in 2 ways
1) Tables
2) C ports
Right-click a view
Select Open data preview
Will get data in 3 ways
1) Raw Data Will get data in the form of tables
2) Distinct Values It retrieves distinct values in a column
3) Analysis It displays data in the form of tables or charts based on selected Objects, and filters in a Query.
If you want to enrich your career and become a professional in SAP Hana, then visit Tekslate - a global online training platform: "SAP Hana Administration Training" This course will help you to achieve excellence in this domain |
Create an IDT (Information design tool)
Create a Project
Creation Relational connection
Select SAP
SAP High-performance Analytic Appliance
ODBC
Read these latest SAP HANA Interview Questions that help you grab high-paying jobs! |
It is a web-based environment that allows business users to upload data into the SAP HANA database and create information views
URL: http://sysname.domain.com:8090/ic/
It is used to create calculated views
It creates information views by using Excel files Attribute view Analytic view and Calculated view
In Information Composer, we need to upload data from a client system in the form of .xls, .xlsx, and .csv Compose the data: In composing we can combine two different databases by using joins and unions
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
1/15
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox