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

Joins and Unions in SAP HANA

Join

To join multiple views, tables, projections

Here we must join two tables which inner join, outer join

And we need to provide cardinalities

Sclera we can create new columns and visible

Union

In Union will get source field pave and target field pave

Select columns for output pave drag them into target pave and map source fields and target fields

And we can map multiple source fields in single target fields

Whatever we take columns in target pave will get those objects in output stricture

And classify objects as attributes, measures.

These core tutorials will help you to learn the Joins and Unions in SAP HANA. For an in-depth understanding and practical experience,  explore SAP HANA Training Material PDF.

Calculated View with Script

Create package

Create calculated view with script

Provide script, in script block

Add & provide columns name & type that will be acts as output for output structure

Connect our script component to output component in fist screen

Classify attributes & measures’ in Output component and activate

Note:-

For this view, we used to at least cue measure

For an Indepth knowledge on SAP HANA, click on below

Summary
Review Date
Reviewed Item
Joins and Unions 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 Joins and Unions in SAP HANA"

    Leave a Message

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

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.