Listing tables

[Former Member]

Dear Abap  Gurus

I am sd consultant ... i have one doubt regarding Tables

suppose if i want to know some tables i use to click F1 and technical information then we can see table names

But somo teables are there like

Order reason IN VA01 is VBAK BZ IT IS HEADER DATA

and if we want to see the report based on order reason we use Table name TVAU

Now my doubt is if i dont know the table then how to check my self ?

[Former Member]

Debug the program, it will help you to trace data movement from Tables.

[vinoth_aruldass]

hi venu,

in va01 after getting the screen where order reason is present

in menu

goto -> system -> status -> double click on program -> you can see one top  include there

in that you can find all the tables and the structures which are all used for the transaction .. from there you can get the table name..

hope it helps,

Vinoth

[Former Member]

Dear i am unable to find the program in status

pl could u explain me litle bit more plz

thank you so much i hope on you

[vinoth_aruldass]

hi,

in the transaction menu you can see sytem -> sttus.

then one popup will open in that double click on program ..

then follow the above procedure..

hope it helps,

Vinoth

[Former Member]

Hi Venu,

You can perform SQL Trace by using the transaction ST05. this will give you a complete picture of  all the actions  performed and which are tables that are being used.

Refer this link for complete details on SQL Trace :- http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/5a1de990-0201-0010-8d83-a06bdda1d...

Regards,

Faiz

[FredericGirod]

Hi Venu,

start in an other dynpro the transaction ST05

-> activate the trace

Used you transaction VA01 to create your sales order

In ST05

-> Deactivate the trace

-> Display the trace (remove all the D* tables)

Go in the menu, and select the summurize entry.

You will have the list of all the tables used in your transaction (but not the buffered, for this you have to select buffered tables in ST05, but it's more complex) and the condition of this access (and the time consumption, the number of entries ...)

Fred

[Former Member]

Hi,

Go to transaction SE80 -> Edit Object -> Transaction -> VA01 -> Click ok

Now click on display object list.

When you click on display object list, this will show all the database tables used by the transaction.

Attached are screenshots for your reference.

Hope this helps.

Thanks,

Tooshar Bendale