Application Development and Automation 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: 
Read only

WITHOUT KNOWING DATABASE TABLE,

Former Member
0 Likes
931

WITHOUT KNOWING THE DATABASE TABLE,

IN SE11 TRANSACTION

I WANT TO FIND OUT THE STANDARD DATABASE TABLES

9 REPLIES 9
Read only

Former Member
0 Likes
908

all tables which dont start with z or y are standard database tables i guess

Read only

Former Member
0 Likes
908

Press F4.

You will get the list of the tables.

Regards

azad.

Read only

Former Member
0 Likes
908

HI ashok

u can use se15 tcode but for that a atleast u should know field name of that table.

regards

sandhya

Read only

jayanthi_jayaraman
Active Contributor
0 Likes
908

Hi,

Use table DD02L and in selection give a* to x* for tabname.

Message was edited by:

Jayanthi Jayaraman

Read only

former_member189059
Active Contributor
0 Likes
908

Go to the DD02L table and search for all records where AS4USER = 'SAP'

these are the standard SAP tables

Read only

Former Member
0 Likes
908

Hi

All std objects have the name not beginning with Z, Y or X, so the std tables too.

In SE11 press F4 and search all tables with the name not in Z, Y or X*.

Max

Read only

Former Member
0 Likes
908
Read only

Former Member
0 Likes
908

Hi

from Se11

keep the cursor on TABLE radiobutton press the F4 button against that Tables

you will get a window

there enter some rough Text like ustomer to find customer related tables like that

and press enter

you will se lot of tables related to that text or if you execute without any text you will see a lot of tables

<b>Reward points for useful Answers</b>

Regards

Anji

Read only

Former Member
0 Likes
908

HI ashok,

<b>1. DD02L</b>

2. This table contains the name of all the database tables as well as structures.

regards,

amit m.