What a beautiful experience to learn from you, Sir! You are really a giant of all time and I am sure your tutorials are certainly not meant for beginners at all. I mean as learning is a lifetime process, all the experienced candidates in the field of ABAP must be referring these nice videos for their clarity and better understanding. Hats off Rahul Sir.
Hi sir, i did handson for the view.. if i do projection view on a db table it is not showing contents.. bt in status bar, it is showing no database table exists for the view-name.. though i gave tablename and selected the field from table to display
Yes. We need to write a query to display the data from projection view. Once you move on to upcoming playlists, you can write a query to display the data from the projection view.
Hi rahul, One question. What is the actual use of the database view. We can write this joins in code also right . Also apart from being able to view the values in se11. What difference or benefit do we get from creating a database view
When we create database view, it means it is reusable and we can use at n number of places and same thing is here. We can achieve the same by writing the JOIN code as well but many times we do not prefer writing the big JOIN code and simply fetch the data from Database view.
Good Evening sir. When I created the database view, i have given all the table fields from both header and item tables then i went for checking the contents of the table but when I'm executing it at selection screen step, the status bar showing me that "No table entries found for specified key". Could you please explain me how can I get the database view output?
Thank you so much for your quick response sir. Just now I checked the item table and found an empty data entry.. so I filled it with some records and my issue got resolved. Thank you so much sir🙏
Same thing happened with me but I don't know even though I have added data into the item table earlier then why the data was missing ? Sir please guide.
@@YashWankhedkar You can put again. It might be the case someone else deleted the data as other users might be also using the same system or you forgot to click on to save button.
Hello Sir, Can we create left outer joins for the database views ? I can see the inner join only working for the database views . How to create left or right outer joins for database views.?
Database Views always Implements Inner Join. Help View supports Left Outer Join. Previously SAP was not supporting Right Outer Join. Now CDS Views( ABAP on HANA) supports RIGHT Outer Join also.
Hello sir, In Database View after activating the view the key field column get clicked, I mean all the fields get assigned as a key field, why this is so?
It is in built behavior. All primary keys must be together and at the top. Suppose you are taking the fields from the first table - some are keys and some are non-keys. Then you are taking fields of second table - some are key and some are non-key. It is not possible that - Key, non-key, key, non-key. So SAP ticked the checkbox key for all the fields. Whenever you want information on anything, just do F1(technical help), you will get the full information on that.
![Create a View in SAP - Database Views [english]](/img/n.gif)
What a beautiful experience to learn from you, Sir! You are really a giant of all time and I am sure your tutorials are certainly not meant for beginners at all. I mean as learning is a lifetime process, all the experienced candidates in the field of ABAP must be referring these nice videos for their clarity and better understanding. Hats off Rahul Sir.
Thank you very much Janmejaya for your valuable and encouraging feedback. It inspires me a lot.
Wonderful session 🎉
Thank you Rahul sir 🤝
Hi sir, i did handson for the view.. if i do projection view on a db table it is not showing contents.. bt in status bar, it is showing no database table exists for the view-name.. though i gave tablename and selected the field from table to display
Yes. We need to write a query to display the data from projection view. Once you move on to upcoming playlists, you can write a query to display the data from the projection view.
Superb explanations sir
Thank you.
Hi rahul,
One question.
What is the actual use of the database view.
We can write this joins in code also right .
Also apart from being able to view the values in se11. What difference or benefit do we get from creating a database view
When we create database view, it means it is reusable and we can use at n number of places and same thing is here. We can achieve the same by writing the JOIN code as well but many times we do not prefer writing the big JOIN code and simply fetch the data from Database view.
Good Evening sir. When I created the database view, i have given all the table fields from both header and item tables then i went for checking the contents of the table but when I'm executing it at selection screen step, the status bar showing me that "No table entries found for specified key". Could you please explain me how can I get the database view output?
It means there is no data in item table as database view works on inner join and there is no matching records between the 2 tables.
Thank you so much for your quick response sir. Just now I checked the item table and found an empty data entry.. so I filled it with some records and my issue got resolved. Thank you so much sir🙏
Same thing happened with me but I don't know even though I have added data into the item table earlier then why the data was missing ?
Sir please guide.
@@YashWankhedkar You can put again. It might be the case someone else deleted the data as other users might be also using the same system or you forgot to click on to save button.
Thank u sir thank u god 🙏😇
Hello Sir,
Can we create left outer joins for the database views ? I can see the inner join only working for the database views . How to create left or right outer joins for database views.?
Database Views always Implements Inner Join. Help View supports Left Outer Join. Previously SAP was not supporting Right Outer Join. Now CDS Views( ABAP on HANA) supports RIGHT Outer Join also.
Hello sir, In Database View after activating the view the key field column get clicked, I mean all the fields get assigned as a key field, why this is so?
It is in built behavior. All primary keys must be together and at the top. Suppose you are taking the fields from the first table - some are keys and some are non-keys. Then you are taking fields of second table - some are key and some are non-key. It is not possible that - Key, non-key, key, non-key. So SAP ticked the checkbox key for all the fields. Whenever you want information on anything, just do F1(technical help), you will get the full information on that.
Can you upload video for the remaining 2 view types .
Also please upload videos search help and lock object.
Hello Sonali. The videos of Search help and lock object has not created yet, but soon will upload the videos of other 2 types of views.
@@sapabapbyrahulmehta thank you in advance