topic Re: Listing tables in Application Development and Automation Discussions

Listing tables

Former Member — Fri, 15 Feb 2013 06:14:26 GMT

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 ?

Re: Listing tables

Former Member — Fri, 15 Feb 2013 06:18:45 GMT

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

Re: Listing tables

vinoth_aruldass — Fri, 15 Feb 2013 06:32:36 GMT

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

Re: Listing tables

Former Member — Fri, 15 Feb 2013 07:15:01 GMT

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-a06bdda1d7d5?QuickLink=index&overridelayout=true

Regards,

Faiz

Re: Listing tables

Former Member — Fri, 15 Feb 2013 07:46:06 GMT

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

Re: Listing tables

FredericGirod — Fri, 15 Feb 2013 07:53:25 GMT

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

Re: Listing tables

vinoth_aruldass — Fri, 15 Feb 2013 07:53:34 GMT

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

Re: Listing tables

Former Member — Fri, 15 Feb 2013 08:37:31 GMT

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