Joins In SAP HANA

• 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

Inclined to build a profession as SAP HANA Developer? Then here is the blog post on, explore SAP HANA Training

Union

• In Union will get the source field to 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.

SAP HANA Tutorials

Calculated View with Script: Create package Create a calculated view with script Provide script, in script block Add & provide columns name & type that will act 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 in-depth knowledge on SAP HANA, click on below

• Performance Tuning in SAP HANA
• Security in SAP HANA
• Organizing system Landscapes in SAP Hana
• Analytical Privileges in SAP HANA
• Security in SAP HANA
• SAP HANA Views