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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to check one table exist or not in SAP

Former Member

‎10-10-2008 8:56 PM

0 Kudos

Hi, Gurus:

How to check one table exist or not in the SAP.

Thanks,

5 REPLIES 5

Former Member

‎10-10-2008 9:01 PM

0 Kudos

Hi,

Goto Transaction code SE11 or SE16, Enter the table name and click display. SAP will give you a message at the bottom of the screen if the table doesnot exist.

Former Member
In response to Former Member

‎10-10-2008 9:02 PM

0 Kudos

This way I know, I mean how to use code to check table exist or not.

Former Member
In response to Former Member

‎10-10-2008 9:05 PM

0 Kudos

Use it in a TABLES statement. If it doesn't exist, you will get a syntax error.

Rob

Former Member

‎10-10-2008 9:09 PM

0 Kudos

Hi,

ALL tables will be stored in Table DD02L.

Try put a select query on this table to check for the table you wish.

Hope it helps.

Former Member

‎10-10-2008 9:10 PM

0 Kudos

Hi,

Query the table DD02L..

Select single * from DD02L where tabname = 'Your table name'
                      AND TABCLASS = 'TRANSP'.  " For transparent tables.

Thanks

Naren