Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

where can i find out all the standared table name

Former Member
0 Kudos

Dear Friend,

could you please tell me where can i find out all the standard table names,

( for example: tstc for find all the T-codes) .

1 ACCEPTED SOLUTION

raviprakash
Advisor
Advisor
0 Kudos

HI Srinivas,

DD02L has the name of all the TABLES in the SYSTEM. It has both SAP and Customer's TABLES.

First of all exclude all Z* and Y* tables from dd02L. Still there are many tables in CUSTOMER NAMSPACE.

So make a program, LOOP at all entries of DD02L and then check the name space of each entry using the function module:-

<b>TRINT_OBJECT_NAMESPACE_INFO</b>.

If the namspace is not EQUAL to 'S', then dont count that entry else add one to the counter.

This would tell you all SAP Standard Tables in the system.

Thanks and regards,

RAVI :).

NOTE: Points keep me alive on SDN .

8 REPLIES 8

Former Member
0 Kudos

Hi!

Check out this link.

http://www.erpgenie.com/abap/tables.htm

Regards

Tamá

Former Member
0 Kudos

<b>DD02L</b>

If u exclude Z* and Y* u will get the standard tables.

reward if u find helpful.

Former Member
0 Kudos

trdir/tadir

you would find all the tables standard/custom

anversha_s
Active Contributor
0 Kudos

hi,

Chk DD02V -Data dictionary tables

Regards

Anver

Former Member
0 Kudos

<b>DD02L - This table contains all standard and user defined tables

Field is TABNAME - Table name</b>

raviprakash
Advisor
Advisor
0 Kudos

HI Srinivas,

DD02L has the name of all the TABLES in the SYSTEM. It has both SAP and Customer's TABLES.

First of all exclude all Z* and Y* tables from dd02L. Still there are many tables in CUSTOMER NAMSPACE.

So make a program, LOOP at all entries of DD02L and then check the name space of each entry using the function module:-

<b>TRINT_OBJECT_NAMESPACE_INFO</b>.

If the namspace is not EQUAL to 'S', then dont count that entry else add one to the counter.

This would tell you all SAP Standard Tables in the system.

Thanks and regards,

RAVI :).

NOTE: Points keep me alive on SDN .

Former Member
0 Kudos

Hi,

u can find from dd02l.

The table DD02L contains all the standard tables which may be of types such transparent, pooled and clustered tables but this completely depends on your sap system configuration.

Regards,

Sruthi

Former Member
0 Kudos

Hi Rathod,

DD02L contains all table names .DD03L conrtains all Table fields.