topic Re: check table exists in Application Development and Automation Discussions

check table exists

Former Member — Tue, 25 Mar 2008 14:00:46 GMT

Hello

How can I check if a table exists when I have the name, for example entered by the user. ?

Greets

Re: check table exists

ThomasZloch — Tue, 25 Mar 2008 14:02:49 GMT

table DD02L holds all table names, have your program check there wether a table exists.

Cheers

Thomas

Re: check table exists

JozsefSzikszai — Tue, 25 Mar 2008 14:04:01 GMT

hi Bert,

tables are stored in table DD02L in SAP. So best is to do a SELECT COUNT ... on DD02L e with the table name entered by the user...

hope this helps

Re: check table exists

Former Member — Tue, 25 Mar 2008 14:04:23 GMT

EXISTS TABLE

[http://sapdb.org/7.4/htmhelp/6d/117c20d14811d2a97400a0c9449261/content.htm]

regards

Re: check table exists

Former Member — Tue, 25 Mar 2008 14:05:54 GMT

Hi,

Go to SE12.

Enter any table in which that field exists for which you want to see the check table.

Double click on the field name.

Incase a check table exists, it will be displayed in the screen which comes.

Reward if helpful.

Regards.

Re: check table exists

Former Member — Tue, 25 Mar 2008 14:06:44 GMT

check in table : DD02L

Re: check table exists

Former Member — Sat, 08 Aug 2015 11:36:59 GMT

Hi,

a bit late but for the others, do not request everytime the table with a SELECT but prefer MF available for and used for several cases.

MF: INTERN_TYPE_KIND

Return the kind of the DDIC Object given or nothing if does not exists.

Rachid.

Re: check table exists

former_member184158 — Sun, 09 Aug 2015 07:15:41 GMT

Hi,

there is another FM you can use it,

call function 'DDIF_TYPEINFO_GET'
       exporting
            typename = 'ZIBO_URL_ALV'
       importing
            typekind = ty.

or this table,

you can select from this table DDTYPES,

it is the same if you want to use SELECT or FM.

At the end, it depends on your requierement, for example, you have FM that does not fulfill requirements.

Regards

Ibrahim