• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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 Screenshot_24{(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            Screenshot_24Will get data in the form of tables

2) Distinct Values  Screenshot_24It retrieves distinct value in a column

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

BD

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   Screenshot_24  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 ProjectScreenshot_24 create batch jobScreenshot_24 create work flow

Create data flowScreenshot_24 {(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

BO

Same as table

Information Compares

It is a web based environment which allows business users to upload data into SAP HANA data base 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

Which is coming from HANA DB

In Information composer we need upload data from client system in the form of .xls, .xlsx, and .csv

Compose the data:

In compose we can combine two different databases by using joins and unions

For an Indepth knowledge on SAP HANA, click on below

Summary
Review Date
Reviewed Item
Create Simple View From Different Sources in SAP HANA
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Create Simple View From Different Sources in SAP HANA"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.