topic Re: WITHOUT KNOWING DATABASE TABLE, in Application Development and Automation Discussions

WITHOUT KNOWING DATABASE TABLE,

Former Member — Tue, 17 Jul 2007 09:01:36 GMT

WITHOUT KNOWING THE DATABASE TABLE,

IN SE11 TRANSACTION

I WANT TO FIND OUT THE STANDARD DATABASE TABLES

Re: WITHOUT KNOWING DATABASE TABLE,

Former Member — Tue, 17 Jul 2007 09:04:42 GMT

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

Re: WITHOUT KNOWING DATABASE TABLE,

Former Member — Tue, 17 Jul 2007 09:05:03 GMT

Press F4.

You will get the list of the tables.

Regards

azad.

Re: WITHOUT KNOWING DATABASE TABLE,

Former Member — Tue, 17 Jul 2007 09:05:15 GMT

HI ashok

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

regards

sandhya

Re: WITHOUT KNOWING DATABASE TABLE,

jayanthi_jayaraman — Tue, 17 Jul 2007 09:05:43 GMT

Hi,

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

Message was edited by:

Jayanthi Jayaraman

Re: WITHOUT KNOWING DATABASE TABLE,

former_member189059 — Tue, 17 Jul 2007 09:06:55 GMT

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

these are the standard SAP tables

Re: WITHOUT KNOWING DATABASE TABLE,

Former Member — Tue, 17 Jul 2007 09:07:28 GMT

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

Re: WITHOUT KNOWING DATABASE TABLE,

Former Member — Tue, 17 Jul 2007 09:10:52 GMT

Hi,

You can check table DD02L via transaction SE16/SE16N.

Also please check this links.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e944e133-0b01-0010-caa2-be2cb240f657

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

Regards

Re: WITHOUT KNOWING DATABASE TABLE,

Former Member — Tue, 17 Jul 2007 09:12:25 GMT

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

Re: WITHOUT KNOWING DATABASE TABLE,

Former Member — Tue, 17 Jul 2007 09:47:04 GMT

HI ashok,

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

regards,

amit m.