Skip to Content

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
To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. 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.

    (0) 
  2. 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 ….)

    (0) 

Leave a Reply