Simple Data Explorer - Multi-windows program for viewing SQL tables and links between them, build Joins and Pivot Tables with dynamic SQL queries
Simple Data Explorer - Multi-windows program for viewing SQL tables and links between them, build Joins and Pivot Tables with dynamic SQL queries
Multi-window explorer for SAP tables, views and CDS views — with per-window select-options that re-read the data as you type, drag-and-drop links between windows, foreign-key navigation, a join builder, pivot tables and a generated Open SQL statement you can edit and run.
Version 2 (SelecTor) lives in src/ and is the version documented here. The older
single-file viewer is still shipped for old releases — see
History and older documentation.
Also outside SAP GUI. The table grid with its select-options, the join builder and the pivot are available in Eclipse ADT and in VS Code through VERTEX · Marketplace. The ADT resources under
src/and documented in ADT.md exist for it: they serve this tool's data as JSON, and the editor renders it.In the construction phase. VERTEX shows a part of what SDE does, not all of it.
PAxxxx-PERNR) and
organizational management objects (HRPxxxx).
CL_GUI_* controls (ALV grid, HTML viewer,
splitter, dialog boxes); layouts are saved through frontend services.src/. For older systems use the
legacy one-file versions.S_TABU_* authority checks of its own — treat it as a developer/support tool and install it
accordingly.https://github.com/ysichov/Simple-Data-Explorer.git
and assign it to a package (for example $ZSDE for a local one).ZSDE2 (SE38 / SA38).No package, no abapGit, nothing to activate except one report:
Z_SDE_STANDALONE) in SE38.src/z_sde_standalone.prog.abap.The file is generated from the sources in src/ — do not edit it by hand.
Generation 1 of the viewer, kept for old systems and for the HR flavour:
| File | Target | Notes |
|---|---|---|
SDE_702.abap | SAP_BASIS 7.02 | Report YS_SDE |
SDE_750_HR.abap | SAP_BASIS 7.50 | HR/HCM build, infotype texts (PAxxxx-ITXEX) |
ZSDE2.| Field | Meaning |
|---|---|
| Tables / Views / CDS | Switches the input field. Tables accepts transparent and cluster tables, Views any DDIC view (F4 lists the maintenance views of SM30), CDS the SQL view generated for a CDS entity (application class SDGV). |
| Table / View / CDS name | F4 is available in all three modes. The name is checked before the window opens. |
| Max rows | Row limit of every read, 500 by default. It also caps the statements the Tools area runs. |
| Folder for saved joins | Frontend folder for .sdj layout files, C:\temp\sde\ by default. F4 opens a directory browser. |
A window is a dialog box split into the selection panel (left, collapsible) and the data grid (right). When the Tools area is opened, it is docked below the data.
| Button | Description |
|---|---|
| Show/hide select-options | Collapses the selection panel and gives the width to the grid. |
| Refresh | Re-reads the data with the current filters. |
| Load join layout | Reads a .sdj file; opens the Tools area if needed. |
| Save join layout | Writes the current tables, fields, mode, filters and SQL to a .sdj file. |
| Languages | Menu: Technical name plus every language installed in the system. |
| Empty columns options | Menu: Hide empty columns / Show empty columns. |
| Table links | Opens the graphical link visualization. |
| Tools | Docks the join and pivot builder below the data (click again to hide). |
| Sort ascending / descending | Builds ORDER BY on the marked columns — see Sorting. |
| Standard ALV functions | Shows or hides the standard ALV toolbar (export, layouts, find, …). |
One row per field, with the dictionary information next to it — data element, domain, data type and length. This is meant to save time while writing technical specifications.
ELEMENT column SE11 with the data element, on the
DOMAIN column SE11 with the domain, on any other column the documentation of the data element.EQ, BT, NE, CP, …).
Typing is interpreted the way an experienced user expects:
| Input | Result |
|---|---|
| a value in low | I EQ value |
| values in low and high | I BT low high |
a value containing *, %, + or & | I CP pattern |
| clearing sign and option | the row is cleared |
| a date or time | converted from the user format into the internal one |
Empty columns are hidden after every read, so a 200-column table shows only what actually carries data. Show empty columns brings them all back.
The Languages menu lists every language installed in the system plus Technical name. The choice re-translates the grid headers and the labels of the selection panel.
The sort buttons do not sort the fetched rows on the frontend — that would sort the wrong 500
rows. They build an ORDER BY and read again from the database. Mark one or more columns (or just
place the cursor in one) and press the sort icon. Because the statement is built by the Tools area,
sorting requires Tools to be open; the program says so if it is not.
The colour of a column tells what a double-click will do:
| Colour | Meaning |
|---|---|
| Blue | The field has a check table: it opens in a new window, filtered by the value you clicked. |
| Green | A plugin handles the field — a transaction, or a related table that no foreign key describes. |
| Grey | A column of the text table, joined to the data automatically so the language-dependent text stands next to the code. |
| White | A plain field. |
Select one or more cells or a whole column in a data grid and drag them onto the selection panel of another window. The dragged column turns into buttons in the source window, an inheritance indicator appears next to the receiving field, and clicking a button in the source re-reads the target window with that value. Dragging between two selection panels works the same way. A data model of several tables comes alive in about a minute.
Delete receiver in the context menu of the selection panel breaks the link again.
The Table links button opens the graphical visualization of the foreign key relations of the current table, the same picture SE11 draws.
Links that no foreign key describes are hard-coded as plugins.
By data element:
| Data element | Action |
|---|---|
PERSNO | PA20 for the personnel number, with infotype, subtype and validity dates prefilled |
HROBJID | PP01 for the OM object |
LGART | Wage type text table T512W |
ITXEX | Long text of the infotype record, in a text viewer window |
SUBTY | Subtype table of the infotype |
By table and field:
| From | To |
|---|---|
PA0001-PLANS / ORGEH / STELL | HRP1000, object type S / O / C |
HRP1001-SCLAS / SOBID | The related OM object — it is put into the search parameters of the same window, so you can walk the structure link by link |
HRP1001-ADATANR | The additional data table of the relation |
HRP1002 / HRP1035 / HRP1222, field TABNR | HRT1002 / HRT1035 / HRT1222 |
PA2006-QUONR | PTQUODED, and from there back to PA2006 / PA2001 |
HRPY_RGDIR-SEQNR | Payroll cluster viewer |
A double-click on a sequence number in HRPY_RGDIR opens the payroll result of that personnel
number and sequence number as a tree: every cluster table of the result is a node, and each node
opens in a normal SDE window with filters, empty-column handling and everything else.
The Tools button docks a builder below the data of the window: an HTML canvas on top (the join graph, or the pivot cross), the field list, the generated SQL, and the result grid.
Two cards switch the mode — Join and Pivot table. Clicking the active card again turns the mode off and leaves the plain table behind.
为保持页面易读性，当前仅展示 README 的前半部分。请打开原始 README 阅读完整内容。