SAP HANA : Schemas in Detail : Types + Creation of Custom Schema in SAP HANA Studio
Вставка
- Опубліковано 15 жов 2024
- Video contains the complted information about SCHEMA's in SAP HANA.
In SAP HANA Schema's are of 3 types.
1. User Defined Schemas
2. System Defined Schemas
3. SLT Derived Schema
Also, in this video we will see how to create a User Defined Scheme using CREATE SCHEMA SQL command and also, how to GRANT necessary authorization to _SYS_REPO user.
Watch the video series to know more on SAP HANA..!!!
#iLearnSAPwithVENU #iLearnWithVENU #VenugopalMN #SchemaInHana #SAPHANA
VERY CLEAN AND CLEAR TEACHING, THANKS FOR UPLOADING THIS
Thank you Menda for your valuable feedback.
Great power of explanation
Glad you think so!
very nice and easily explained. very good for beginners
Thank you for your valuable feedback Ashish.
Crystal clear explanation..Thank you so much for sharing the knowledge with all of us.Please provide more videos on HANA Studio
Sure.
Neatly explained...Thank you so much
You are welcome
Thank you for the explanation. I have created a schema and given access to _SYS_REPO user. So, I am able to activate the Calculation view. But I am not able to preview the data. Could you please help me with this. Thanks.
Excellent!
Thanks for your message Asha.
I believe you do not have necessary authorisations to view the content of the table/hana CV. Please check with your security consultant.
@@ilearnsapwithvenu I bought Server access from outside for self-learn. The User ID which I am using is also used by others. I can preview the data of other's views which is in different package (using different schema' table) but I am not able to preview my view.
Hi can we say the schema is in hana like database in sql ?
Schema's are not database table. You can say it as a Main Folder. Under Main Folder, you can have many files (files are like tables).