Similar to se16, you can now preview the data in any Dictionary Table, Dictionary Views, External Views and Core Data Service(CDS) DDL artifacts using the Data Preview tool.
To start the data preview, select the Dictionary table, view, or CDS artifacts in the project explorer and choose the context menu “Open Data Preview”
The data preview loads the top 100 records persisted in the Dictionary table, view, or CDS artifacts. The max rows that are loaded in the data preview is configurable upto 5000. To change the value, enter the numbers of records to be loaded in Max Rows textbox.
If you do not wish to see all the columns in the table, simply click on the “Select Columns” button, and choose the columns that you wish to see and press OK. The data preview is refreshed to load the top 100 records(as configured in max rows) for the columns that you have selected.
You can sort any columns by ascending or descending order. The records in ascending or descending order are fetched from the from the ABAP server.
You can also add one or more complex filters in data preview, by clicking “Add Filter”.
Data preview fetches only those records that match all the filter criteria.
You can choose one of following filters to define any complex filters
Another rapid way of adding filters is by selecting any cell in the table and choosing the Quick Filter context menu. This will add the filter for that column matching the value in the cell.
In the below e.g. the filter BOOKID = 00000004 will be added.
You can also quickly search for a matching regular expression pattern via the local filters. Adding the local filter immediately highlights all the values in table that matches the regular expression pattern.
In this e.g. all the values matching *05* is highlighted in blue.
If you wish to view all the distinct values for a given column, simply right-click on the column and choose Distinch Values for [column name]
The dialog shows all the distinct values for CARRID along with the total count and its distribution.
If you wish you view the open SQL query that was executed for any of the operation, click on the Show Log button.
This dialog shows all the open SQL queries that were executed in the ABAP server to fetch the results. It also shows the time taken to execute the queries.
Finally, all the records loaded in data preview can be downloaded into your local system by choosing save as option. You can save the records into a CSV file, HTML file or an XML file