Skip to Content
avatar image
Former Member

HANA CDS Vs. R3 Maintenance View

Hi Experts, kindly explain what is the differences or advantages of CDS views over Maintenance Views. In both of them we can join multiple tables, apply joining rules and both creates a physical view on the database layer on activation. Apart from column store methodology and vertical data partitioning for faster parallel processing, what are the technical benefits of Code Push Down? What is the most proper answer for why do we use CDS and not Maintenance Views, with real time example? No theories please.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 25, 2018 at 08:09 AM

    "maintenance view" ! Are you using the right term? Because I could never do a SELECT on a maintenance view.

    Add comment
    10|10000 characters needed characters exceeded

    • You are still using the wrong term "maintenance views"... If you could say "database views", then that would be perfect (with possibly the "ABAP Dictionary" addition, to distinguish them from the real Database views).

      Your assumptions seem correct, I have only one remark about "Aggregation using ABAP reports", I would reformulate ."Aggregation using Open SQL" (a report is a special type of program, the aggregation can be done in any type of ABAP program).

      But my first answer was about the "maintenance views". I'm neither an expert in CDS views at all, nor in HANA.

      You'll benefit from the community by asking a new question by reformulating your last comment with more precise questions, if possible ask questions about some statements in the many CDS blog posts. Otherwise, your question looks like a "please answer like a blog post to list the advantages/drawbacks of CDS versus Open SQL", and that's not the purpose of the SCN forum, as far as I know.

      My 2 cents (don't hesitate to skip this section, as I may be completely wrong, because it's more opinion-based than knowledge-based):

      Your question is really too wide, you are mixing CDS, Open SQL, BO and BI. CDS is an enrichment of SQL, with annotations and so on, which better describe the data model. I don't know how can BO and BI be compared to CDS/SQL in any manner, they are not talking about the same things (you may only compare BO to BI reporting, and CDS to SQL, nothing more). Advantages of CDS views compared to SQL are the code push down (better performance at database level), the data modeling, the authorization concept, and that recent technologies will use CDS more and more. About analytics, I think it's more related to HANA than CDS views.

      Note that CDS is not related to the "storage of data by column" (from your remark in the initial question), this technology is specific to HANA, and CDS can be used with other databases (ABAP CDS versus HANA CDS).