how to get all the table names?

[Former Member]

dear all,

i've a question. is there a table which stores all the table names(standard table and customizing table)? or is there any other way to find the table according to its description?

Thanks for your kindly help in advance.

Desmond

[Former Member]

Hi,

check in table DD02V

[Former Member]

Hi Desmond,

From DD02L you can find the list os all table names and the description is stored in table DD02T.

Regards

Dillip Sahoo

[gerd_rother]

Hi,

The table is DD02L. Take special care of the fields AS4LOCAL (='A') and TABCLASS (see fixed values of its domain).

Regards, Gerd Rother

[Former Member]

Hello,

Normally we want to find tables and fields that are hit during a particular transaction run. SAP updates data into multiple tables and also fetches data from multiple tables in a particular screen of a transaction.

To find the list of tables hit and the corresponding fields we can run the Trace.

The t-code to check the trace is ST05

Procedure for TRACE ANALYSIS:

1) Go to ST05.

2) Activate Trace

3) In another screen run the transaction for which you want to find the fields from tables.

4) Deactivate Trace in ST05.

5) Display the Trace in ST05. Here you will see all the database hits.

Best Regards,

Shree Tejus.

[RaymondGiuseppi]

Tables and descriptions are stored in DD02L, text table DD02T.

You can call the R/3 [Repository Information System|http://help.sap.com/abapdocu_70/en/ABENRIS_GLOSRY.htm], transaction SE15 or SE84, there click on ABAP Dictionary, Basic objs, Database tables.

Regards,

Raymond

[Former Member]

'DD02L' IS FOR THE TABLES......

Try to execute this code u will get all the tables list..... standard and customizing

data itab type table of dd02l.

select * from dd02l into table itab where "tabname BETWEEN 'Z' and 'ZZ' and

tabclass in ('TRANSP', 'INTTAB').

write :sy-subrc .

data fs type dd02l.

loop at itab into fs.

write:/ fs-tabname.

endloop.

[gerd_rother]

Hi,

Actually INTTAB means structures, not database tables.

Regards, Gerd Rother

[Former Member]

This message was moderated.

[Former Member]

Hi the table which stores the table names is dd02l. if you want the text of these table check the table dd02t which stores the description of the table in dd02l.

Thankyou,

Jerry Jerome

[matt]

The table to find descriptions as requested is not DD02L. It is DD02T or DD02V, as posted by Dillip Kumar Sahoo and Madhukar Shetty respectively, with a fully answer of how to find a table based on descriptions from Raymond Giuseppi.

All responses with just DD02L - well, you didn't read the question. And the one involving ST05... again, it doesn't answer the question.

I think we can consider this thread answered now.

[RaymondGiuseppi]

I will Just add that DD02V is a view (DD02L join DD02T) and not a table. (the question was "is there a table which stores..."

Regards,

Raymond

[Former Member]

Hi,

Please close this thread if you got the answer.

Regards

Dillip