What are the advantages of CDS views and assosiation in HANA

[former_member327257]

Hi there,

I am new to SAP ABAP, and i wanted to know that, what is the advantage of using CDS views in HANA. Also i found that the syntax of assosiation, quite complex. what is the advantage of using assosiation.

Thanks in advance 🙂

[menpa]

The advantage is simple. It has more functionality then the standard views.

For example:

Views defined in a CDS document can make use of the following SQL features:

• CDS Type definition
• Expressions and functions (for example, “a + b as theSum”)
• Aggregates, “GROUP BY”, and “HAVING” clauses
• Associations (including filters and prefixes)
• ORDER BY, CASE, UNION, JOIN, and TOP
• With Parameters
• Select Distinct
• Spatial Data (for example, “ST_Distance”)

I also recommend to check the follwoing helps.

• https://help.sap.com/viewer/4505d0bdaf4948449b7f7379d24d0f0d/2.0.03/en-US/b4080c0883c24d2dae38a60d7f...
• https://help.sap.com/viewer/4505d0bdaf4948449b7f7379d24d0f0d/2.0.03/en-US/6fcd6e5883f04de5b618a6d911...

[former_member310377]

Hello,

Isn't this something that is available in ABAP 7.52?

I'd go a bit deeper by asking what's the advantage of CDS VS Native SQL (ADBC) or other features of ABAP 7.52 (allowing aggregation and much more)

Thanks! 🙂