This is the 4th blog post on the CDS detailed explanations after the Introduction post. Refer to the Introduction and blog post indexes here:
https://blogs.sap.com/2019/10/21/part1.-sap-cds-views-demystification/
CDS view is also called a VDM i.e. Virtual Data Model as there is no data persistence happening. All the SQL like code written in a CDS view pick the data from Base tables directly or via other CDS view at RUNTIME . The actual data still remain in the SAP Base tables and CDS views remains a virtual data model. Now in a scenario, we have created a complex CDS view which has lot of business logic implemented into it and we want to use the data coming out of this CDS view in an ABAP program, can this be possible? Yes, it is possible via new ABAP syntax. Let's look at it.
1. We will use the Basic CDS view we created before to be consumed via ABAP program;
@AbapCatalog.sqlViewName: 'ZSQL_BASIC_VIEW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS View type #BASIC'
define view ZCDS_BASIC_VIEW as select from sflight {
//sflight
--key mandt,
key carrid,
seatsmax_b,
seatsocc_b,
seatsmax_f,
seatsocc_f
}
2. Within ABAP perspective in Eclise or HANA Studio, right click on your user under Lcal Objects within an ABAP project to create an AABAP program
- Consume the CDS Basic view we created via this ABAP program. Note the new ABAP syntax used for this purpose.
*&---------------------------------------------------------------------*
*& Report zconsume_cds
*&---------------------------------------------------------------------*
*&
*&---------------------------------------------------------------------*
REPORT zconsume_cds.
Select * from ZCDS_BASIC_VIEW into table @data(lt_itab).
cl_demo_output=>display_data( lt_itab ).
2. Hit F8 or Execute the program to check the output.
In summary, there are lot of scenarios in projects where we write complex CDS views and we need to consume them into an ABAP program for different business needs. In this blog post, we looked at the new ABAP syntax to consume a CDS view.
Part# 5. CDS View Extension: Learn the concept of re-usability within CDS views.
Follow for upcoming blog posts:
kumarsanjeev
Keep learning..
SK