Skip to Content
Author's profile photo Peter Atkin

FAQ: Finding Tables in SAP

How to find tables in SAP:

  1. Select the required field
  2. Press F1 for help
  3. Select the Technical information button (hammer/spanner), or press F9 if you are using the old style help dialog screen
  4. Double-click on the data element field
  5. Double-click on the domain field (provided it isn’t something like CHAR1, otherwise go to step 6)
  6. Select the where-used button (button with little yellow square with 3 arrows radiating)
  7. Select indirect application from the pop-up box
  8. Double-click on the Database Tables line in the next pop-up box
  9. You should now have a list of all DB tables where that field is used (this should work in about 90% of cases)

Alternatively:

  1. Run TCode ST05 (performance analysis)
  2. Press <activate trace> button
  3. Enter the transaction you want to use (e.g. /NIW32) in the command code box
  4. Enter an order number in the Order sub-screen
  5. Execute, or F8
  6. Enter /NST05 in the command code box
  7. Press the <deactivate trace> button
  8. Press the <display trace> button
  9. Review tables

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo K Jogeswara Rao
      K Jogeswara Rao

      Very Useful Document.

      Author's profile photo Matthias Hübner
      Matthias Hübner

      easy in use and very helpful.

      Author's profile photo Former Member
      Former Member

      Easily identifiable.

      Author's profile photo Former Member
      Former Member

      Nice document.

      Author's profile photo AMEET. V. DESAI
      AMEET. V. DESAI

      Wow !!!! What a super time saving information. I used to spend hours finding a table.

      This is absolutely amzing, never knew this.

      Thanks a million Pete.

      Author's profile photo Henryk Skrobol
      Henryk Skrobol

      Sometimes I'm also using transaction DB15 to get all tables for archiving object.

      Having one table (let's say for example EQUI) we can find archiving object PM_EQUI and then in bottom part of the screen we can determine all other tables in archiving object PM_EQUI (which means all tables which possibly can have some links ....)

      Author's profile photo Former Member
      Former Member

      Thank you

      Author's profile photo Former Member
      Former Member

      Hi Peter,

      Thanks for sharing the information.

      Regards,

      Ankita.

      Author's profile photo Naren Karra
      Naren Karra

      Good document Peter Atkin.

      Regards,

      Krishna.