Tables

[Former Member]

Hai all,

1. How to know the tables and fields in the T.code Va01, Xd02

2. What are programs? How we know which program we are running?

Regards,

Kedar.s

[Former Member · Accepted solution]

Hi Kedar,

To know which tables, after executing either VA01 or XD02, keep the cursor in one of the fields and press F1. Then click on technical information. In the technical information screen double click on the table name.

As regards to programs, you can know which program is running by clicking on the status bar at the bottom of the SAP Screen

prasanna

[former_member195032]

Hi Kedar,

It is easy to do.

I will tell you tricks.

You need to ST05 transaction access.

Open two SAP screens in system. In one screen open ST05 and check box should be as SQL trace.Activate the trace by clicking Activate.

Open another transaction VA01 in other screen,when this transaction is run once ,it must be calling some transaction table.

Deactivate Trace in other screen.

Display trace,it will open a new window which will show you details of all select statements.

Generally if you have SAP experience you will be in position to differntiate in System tables and transaction tables.

If you are running any program,see it's package name,generally tables will start with that package name as initial.

Suppose Some package is ABC_EFG

then generally SAP sets rules as table name will ABC.

You can activate Trace N number to time to see from where all these data are picked.Just activate and deactive after doing any execution in screen and you will get the table name.

The output report is little tough to understand.Just spend some time,u will get the needed.

2. To know the program name ,run the transaction. ...go to system -> status -> SAP data box you will get transaction name and program name as well.

I hope this helps..

Nishant

Please reward if this helps.

[Former Member]

Hi Kedar,

To know what are tables associated to a transaction, use transaction SE80(Object Navigator).

1) Goto SE93, Give your transaction code eg: VA01 or XD02

2) Click on Display

3) Get the program associated with the transaction. Most of the time for standard transactions the program always starts with SAP.

4) Give this program name in the SE80 transaction by selecting the program name.

5) Click on Display

6) Click on tables and structures folders in the bottom. This will show you the list of tables used in this transaction.

To know a current program, use the system field SY-CPROG/SY-REPID to get it

Thanks,

Vinay

[Former Member]

<u><b>Tables:-</b></u>

<b>Link</b>: http://www.sap-img.com/

<b>Topic</b>: Free ABAP eBook Download

SAP MM, SD, FI, PS, PP, PM, HR, System Tables

Regards,

Rajesh Banka

Reward Points if helpful.