Skip to content
ysichov edited this page Apr 11, 2020 · 13 revisions

Simple Data Explorer

Basic capabilities:

  • Multiple windows - you can open as many tables as you need or as much as your monitor resolution allows. You can open the same table multiple times.

  • Each table has its own selection parameters. It opens, closes with arrows icons. All standard search tools are connected, including specials for personnel numbers (PAXXXX-pernr fields) and organizational management objects (HRPXXXX tables).

Reactivity - update data as soon as you enter your data. You do not need to take a step back and lose context to change the selection conditions.

There is a lot of information in SAP, so the empty columns are hidden by default. You can display them if you like.

Comparison of visual size of the same table Comparison of visual size of the same table

Multilingualism. All languages installed in the system are supported. Column and table names are translated into the selected language. In addition, you can select technical field names as headings. The screenshot shows 4 options for displaying the table: 3 installed languages + technical field names option.

Graphical visualization of table links as in SE11 transaction.

To speed up the writing of technical tasks, the information about the fields from Data Dictionary is displayed. The SE11 transaction will be opened by clicking on it.

Double click on the selection field will open the standard help.

If you need to quickly track the relationships of several tables, you can select the entire column with the data of one table and drag it to the selection field of another table. The data in the source table columns are turned into buttons. In the receiver table, an inheritance indicator appears next to the column. In this way, you can revive a data model from several tables in just a minute. Double click on all fields (blue link) will open a reference table with the contents by external key. The green links imply special processing:

Double click on the personnel number will open the PA30 transaction.

Double click on the organizational management object will open the PP02 transaction.

From table PA0001 you can go to HRP1000.

In the HRP1001, a double click on a linked object will automatically select it in the search parameters, allowing you to navigate through all internal objects links.

Links to additional information on connecting objects in Organizational Management, as well as HRP1002 - HRT1002 connection are supported.

It supports drag & drop. You can drag one or more selected values from the table contents to the selection options of any table.

Payroll Clusters view added from table HRPY_RGDIR

Easy installation. Source in one file. You have to create a program, copy the code and activate it.

Clone this wiki locally