I don't think there is anyone else who can explain this matter as deep as you have done, If someone like is not uderstanding the Cardinality and Joins on data base level please watch carefully Part 8 to Part 12. I am waching it for the second time and enjoying it a lot. thanks a lot.
just one query to ask. at video time 21:51 the SQL trace shows that the join is one to many in native hana trace while the CDS Entity mentioned is left outer to one join vbap as _itm. how both screen showing different things. Kindly clarify.
Since we are fetching fields from RHS table (join happend its clear, also if you notice in output we got multiple SO items even though we mentione join to one, becasue when we fetch fieds from RHS, SQL query runs on DB join to many so multiple so items in output, thatsy its shows one-to-many in screen..I think) hope its clear..
Hi Ram, Firstly thanks for the explanation!. it was very much helpful for us. One question is incase of N:1 left outer join, join did not happen on VBAK(RHS table). which we saw on the ST05 too, understood. Fundamentally we will get to know that VBAP is an item table, will have either 1 or more entries when compared with VBAK, but how will system get to know that it is an N:1 left outer join only?.
Clear the console and then execute OR your result will be at the end of the console If you are talking about console result. If table result not updating due to new column addition then re execute the table.
It's due to I didn't clear console before displaying next result ... It was previous execution data new execution data below the previous execution data ..... When you display the result in console it will not clear existing data in console and just append the result after previous result. what you can see on screen both the time @16:00 and @18:00 both are older execution result . My mistake is that I didn't focus on quesy result showing, I was focusing on to show how join his happening ... According to join only the result will come...
I don't think there is anyone else who can explain this matter as deep as you have done, If someone like is not uderstanding the Cardinality and Joins on data base level please watch carefully Part 8 to Part 12. I am waching it for the second time and enjoying it a lot. thanks a lot.
You are right Gourav it might be difficult at first glance but once we understand we never stuck in association in future.
True..
Brilliant and deep explanations... Kudos 👌
Glad you liked it
Good Explanation Sir .Thank you !!!
Glad you liked it
thank you for your videos.. very helpful
You are welcome!
just one query to ask. at video time 21:51 the SQL trace shows that the join is one to many in native hana trace while the CDS Entity mentioned is left outer to one join vbap as _itm. how both screen showing different things. Kindly clarify.
Since we are fetching fields from RHS table (join happend its clear, also if you notice in output we got multiple SO items even though we mentione join to one, becasue when we fetch fieds from RHS, SQL query runs on DB join to many so multiple so items in output, thatsy its shows one-to-many in screen..I think) hope its clear..
Hi Ram, Firstly thanks for the explanation!. it was very much helpful for us. One question is incase of N:1 left outer join, join did not happen on VBAK(RHS table). which we saw on the ST05 too, understood. Fundamentally we will get to know that VBAP is an item table, will have either 1 or more entries when compared with VBAK, but how will system get to know that it is an N:1 left outer join only?.
Foreign key relationship between these tables
Osm video bro 😎.Good job
Thank you ...
when you execute the table the results are not refreshed right..how will i solve that problem
Clear the console and then execute OR your result will be at the end of the console If you are talking about console result. If table result not updating due to new column addition then re execute the table.
if compared one to one join @16:00 and one to many @18:00, still we can see duplicate entries !!. Can you please correct if anythg unnoticed?
It's due to I didn't clear console before displaying next result ... It was previous execution data new execution data below the previous execution data .....
When you display the result in console it will not clear existing data in console and just append the result after previous result. what you can see on screen both the time @16:00 and @18:00 both are older execution result .
My mistake is that I didn't focus on quesy result showing, I was focusing on to show how join his happening ... According to join only the result will come...
Good content.
Appreciated
Nice video
Thanks
nice video'
Thanks