Tables related to a t-code

[Former Member]

hi all,

Is there any way to find the database tables for a specific t-code.

Whenever i use F1 -> technical settings..i always end up in some structure...but hw do i knw the database table used to store the data for it.

regards,

johnson

[Former Member]

Hi,

If you are using SAP version below 4.7, you can use transaction SE49, to get the list of tables used in a Transaction (also for program, function module and dialog module).

Else,

->use ST05 to do activate SQL Trace

->execute the transaction

->Deactivate the SQL Trace

->Display Trace ; you will get a list with all the tables used with the corresponding select statements.

Regards

Kiran Sure

[Former Member]

Hi,

use SQL Tracer with which you can find out the Database tables used in a Transaction.

Just follow the steps to achieve your Requirement.

Go ST05 and

-click the activate trace button,then leave the transaction.

-Run your program either via tcode or directly from SE38,

-after completion of the program,

-go back to ST05 and click the Deacivate Trace button. Now click the Display Trace button,

-in the dialog, just click the green check.

-The next screen is the trace, where it lists all of the database tables that were accessed during the time of the trace, including system tables.

-The duration column will be important when looking for low performing SELECTs, the higher the number, the lower the performance,

-Put your cursor on a line where the OP is "OPEN" and click Explain, here is some good information about the select statement, how the data was accessed, and with which index.

Regards,

Raj.

[Former Member]

If you want to know all the DDIC tables for a particular tcode let's say va03:

call FM RS_PROGRAM_TABLES

and provide these inputs.

OBJECT_TYPE TRAN

OBJECT_NAME VA03

it will give all the tables.....

Another solution:

Trace your complete tcode using sql trace and you will see all the tables used in particular transaction.

Hope this might be of help to you.