Very nice explanation. I really liked the approach of the practical issues section to try alternatives before going for CDS table function. It is clear the necessity of using a table function.
Thank you so much for your kind words! 😊 I'm really happy to hear that the explanation and example worked well for you. Your feedback motivates me to keep sharing helpful content. 🤗
Thanks for the video. Is it posible to introduce logic in the table function. I mean , for example some If statements. Or just SQL statements ?? Again. Thanks a lot!
Many to one is possible till some extend in ABAP 7.55 and onwards you can do F1 if you have latest version and check. But other things are not possible :- SELECT, FROM JOIN Short Reference Syntax ... [(] {data_source [AS tabalias]}|join {[INNER] JOIN}|{LEFT|RIGHT [OUTER [MANY TO ONE]] JOIN}|{CROSS JOIN} {data_source [AS tabalias]}|join [ON sql_cond] [)] ... . MANY TO ONE
Effect Specifies the cardinality of a left outer join. This addition is positioned after LEFT OUTER, but is not possible after RIGHT OUTER. Only certain specific database systems apply this addition. If the addition MANY TO ONE is specified, any databases that support this addition assume that the result set defined by the left outer join matches this cardinality and SQL Optimizer attempts to suppress any surplus joins. If the result set does not match the cardinality, the result is undefined and may be dependent on the entries in the SELECT list.
1. To Acheive multiple selection options can we do it through CDS Views or we need to go for Table functions or AMDP? 2. How can we return multiple tables incase if required through Table functions? 3. When we need to go for AMDP and when we need to go for CDS Table functions? Please reply
1. We can pass multiple selection option in AMDP and CDS table function that I will explain in upcoming video. 2.Table function we can't return multiple tables but in AMDP we can do 3.Usually when we do data modeling using VDM for creating fioriapplication that time we need CDS table function but When we have to code push down in normal ABAP then we use AMDP's I will explain this when I create video on AMDP.
@@SAPTECHNOMANIAC Thank you..And it will give be good if you can take some realtime examples to explain VDM Model, Creating FIORI app using CDS and difference between ABAP Object Programming model and Restful ABAP Programming model..
Why we need to create two cds view? In a single cds view also we can join both the table and fetch the data. Why are we creating this table function i am not getting.
We can't join some time fields are not compatible for on conditions:- "Join Conditions: CDS views cannot join two fields with data type and length mismatches in two tables1."
5 месяцев назад
where do we get 7.5 and 7.4 statements any links please
Sorry for let reply . We have to use Define view most of the cases but Some of the things we can't do using define view example sorting of data or loop .. then we have to use table function and write code in AMDP ....
1.can we use for all entries in AMDP ? please give example videos 2. create one selection screen in SE38 and pass to AMDP and get internal table value from AMDP. requesting one example
1. For all entries not supported in SQL Script but you can join instead. 2. We can pass selection screen data to AMDP that I will explain when we will discuss about AMDP in upcoming videos
Very nice explanation. I really liked the approach of the practical issues section to try alternatives before going for CDS table function. It is clear the necessity of using a table function.
Thank You!
simply awesome video.
Thank you! Cheers!
Very nice explanation and example. Simply brilliant way of teaching the topic. Thank you so much for sharing 🤗
Thank you so much for your kind words! 😊 I'm really happy to hear that the explanation and example worked well for you. Your feedback motivates me to keep sharing helpful content. 🤗
Very nice explanation with good example. Thank you!
You are welcome!
nicely explained, thank you
You are welcome!
Very nicely explained. Thanks.
Your most welcome please share with others as well ...
Thanks for the video. Is it posible to introduce logic in the table function.
I mean , for example some If statements. Or just SQL statements ??
Again. Thanks a lot!
how to use cds view with parameters in oracle db cds view in target system (which is on hana db) table function
Can we use 'LEFT OUTER ONE TO ONE JOIN' or 'INNER ONE TO ONE JOIN' in CDS ? Seems like it's only possible in CDS table function, not sure
Many to one is possible till some extend in ABAP 7.55 and onwards you can do F1 if you have latest version and check.
But other things are not possible :-
SELECT, FROM JOIN
Short Reference
Syntax
... [(] {data_source [AS tabalias]}|join
{[INNER] JOIN}|{LEFT|RIGHT [OUTER [MANY TO ONE]] JOIN}|{CROSS JOIN}
{data_source [AS tabalias]}|join [ON sql_cond] [)] ... .
MANY TO ONE
Effect
Specifies the cardinality of a left outer join. This addition is positioned after LEFT OUTER, but is not possible after RIGHT OUTER. Only certain specific database systems apply this addition.
If the addition MANY TO ONE is specified, any databases that support this addition assume that the result set defined by the left outer join matches this cardinality and SQL Optimizer attempts to suppress any surplus joins. If the result set does not match the cardinality, the result is undefined and may be dependent on the entries in the SELECT list.
1. To Acheive multiple selection options can we do it through CDS Views or we need to go for Table functions or AMDP? 2. How can we return multiple tables incase if required through Table functions? 3. When we need to go for AMDP and when we need to go for CDS Table functions? Please reply
1. We can pass multiple selection option in AMDP and CDS table function that I will explain in upcoming video. 2.Table function we can't return multiple tables but in AMDP we can do 3.Usually when we do data modeling using VDM for creating fioriapplication that time we need CDS table function but When we have to code push down in normal ABAP then we use AMDP's I will explain this when I create video on AMDP.
@@SAPTECHNOMANIAC Thank you..And it will give be good if you can take some realtime examples to explain VDM Model, Creating FIORI app using CDS and difference between ABAP Object Programming model and Restful ABAP Programming model..
Is OPTIONS READ-ONLY not required in implementing Table function? Like you did for scalar table function....
Not possible . As I know in CDS
Please how to cast type sstring to abap char? With this error sstring not supported
Explained in open SQL series
Why we need to create two cds view? In a single cds view also we can join both the table and fetch the data. Why are we creating this table function i am not getting.
We can't join some time fields are not compatible for on conditions:- "Join Conditions: CDS views cannot join two fields with data type and length mismatches in two tables1."
where do we get 7.5 and 7.4 statements any links please
Just do f1 you will get all the statements
when to use define view and define table function in AMDP
Sorry for let reply . We have to use Define view most of the cases but Some of the things we can't do using define view example sorting of data or loop .. then we have to use table function and write code in AMDP ....
1.can we use for all entries in AMDP ? please give example videos
2. create one selection screen in SE38 and pass to AMDP and get internal table value from AMDP. requesting one example
1. For all entries not supported in SQL Script but you can join instead. 2. We can pass selection screen data to AMDP that I will explain when we will discuss about AMDP in upcoming videos