This blog is for those of us who have enrolled for the openSAP course but have not signed up for a AWS account yet (for reasons only know to us 😉 ) but still want to try out the practical work. I am not sure how much we would be able to accomplish this without having the delivery units based on which ‘Thomas Jung’ conducts the practical’s.
But for starters, I just tried out the basic exercise in Week 3 Unit 2, ‘Create an SQLScript Procedure With SELECT Statement’ in the Cloudshare HANA system, which is still in Rev 48, using the SFLIGHT data and it worked out good. Let’s just hope it works out for the rest of the course 🙂 .
Before you start make sure the system user that you have logged in has the following system privilege,
EXPORT (if you plan to export your models outside the system)
Once you have the data in your system, don’t forget to add the SFLIGHT schema to _SYS_REPO with SELECT grantable.
For our exercise let’s try a SELECT a few fields with INNER JOIN on the tables “SFLIGHT”.”SCITAIRP” and “SFLIGHT”.”SAIRPORT”
We can follow the same steps that Thomas shows us in the lecture for creating the .procedure file and table type, but instead use the following code:
I have not given here the code as text for a reason. There’s a lot I was able to learn even by typing the code word for word from Thomas’s presentation slides. Every mistake we make with syntax, spelling, commas adds something more to our knowledge when we correct it.
Here’s the output after the procedure is called,
I did face a few errors 😕 before I was able to see the result. I had an ‘insufficient privilege’ error because I had not added SFLIGHT schema to _SYS_REPO. Also I learnt that the fields declared in the table type should match the fields that are being selected in the SELECT statement (still not sure about this, correct me if I am wrong).
I will work on the other units as well and keep posting when I find time.
Try the exercises and do post your errors/feedbacks. Goodluck! 🙂 and ‘Like It’ if you like it 😆 .