Skip to main content
Version: 10.3.2

Receive information about SAP tables

note

The use case shows how to get information about SAP tables. There are two scenarios each of them performing almost the same actions but with different tools.

Scenario A​

  1. Open SAP GUI and log in.

  2. Start the SE16 transaction. Enter the transaction code SE16 into the OK Code field and press Enter.

  3. In the menu, select Settings > User Parameters.

  4. Go to the Data Browser tab, check ALV Grid Display, and press Enter / the OK button.

  5. Enter DD02L into the Table Name field.

  6. Press Number of Entries. The number you see on the screen is the number of all entries that can be copied and used in your workflow.

  7. Thus, you can view the number of tables that meet your selection criteria. Enter a table name into TABNAME (for example, TRANSP or T005 - T006) and press Number of Entries.

  8. Click on the Execute button to view the selected entries.

  9. Press Ctrl + Y for multiple selection and select all the entries in the TABNAME column.

    You can copy the entries and paste them, for example, into an Excel document. The same can be done for any column in the table.

Scenario B​

  1. Open SE16 via the SAP menu. Go to SAP Menu > Tools > ABAP Workbench > Overview.

  2. In the menu, select Settings > User Parameters.

  3. Go to the Data Browser tab, check SE16 Standard List, and press Enter / the OK button.

  4. Press the button next to Table name to open the input help for the field.

  5. Press Information System.

  6. Type DD* into the Table name field and press OK.

  7. Find DD02L in the search results, focus on it, and press OK.

  8. Table name should be filled with DD02L. Click on the Table Contents button to go to the selection screen.

  9. Repeat step 6 from scenario A. Ensure that number of entries is the same.

  10. Press the search help button next to TABCLASS-LOW.

  11. Double-click the TRANSP entry and repeat step 7 from scenario A. Make sure the number of entries is the same as in scenario A.

  12. Press Multiple Selection for the TABNAME field.

  13. Go to the Select Ranges tab and enter T005 and T006 into lower and upper limits respectively.

  14. Press Copy and repeat step 7 from scenario A. Make sure the number of entries is the same as in scenario A.

  15. Press Execute and repeat steps 8-9 from scenario A. Make sure the data is the same.