Standard service - a fixed amount of work that is performed at a fixed price.  Post Service

  

Tuesday, 12 February 2019 15:28

CDS Part 12. Useful 6 CDS Related Tools in ADT

Written by 
Rate this item
(0 votes)

Old habits die hard. Developers took quite a long time tomove from old ABAP debugger to the new debugger. Even though the new debuggerhas way more advanced features.

Similarly,ABAPer still do their development using SAP GUI, even if they have the advancedABAP Development Tools available in their infrastructure. Change isdifficult. But, survival of the fittest is the mantra.

ADT (ABAP Development Tools) provides variety of tools to analyze an existing DDL Source to help understand CDS View definition in detail.

In this tutorial, we would like to make the developerscomfortable with ADT and provide detailed information of the various toolswhich make developers life bit easy to analyze the CDS Views.

Also Read : ADT Eclipse/HANA Studio for ABAPers

1)  Navigation From SQL View To DDL Source

If you have found SQL View and want to know its DDLSource (CDS View entity), right click the SQL View in Project Explorer andchoose Open with -> Definition

You will be navigated to the data definition of CDS view.

Alternately,

You can find DDL Source and CDS Entity from table DDLDEPENDENCY, since table DDLDEPENDENCY stores the objects of DDLSource.

Enter SQL View against field OBJECTNAME to get the DDLSource Name.

You will get the DDL Source Name in field ‘DDLNAME’ asbelow

Now again execute the table with only DDLNAME we gotabove, you will find two entries againstthe DDL Source– 1) CDS Entity name and 2) SQL View Name. So, this tableholds the link between CDS View and SQL view for DDL Source.

Also Check: My First SAP ABAP Program in HANA Using ADT

2)  Display Of SQL Create Statement

On activation of DDL Source, the development environmentsends a SQL statement to the database tocreate the SQL View. We can display the SQL CREATE statement as follow:

  1. Openthe DDL Source
  2. Rightclick anywhere in the DDL Source
  • ChooseShow SQL CREATE Statement

It will open a dialog window (popup) to display the SQL CREATE statement. The SQL CREATE statement is native SQL statement which depends on the type of database used by the system (in this case HANA).

Also RefreshIntroduction to CDS for ABAPers

3)  Active Annotations View

Active annotations view summarizes the semantic information of the CDS View and of its viewfields.

It not only takes annotation information but also listssemantic information that is taken/inherited from other CDS Views or DB tabledefinitions and data elements.

Open the active annotations view as follows –

  1. Rightclick on DDL Source. (Either in the editor window or in the Project Explorer)
  2. ChooseOpen with -> Active Annotations.

Active Annotations View will open in a dedicated tab inthe tab strip below the editor window.

Active Annotations View summarizes the semanticinformation at both entity level as well as view field level.

Entity Level –

View fields level –

If annotation is provided against the view field itoverwrites the original data source since priority is given to annotation aheadof original data source.

In the example above, we can see that fields CARRID has label ‘Airline’ that is not defined in the corresponding DDL Source. This label is inherited from source field in SCARR and originates from S_CARRID.

Also Read : Deep Dive into Core Data Services

4)  Graphical Editor

The graphical editor is another useful tool that supports you in analyzing complicated DDLsources. It not only shows how the given CDS View depends on otherrepository objects, it also provides graphicalrepresentation of the projection list and displays details about joinconditions, aggregations, filters, annotations, etc.

Open the graphical editor as follows-

  1. Rightclick on DDL Source. (Either in the editor window or in the Project Explorer)
  2. ChooseOpen with -> Graphical Editor

CDS entity annotations details as highlighted in abovepic.

Also CheckExpressions, Operations and Functions in CDS

5)  Dependency Analyzer

The dependency analyzer offers a simplified view byfocusing on the dependency tree and discarding the rest. This becomes veryuseful in case of more sophisticated DDL sources where it is difficult to findthe actual source of the data. There may be cases wherein the view reads data from another CDS view whichis further dependent on other objects.

Open the dependency analyzer as follows-

  1. Rightclick on DDL Source. (Either in the editor window or in the Project Explorer)
  2. ChooseOpen with -> Dependency Analyzer

Also Explore : CDS and Authorizations

6)  Data Preview

Data preview tool allows you to analyze the data returnedby a CDS View without the need to implement a SELECT statement yourself.

There are several ways to open data preview for a givenDDL source as follows –

  1. Rightclick on DDL Source. (Either in the editor window or in the Project Explorer)
  2. ChooseOpen with -> Data Preview

Or

  1. OpenDDL Source.
  2. PressF8.

By default, data preview lists 100 entries, but you canincrease or decrease this value manually by setting Max. Rows

The toolbar of Raw Data tab offers additional functions –

  • Addfilter

User can enter selection criteria to filter the data.

  • Numberof Entries

Displays total number of rows in the table/view thatmatch the selection criteria

  • SQLConsole

Opens a new editor window with a SELECT statement for theview/table. You can edit the statement, execute it and display the result torun a more sophisticated ad-hoc analysis of the data.

I hope this tutorial would give confidence to the novicedevelopers who are still reluctant to use ADT and work in CDS. Core Data Service has been invented tomake the life of developers easy. Treat it just like the normal view with somesuper human power.

Bookmark the link of this article. This should be yourready reckoner for CDS views in case you would want to refer it in future.

Tell us how you liked or not liked this article. Your feedback is of utmost importance to us. Please leave your thoughts in the comments section below.

We have a very active Telegram (App) SAP Technical Group with more than 3780+ SAP Technical Practitioners from 6 Continents of the SAP World. Please join it using below link.
Telegram SAP Technical Discuss Group. You need to install the Telegram App first on your mobile device. Once you have it on your mobile, you can join the group and also access it from the Web on your computer and laptop.

Free SAP ABAP for HANA Training Tutorials Exercises.

Read 18 times

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.