CDS View- Data Preview & Graphical Editor

light111Data Preview & Graphical Editor


Create a CDS view on DB table – SCARR and in select choose all fields which can be done by adding individual fields of the DB table SCARR to the view or just mentioning * .

Save and activate the view. The SQ view name and the cds entity name must be different.

1

in SE11, we can see the SQL view and the view fields and key field information.

2

In SE11, also the CDS view can be seen.

3

It is the same as in the Eclipse Editor.

4


When a CDS View is saved/activated, it uses the SQL statement to create the SQL view in ABAP Dictionary. Just right click on the editor and choose- Show SQL CREATE statement.

5

It uses below SQL statement to create SQL view in ABAP dictionary.

6

We can see the data preview of the CDS view. Currently it has no input parameters but a absolute select statement.

7

Here we can see the result screen of data preview and also we can select the SQL console button where we can see the current select statement made on the CDS entity to see the result.

8

Here is the SQL console.

9

Here for the testing purpose we canĀ  change the select statement on the CDS view to see the desired result. The same kind of select query we are going to make from our abap report/class on the CDS view.

10

We can see the CDS view in graphical editor.

11

Here is the graphical editor.

12

The CDS view shows * as the result set column.

13


Now lets little change the CDS view, we don’t need * in selection but need some fields of the table. So put those fields names like below. Save and activate the CDS view.

14

In SE11 the SQL view and CDS view.

1516

The data preview:

17

The graphical editor- the CDS view shows the field names.

18


 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s