Association is conceptually Adhoc join or Join on demand. It helps us to achieve better performance and better navigation. Very useful from Fiori apps perspective.
Host variable(data from the application server) also know as Escape variable is used in new age Open SQL for inline declaration. It imposes strict code check while doing syntax check in the editor.
Code pushdown is concept to push the data intensive logic to DB level. CDS, AMDP can be used to achieve this.
"Use of Order BY cluase while selecting data from tables.
Use of Inline declaration.
Use of Inner join on tables compared to For all entries. Use of data calculation related functions while selecting the data to reduce further roundtrip from DB.
All cluster and some pooled tables are converted to transparent tables in HANA. Hence queries on Cluster/pooled tables returns results sorted by primary keys is no more true here. Any custom coding which accesses physical table cluster/pool has to be changed so that the program reads from tables directly"
Use of Inline declaration.
Use of Inner join on tables compared to For all entries. Use of data calculation related functions while selecting the data to reduce further roundtrip from DB.
All cluster and some pooled tables are converted to transparent tables in HANA. Hence queries on Cluster/pooled tables returns results sorted by primary keys is no more true here. Any custom coding which accesses physical table cluster/pool has to be changed so that the program reads from tables directly"
There might not be any need of indexes and secondary indexes in S/4 HANA as the whole table fields act like the index. But standard sap tables are delivered with indexes and we can define and use secondary indexes as well.
Yes it is supported in S4 HANA.
"If reusability is not the concern then we can go ahead with Open SQL only.
If reusability is needed then CDS is very useful also it can further be used in Odata & Fiori.
AMDP is useful when we want to have some very complex logic which requires looping and all also the need is to use SQL Script then we can go ahead with AMDP. But now with the birth of CDS table function we can use AMDP inside CDS."
If reusability is needed then CDS is very useful also it can further be used in Odata & Fiori.
AMDP is useful when we want to have some very complex logic which requires looping and all also the need is to use SQL Script then we can go ahead with AMDP. But now with the birth of CDS table function we can use AMDP inside CDS."
BOPF is Business Object Processing Framework which gives the power to make CDS CUD(Create,Update,Delete) enabled.
Annotation is something which starts with @ and it makes the CDs semantically rich data model.
CDS stands for Core Data Services.Its semantically rich data model used in S4 HANA. We have many aanotations available which makes it semantic rich. CDS is database agnostic and can be used without S4 HANA as well.