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