This video continues the discussion on the concept of associations in Core Data Services (CDS) views in SAP HANA. It delves deeper into the topics of path expressions, changing the join type in an association, and cardinality.
After watching this video, you will learn:
- The concept of path expressions in associations. Path expressions can be used to change the default join type in an association from left outer join to inner join. They can also be used to add specific conditions to the association.
- How to create ad hoc associations. An ad hoc association is when you want to display an association field in the CDS view itself. However, this is not considered a best practice as it can lead to unnecessary mapping of fields.
- The concept of cardinality in associations. Cardinality refers to the relationship between two tables in terms of the number of records that can be linked. It can be one-to-one, one-to-many, or many-to-many. The presenter explains how to specify the cardinality in the CDS view and how it affects the output.
- The presenter also demonstrates how to use path expressions to change the join type in an association and how to specify the cardinality. They show how changing the cardinality can result in different outputs, such as duplicate records.
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.