This video discusses the concept of associations in Core Data Services (CDS) views in SAP HANA. It provides a detailed explanation of when to use joins and associations, and how SQL statements behave for joins and associations.
After watching this video, you will learn:
- The scenario where associations are preferred over joins. The presenter explains that associations are particularly useful when designing CDS views for UI applications, where different users may have different authorizations to view certain data. Associations fetch data only on demand, which can improve performance and efficiency.
- How to create a CDS view with associations. The presenter demonstrates this process step by step, starting with creating a new definition in HANA Studio and choosing the package or transport request.
- The concept of public and private associations. Associations should generally be kept public so they can be accessed by other applications or CDS views. If an association is made private, it will not be accessible from outside the CDS view in which it is defined.
- How to use associations in an ABAP program. The presenter shows how to access fields from an association in an ABAP program using the CDS entity name.
- The concept of ad hoc associations. These are associations that are added to the CDS view at runtime and are not part of the original CDS view definition.
- The presenter also explains the concept of cardinality in associations, and how to change the default join type in an association from left outer join to inner join.
The video is practical and detailed, showing each step at the system level. It is intended for those who wish to learn about CDS Views and how to create and use them in HANA Studio and SAP systems.