Skip to Content

What are the advantages of CDS views and assosiation in HANA

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 :)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 11 at 12:35 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded