Difference between Associations and Table Funcctions in CDS Views
Associations: 1.Keep only base table/CDS view fields in the selection list. 2.Keep association as public/expose association 3.AD-Hoc Association - Showing the Association field name in first CDS view 4.Path expressions, 5.Change the default outer join as inner join 6.Cardinality Table functions: 1.Whic supports the additional functionalities which are not supported by CDS. 2.SQL statements will written and will use SQL functions and methodologies. 3.Table function has optional input parameters and return parameters. 4.Needs class and method to define. -Class: Public, Method: Static 5.The statement Interface: IF_AMDP_MARKER_HDB must be use. method get_data by database functions for HDB Language SQL OPTIONS READ-ONLY Using tables-names method get_data by database procedures for HDB Language SQL OPTIONS R...