CDS Associations & Joins
A Devtoberfest 2026 session from SAP's performance and scalability team on what an ABAP CDSABAP CDSThe modelling layer of ABAP Cloud — view entities, projections and annotations defined above database tables, delivered with the platform rather than installed.sap official, abap association becomes on SAP HANA, taken as an excerpt from their internal performance training. The CDS edge rests on the three ways an association is used: a path expression and an explicit join both put a left outer join into the generated view, while exposing the association leaves the view without one and adds the join only for a query that asks for its fields, which the session calls join on demand. The data modellingData modellingDefining the shape of data before anything serves it: entities and their types, how they relate, and the projections and views that services and applications consume.SAP and community, unassessed edge is the advice that follows and the demo under it — cardinality written as precisely as the data allows, because the optimiser trusts it, shown with a view whose missing cardinality let SELECT COUNT(*) prune the join and return 18 rows where selecting the columns returned 56, plus the left-hand, right-hand and left-outer-to-inner rewrites that correct cardinalities make possible.
Where it sits
Who is behind it
In the atlas: maintains 146, wrote 61@SAPauthor
Properties
About this work
For data-modelling
Details
Graph
Source
History
- authors → actor:sapThe free-text author was the SAP Developers YouTube channel, which is SAP (ADR-0115). Only the credit changes.
- Entered the atlasDiscovered via Added by hand.
For your agent
- Ref
content:devtoberfest-2026-cds-associations-and-joins- JSON
- /content/devtoberfest-2026-cds-associations-and-joins.json
- MCP
- Connecting an agent