Create Simple View From Different Sources in SAP HANA

Creation of simple view from different sources

From R3 table : (ETL Based replication)

Create Data Store for SAP HANA (Target)

Create Data store for SAP R3 (source)

Import any table into SAP R3 data store (Required table)

Create project

Create batch job

Create workflow

Create dataflow {(Create ABAP data flow (Provide source data store

(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, take transport connection, in query transformation map all fields (if there is no primary key), data transport connection provide name for 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 to get table

(take from HANA Data store)

Right click on job and execute it.

SAP HANA Studio

After Successful execution go to HANA modeler (Studio)

Go to modeler quick launch

Click on SQL editor

Enter the Query

[Create Schema <schema name>]

Expand system catalogue (We have created target HANA table under system catalogue in Data Services)

Select our table, right click and select new view

In Right side will get table

Drag columns to column pane

Provide View name and our newly created catalogue and execute

Refresh our nerdy created catalogue and expand it

Under cataloger expand view and we will get newly created view.

Interested in mastering SAP HANA Training? Enroll now for FREE demo on SAP HANA Training.

Note:- If you want to export our view to client system in the form of CSR we can edit by selecting view preview

We can display in 2 ways

1) Tables

2) C ports

Right click an 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 value in a column

3) Analysis It displays data in the form of table or chrts based on selected Objects, filters in a Query.

Create IDT (Information design tool)

Create Project

Creation Relational connection

Select SAP

↓

SAP High performance Analytic Appliance

↓

ODBC

Provide username, password, ODBC connection for HANA

Test connect NEXT Finish.

After creating relation connection will get in the form of CNX

We need to public connection to a repository.

Provide password and publish will get connection in the form of cns

Create Data foundation

Take view from our catalogue and save it.

Create business layer

Select our data foundation

Publish our business layer to system repository

Create any report

Learn more about SAP HANA Interview Questions in this blog post.

From R3 Extractors

Create data store for SAP HANA (Target)

Create data store for SAP R3 (Source)

Import any extractor into SAP R3 data sore (required extractor)

Create Project create batch job create work flow

Create data flow {(Create ABAP dataflow (Provide source data store (SAP R3), ABAP program name, ABAP program file name, job

Name and ABAP dataflow name)}

In ABAP dataflow take our imported extractor from Our DST (R3 Data store), take Query transformation, take transport connection in query transformation map all fields (if there is no primary key), data transport connection provide name for transport connection file

In dataflow take Query transformation, connect Query transformation to ABAP dataflow map all fields whatever you want, map query transformation and target table (take from HANA Data store)

Right click on job and execute it

From flat file

Create file format for source file in DS (Source)

Create HANA data store for Target

Create Project

Create batch job

Create work flow

Create dataflow

Take file as source

Take Query transformation

Take Target table of HANA

Executive Project

SAP HANA Studio

Same as table

From SQL DB

Create Data store for SQL DB (Source), Import required table

Create data store for HANA DB (Target)

Create Project Create batch job Create workflow create dataflow Take SQL Table as source Take Query transformation

Take target table for HANA Data store

Execute Project

HANA STUDIO

Same as table

SAP BI TABLE

Create DST for B1/BW Data store (Source) Import required table

Create DST for HANA (Target)

Create Project Create Batch job Create workflow Create data flow {(Create ABAP dataflow (provide source DST (SAP B1/BW), ABAP program name,

ABAP program file name, job name and ABAP dataflow name)}

In ABAP data flow take Our Imported take from our Data Store, take Query transformation, take transport connection, in query transformation map all fields (if there is no primary key), data transport connection provide name for transport connection file.

In dataflow take Query transformation, connect Query transformation to ABAP dataflow map Query transformation and target table (take from HANA DST)

HANA Studio

Same as table