FAQ: Finding Tables in SAP
How to find tables in SAP:
- Select the required field
- Press F1 for help
- Select the Technical information button (hammer/spanner), or press F9 if you are using the old style help dialog screen
- Double-click on the data element field
- Double-click on the domain field (provided it isn’t something like CHAR1, otherwise go to step 6)
- Select the where-used button (button with little yellow square with 3 arrows radiating)
- Select indirect application from the pop-up box
- Double-click on the Database Tables line in the next pop-up box
- You should now have a list of all DB tables where that field is used (this should work in about 90% of cases)
Alternatively:
- Run TCode ST05 (performance analysis)
- Press <activate trace> button
- Enter the transaction you want to use (e.g. /NIW32) in the command code box
- Enter an order number in the Order sub-screen
- Execute, or F8
- Enter /NST05 in the command code box
- Press the <deactivate trace> button
- Press the <display trace> button
- Review tables
Very Useful Document.
easy in use and very helpful.
Easily identifiable.
Nice document.
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.
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 ....)
Thank you
Hi Peter,
Thanks for sharing the information.
Regards,
Ankita.
Good document Peter Atkin.
Regards,
Krishna.