Skip to Content
-4

HANA CDS Vs. R3 Maintenance View

Mar 25 at 07:38 AM

91

avatar image

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.

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

1 Answer

Sandra Rossi Mar 25 at 08:09 AM
1

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

Show 10 Share
10 |10000 characters needed characters left characters exceeded

Dear Sandra, my concern is not about select statement. I can join multiple tables in Maintenance View and so do I in CDS views. What is the difference? What is the concept of Code Push Down?

0
Shubham Banerjee

hmm you want to know the difference, but you don't even understand that they can't be compared, as I told you initially: the primary goal of a CDS view is to be queried, of course, but you can't even query a maintenance view. Hence my initial question. You could also argue that you may join tables by using a SAP query, but that's not more relevant. The concepts are well explained in all existing CDS blogs and reference documentations. Please first search, and ask one precise question, as per the forum rules.

1

Dear Sandra,

I don't want to be explained the rules of the forum but a relevant and detailed explanation to my query. Just the way, the rule of the forum is to search existing blogs and documentations first before asking a precise question, it also applies that a person exposed to such useful and helpful topics must share along with the answer and not argue with words.

Thanks

0
Shubham Banerjee

You forget that nobody here gets paid to help you.

1

If being paid is the ultimate lookout, what is the need of a community then.

0
Shubham Banerjee

I was just asking that you explain more about the question, because it doesn't make sense to me at all. If you think it's perfectly clear and you don't need to explain what is a "maintenance view" according to you, then fine. As far as I know, according to SAP, a "maintenance view" is a technical view of a table or a database view, used for displaying data of this table or database view in transaction SM30, with a different User Interface layout. Anyway, I hope you'll get the answer you are looking for.

0

Dear Sandra,

Thank you for your explanation. Really appreciate it. My question was, as per my knowledge (which is really small relative to yours) the basic differences between a R3 view and CDS view are,

Generally (HANA Perspective)

1. CDS view operates on DB layer instead of ABAP layer

2. We can use code push down, select query, aggregate and arithmetic functions in CDS

3. CDS views can be used for OData publishing

Specifically Maintenance Views vs CDS Views

1. Both joins multiple tables

2. Both creates a logical view on DB layer

3. Aggregation can be done using ABAP reports.

Then, should we conclude that CDS views are much advantageous for Analytics mainly? How are ABAPers benefitted using CDS views, with respect to BO and BI developers?

Please let me know if I have been able to clarify my doubts.

0
Shubham Banerjee

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

0

I think you're talking about database view, not maintenance view.

Just about Join, you can't use left join in database view, but you can use left join in CDS, so you can make some reusable views that can be used in other abap programs.

And Code Push Down is kind of sql script that works on the HANA DB, just like PLSQL on Oracle.

Great thing is you can make it as ABAP Object method, so it can be called from other programs easily.

0

Dear Young,

Thank you for your comment but I am looking for a more detailed explanation, as like you are trying to convince someone about CDS views over Maintenance View.

Thanks.

0