Simple CDS view fetch data from single table

 Fetch data from table in CDS view

    * Data in SE11.

Create CDS view

1. Right click on object and select new. Click on other repository objects. Expand core data service and double click on data definition.

2. Give CDS entity name and description. Click on next select package/TR and select define view and click on finish.

3. Give SQL view name.

Code

     @AbapCatalog.sqlViewName: 'ZAB_SQL_STU'

  @AbapCatalog.compiler.compareFilter: true

  @AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'student details'

define view ZAB_CDS_STU as select from zajay_zstu

{

key zst_id as ZstId,

zst_name as ZstName,

zst_dept as ZstDept,

zst_fee as ZstFee

}

4. Check and activate. Run as ABAP application.

Output

*****************************Thank You**************************