This is a test message to test the length of the message box.
Login
ABAP Tools Work with Eclipse
Created by Software-Heroes

ABAP Tools - Work with Eclipse (data analysis)

This is about the analysis of table data in the system and the use of the SQL Console in the ABAP Development Tools.

Advertising

In today's article we are dedicated to the analysis of the data in tables and introduce you to the SQL Console and how it can help you with the data analysis in your system.

 

Data table

First of all, we want to introduce you to our database. For this we have created a simple material table ZBS_D_MATERIAL. You get the structure in the following picture:

 

There is also a description table ZBS_D_MATERIALT which contains the corresponding descriptions in different languages. We will use this text table at a later point.

 

Data Preview

To get the data preview, you just have to press the F8 key while you have the table definition open. Here you get a similar data view as in the SE16 and you can look at the data in the table.

 

At the top of the menu you have various options for working with the data:

  • "Number of Entries" - Display the number of entries in the table 
  • "Select Columns" - Select or hide columns in the table
  • "Add Filter" - Filter individual columns according to specific values

 

When selecting the columns, all columns of the table are available to you. Below is the screenshot for selecting the column in our table. We want to hide the client field because we do not need this information in our analysis.

 

With a right-click on the data you can also assign a quick filter to the column. Here we need all materials that have a zero quantity. Therefore we select the entry zero in the "Quantity" column and can choose form the quick assignment.

 

SQL Console

As you have probably noticed, there is also the SQL Console function in the menu bar of the Data Preview. We want to introduce you to this special function in this section. You can also open the SQL Console with a right-click on the current system, here you will find the entry in the context menu. Or you simply click the button in the menu bar. The advantage of this method is that the filters and shown columns are transferred to the pre-defined Select.

 

In the SQL Console you can then program your own access and join other tables. In our example we do not need all fields and also need the text from the text table for the English texts. The result looks like this after the execution:

 

Data as template

You can also use the restricted data as a template for your coding. All you have to do is right-click on the data and use "... value statement" to copy the data into the clipboard.

 

When inserting the data you only have to make the assignment to the variable and end the statement with a dot. Here is the excerpt as it looks right after inserting:

VALUE #( 
  ( MATERIAL_NUMBER ='Screw' DESCRIPTION ='Don''t screw me' QUANTITY ='0'  )
  ( MATERIAL_NUMBER ='Fork' DESCRIPTION ='Eat some noodles' QUANTITY ='0'  )
)

 

Conclusion

The data analysis and the creation of joins via different tables is much faster and more effective in Eclipse. If you have also connected your ADTs to production, you can easily perform data analysis without creating a quick view or exporting large amounts of data to Excel.


Included topics:
ToolsADTEclipseData analysisSQL Console
Comments (0)
Advertising

ABAP Tools - Work with Eclipse (Transport)

Category - ABAP

In this article we enter the work with transports within Eclipse and show you the previous possibilities of the tool to support you.

03/12/2021

ABAP Tools - Work with Eclipse (Debugging)

Category - ABAP

Debugging in Eclipse? We'll show you what to look out for and how you can make the switch as quickly as possible in order to become as efficient as in the GUI.

08/07/2020

ABAP Tools - Work with Eclipse (Refactoring)

Category - ABAP

Today's article is about working with Eclipse and how you can efficiently and quickly refactor your source code.

07/24/2020

ABAP Tools - Work with Eclipse (Search)

Category - ABAP

In this small series we want to bring you closer to working with Eclipse and show the advantages for the speed of development.

07/10/2020

ABAP Tools - Why switching to ADT?

Category - ABAP

Why should you switch to the ABAP Development Tools today? We want to bring this closer to you in this article.

07/03/2020