Skip to Content
0

What are the advantages of CDS views and assosiation in HANA

Apr 19, 2017 at 10:06 AM

701

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Patrik Andras Menyhart
Jun 11 at 12:35 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded