SAP tables

[Former Member]

Hi!

Is there available a list of tables that appear in basis? I'm interesting to do a abap-report that will print out for example last backup, is there critical tables etc. and i am trying to find the tables where i could get this information. So, i'm looking for a book or just a internet-link where i could find a complete list of tables of basis. I hope that you understand what i mean

[Former Member]

I am not in favour of this approach. There are tens of thousands of tables in SAP. What tables do you consider relevant for you? How are you planning on linking all the data? There are several questions.

Please remember that R/3 is not a database application with a bunch of tables linked together. It is a business application and tables are only data repositories. You will ask questions like how do I pull sales order data rather than asking all the tables in SD module.

Please let us know which details do you want to capture and for what purpose. Then may be it will be easy. I know you will get some responses with several table names but I would not want to approach that way.

Srinivas

[Former Member]

Hello,

Sorry that i asked too much, i need information about tables where to find information for transactioncodes db02, db12, sm21, sm37. I don't need a ready code, just tables where the data of theese lays or better way to find my self this

[Former Member]

The best way to find out the tables is to run the transaction, in the menu 'system-->status' will tell you the program that is controlling the transaction logic. Go to SE80 and give that program name. It will list out all the tables used in the folder 'Dictionary Structures'.

But this is not the complete list, if the programs are calling function modules to get some data. In that case searching for the tables will become even more complicated.

The transactions you mentioned are all related to logs. Now here it becomes the worst nightmare. Logs are not stored in the database as plain text for you to be able to simply query and report. They are stored on the server as raw data and can only be accessed through some special functions.

The best way to get all the logs is to find the function modules to use. I don't have the names but if I find them I will post them here.

Some tables that you might want to look at are MONI, DBCHK, SDBAD, DBABD, SDBAH, TBTCO, TBTCP, TB*(most of them) etc.

Srinivas

[Former Member]

Thank you, this is quite the thing that i needed and i think that this will give me information in this thing and also later.