This video is the third part of the discussion on table functions in Core Data Services (CDS) views in SAP HANA. It provides a deeper understanding of SQL code that is compatible inside the table function, including how to declare variables, use if-else conditions, and handle data.
After watching this video, you will learn:
– How to declare local variables inside the class method of a table function. The presenter demonstrates how to declare a variable and use it in a calculation. This is particularly useful when you want to perform calculations without creating a table.
– How to use SQL functions for data handling. This includes using the CASE statement to add values and change the format of date fields. The presenter shows how to use the CASE statement to check whether a date is greater than or equal to the current date and add a specific value based on the result.
– The concept of the DUMMY table in SQL. The DUMMY table can be used for any kind of calculations and is particularly useful when you want to perform calculations without creating a table.
– How to use the IF and CASE conditions in SQL. The presenter demonstrates how to create IF, ELSE, and ENDIF conditions in SQL. They show how to use these conditions to check the value of an input parameter and perform a specific action based on the result.
– The presenter also explains that the class and methods created for a table function cannot be tested in SE24, a transaction code in SAP GUI. This is because the class and methods are specifically designed for the table function and are not supported in SAP GUI syntax.
The video is practical and detailed, showing each step at the system level. It is intended for those who wish to learn about CDS Views and how to create and use them in HANA Studio and SAP systems.