Core Data Services (CDS) ABAP Feature Matrix
With SAP NW ABAP 7.4 SP5 the first instalment of Core Data Services (CDS) support in ABAP was delivered (see New Data Modeling Features in SAP NW ABAP 7.4 SP5). Since CDS is a relatively new technology, new features are constantly being added. Below is a short overview of which features were released with which SAP NW ABAP version and support package. For details about the features you should check out the 7.40 ABAP Keyword Documentation, 7.50 ABAP Keyword Documentation and 7.51 ABAP Keyword Documentation.
ABAP Core Data Services (ABAP CDS)
SAP NW ABAP | SQL Joins | SQL Set Operations | SELECT Clauses |
7.4 SP5 |
|
|
|
7.4 SP8 | |||
7.5 | |||
7.51 |
|
SAP NW ABAP | Literals | Arithmetic Operators | Conditional Expressions |
7.4 SP5 |
|
|
** Only in WHERE conditions |
7.4 SP8 |
|
||
7.5 | |||
7.51 |
|
SAP NW ABAP | Aggregate Functions | Numeric Functions | String Functions |
7.4 SP5 |
|
|
|
7.4 SP8 |
|
|
|
7.5 |
|
||
7.51 |
|
|
|
SAP NW ABAP | Byte String Functions | Date and Time Functions | Other Functions |
7.4 SP5 |
|
||
7.4 SP8 |
|
||
7.5 |
|
|
|
7.51 |
|
|
SAP NW ABAP | Conditional (CASE) Expressions | Extensibility | (Unmanaged) Associations |
7.4 SP5 |
|
$EXTENSION.* (support for database table extensions) |
|
7.4 SP8 |
|
EXTEND VIEW** ** Added elements cannot be input parameters, path expressions or aggregate expressions |
|
7.5 |
|
EXTEND VIEW** ** Input parameters, path expressions and conversion, date and time functions can be added/used |
|
7.51 |
|
EXTEND VIEW** ** Views with aggregate functions, GROUP BY clauses and UNIONs can be extended |
|
SAP NW ABAP | Session Variables | Input Parameters | Other |
7.4 SP5 |
|
||
7.4 SP8 |
** Use ABAP API cl_abap_dbfeatures=>use_features to check if your DB supports CDS views with input parameters |
||
7.5 |
|
|
** SAP HANA only |
7.51 |
|
|
SAP NW ABAP | “Core” Annotations | Further Information |
7.4 SP5 |
|
ABAP CDS in Release 7.40, SP05 |
7.4 SP8 |
|
ABAP CDS in Release 7.40, SP08 |
7.5 |
|
ABAP CDS in Release 7.50 |
7.51 |
|
ABAP CDS in Release 7.51 |
Thanks, Chris. This will help us a lot.
Hi Chris,
I attended your session at Teched Barcelona this year (it was really good!) on ABAP in Eclipse, and in your session - and in several others the technology of CDS views was raised as a way to be prepared for switching to HANA for customers not on HANA yet; or at least that's how it appeared to me.
We would like to use the CDS view technology in our Oracle ECC system (7.40 SP09), however we are concerned that if we convert a large number of our SQL selections to CDS that this may constrain the choice of which HANA License we can choose in the future. It was raised by our senior architect that usage of the CDS views may force us to accept an Enterprise HANA license (if this is the case we are instructed not to use CDS). Apparently there are many specific restrictions for usage on HANA that affect which license you must use. Are you aware (or do you know someone who is) if it is possible to migrate CDS views from Oracle to HANA (and then support them once on HANA) without having to accept an enterprise HANA license?
Note I'm also planning on writing a blog on usage of CDS views from my own perspective, and I think any answer that you or your colleagues can provide will be good input to it.
kind regards,
Julian
Hi Julian,
here again you need to differentiate between the ABAP implementation of the CDS specification (ABAP CDS) and the native implementation in HDB (HANA CDS). See Horst's blog for details: CDS - One Concept, Two Flavors
ABAP CDS and HANA CDS development objects are currently independent of each other.
You can model your data and develop your code pushdown with ABAP CDS on AnyDB. ABAP CDS objects are the same as any other ABAP development objects. If you can develop ABAP, then you are good to go as far as ABAP CDS is concerned. Even when you migrate to SAP HANA. Your existing ABAP CDS views will work out of the box (since they are "open"). The only difference might be, that your ABAP CDS views might run a little faster on HDB ;-).
If you implement HANA CDS in the future (as opposed to ABAP CDS), then this is native HANA development. I am not an expert on license questions so I'd suggest you pose this question to a qualified SAP (HANA) representative, e.g. via: Get Connected . Like I said above, this only becomes relevant when you implement HANA CDS. If you are doing ABAP development, then I strongly suggest you only use ABAP CDS since ABAP CDS ensures that the CDS objects are optimally integrated into the ABAP development environment (including lifecycle) and ABAP runtime.
Kind regards
Chris
Hi Julian,
on an off-topic note: just read that you are a big WRU fan. I would suggest migrating to the Boks ;-).
Cheers
Chris
Hi Chris,
It seems I've had my notifications disabled, hence my lack of reply - sorry! thanks for your reply, we are currently only planning on using the ABAP CDS views - and so it sounds to me like we are ok from a license perspective, which is great news! I can get creating views for our main SQL statements - and put some of that great teched knowledge into practice. Note I posted a message via Get Connected - just in case their answer is different. If so I will update here too.
As for me switching to Springboks, oh dear! where to start? Has hell frozen over recently? I'd say Boks were quite lucky in the last 5 minutes of that world cup match, although on the whole they probably deserved the victory, Wales are by far the best team when we don't have 15 first choice player injuries (in my opinion)! I have to say the game I enjoyed the most from the world cup was a South Africa game - against Japan I think...
Thanks once again,
//Julian
Suppose I set myself up for that "Japan"-Jest 😀 .
Have a great holiday season.
Cheers
Chris
And you usually don't get open goals in rugby!
Happy holidays too - or God jul as they say around these parts.
//julian
Great overview!
Johann
cool, very helpful, thanks!
I created CDS on a system 7.40 SP04 but according your matrix it shouldn't be supported. What's the matter?
I've been looking for this matrix for 3 months. I'm stuck on 7.4 sp 22 which is most frustrating when i see what i could do in 7.5
Thanks so much for this info.