SAP HANA HDB Stored Procedure – Part 1 Welcome to then next SAP HANA HDB Stored Procedure tutorial. I hope the tutorials up until now were clear enough and you now have a solid foundation in HANA. In this tutorial, we learn another important concept of Stored procedures. This tutorial explains how to create an […]
Category Archives: HANA SQL Script
HANA SQL Script
The SAP HANA database uses SQL (Structured Query Language) for it’s developments. This section includes beginner level trainings on HANA SQL Script.
Usage of Table Functions in HANA – Part 2
SAP HANA Table function – Calculation View Wrap This tutorial is a continuation of the SAP HANA Table Function Part-1 tutorial. Please read it first if you have directly landed on this page. To be used further, SAP HANA table functions need to be wrapped around SAP HANA graphical calculation views graphical calculation view . […]
Table Functions with Input Parameters – Part 3
SAP HANA Table Function linking with Calculation view Input Parameters This tutorial is a continuation of the SAP HANA Table Function Part-1 tutorial and Part-2 tutorial. Please read them first if you have directly landed on this page. SAP HANA Table function (Contd..) To understand how input parameters work with an SAP HANA table function, we […]
Table Functions in SAP HANA – Part 1
SAP HANA Table Functions Welcome to the SAP HANA Table Functions tutorial. SAP HANA Table functions replace Scripted Calculation views as the recommended development artifact whenever the graphical views are not enough to implement a technical requirement. Let’s start off with a simple scenario to build a table function that provides the Client(field MANDT) and […]
Analysis on Calculation View – Part 2
Analyzing the SAP HANA Calculation View Execution Part – 2 This is the continuation of Part-1 of the SAP HANA Calculation view execution analysis tutorial. If you have reached this tutorial and haven’t read Part-1 – click here to go back. Note: If you have reached this page instead to learn how to create a […]
Analysis on Calculation View – Part 1
Analyzing the SAP HANA Calculation View Execution Part – 1 Welcome everyone again to the our next tutorial. In this one, we try to understand where these a calculation view is stored and how they get executed during the data preview functionality. Things will become cleared as we progress in this tutorial. Note: If you […]
SAP HANA Scripted Calculation View-Input Parameters
SAP HANA Scripted Calculation View input parameters Welcome again to our next tutorial. You’ve already learn about dynamic filtering on the output of a calculation view using variables in our previous tutorial. This tutorial deals with another type of dynamic filtering – SAP HANA Scripted Calculation view input parameters. These dynamic filters, based on user […]
SAP HANA Scripted Calculation View -Variables
SAP HANA Scripted Calculation View variables Welcome to the new tutorial on SAP HANA scripted calculation view variables. When the filters need to be applied after the end of execution of the entire logic in a dynamic manner, variables are used. This means that when you apply a variable filter on a field, there will be […]
SAP HANA Scripted Calculation View – Filters
SAP HANA Scripted Calculation View Filters Welcome again to the next SAP HANA Scripted Calculation View tutorial series. In this one, we learn how to use SAP HANA Calculation view filters, SAP HANA Variables and SAP HANA Input Parameters. This is the first tutorial in this series and will focus just on SAP HANA Calculation […]
SAP HANA Scripted Calculation View Step 3
SAP HANA Scripted Calculation View – Part 3 In real time projects, usually this scripted calculation view is the base for building reports. The reporting team can have a hard time understanding these field names. To be honest the HANA development team wouldn’t know the descriptions of most of them too. Before we start, as a […]