Skip to Content

Introduction:

 

CDS Views can be created and viewed only from ABAP Development Tools (ADT) .The objective of this blog is to list down some standard utilities related to CDS Views which would allow us to gain information on these views from SAP GUI.

 

These reports will be useful for users who are not having access to ADT tools or not able to access the system from ADT due to missing authorization.

 

Report Usage
RUTDDLSANALYZE Analysis of DDL Sources
RUTDDLSSHOW Search for DDL sources with name and/or template
RUTDDLSSHOW2 CDS Source Display
RUTDDLSDEL Delete the DDL Source and the generated view
RUTDDLSACT Activates Set of DDL Sources

RUTDDLSANALYZE

 

This report can be used to get the list of DDL Sources in the system , the corresponding DDL SQL view name , package and other information.

 

Executing the report to check all DDL Sources starting with I_SALES:

 

/wp-content/uploads/2016/06/0_985003.png

 

Report Output:

 

The report output shows 62 DDL Sources exist with name starting with I_SALES. Highlighted button “DDL Source Text Display” can be used to view the DDL Source definition.

 

/wp-content/uploads/2016/06/1_985016.png

 

RUTDDLSSHOW

 

This utility can be used to search to DDL sources with name or template. It can be used to see the source code of multiple views at a time. The report also provides information about the created database view , referenced DDL sources and referenced tables or non- CDS views.

 

 

Executing the report to get information about all DDL sources starting from I_SALES:

/wp-content/uploads/2016/06/2_985017.png

 

Report Output:

 

DDL source definition along with other details is displayed for all views.

 

/wp-content/uploads/2016/06/3_985018.png

 

RUTDDLSSHOW2

 

The report can be used to view the DDL source code of a single CDS View.

 

Executing the report to view the DDL source for CDS view I_SALESCONTRACT.

 

/wp-content/uploads/2016/06/4_985022.png

 

Report Output:

 

DDL Source code is displayed.

 

/wp-content/uploads/2016/06/5_985023.png

 

 

RUTDDLSDEL

 

This utility can be used to delete the DDL Source and the corresponding database view. It should be used cautiously as the utility doesn’t asks for confirmation.

 

Executing report to delete the DDL Source ZTEST_AUTH.

 

/wp-content/uploads/2016/06/6_985024.png

 

Report Output:

 

The report log shows the information about the deleted source.

/wp-content/uploads/2016/06/7_987476.png

 

 

RUTDDLSACT

 

This program can be used for mass activation of views.

 

Executing report to activate DDL Source ZPO_DATA.

 

/wp-content/uploads/2016/06/8_987455.png

 

Report Output:

 

/wp-content/uploads/2016/06/9_987477.png

 

EDIT :  S4 HANA  1610 release provides the option to navigate to the source code from the SE11 utility.

 

Open View in SE11:

 

 

Clicking on DDL Source takes to the source code in display mode:

 

 

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Arshad Ansary

    Hi Tanmay,

    Thanks for the list .

    There is one more report that I normally use to manually activate the CDS views

    RUTDDLSACT

    BR

    Arshad

    (0) 

Leave a Reply