check table exists

[Former Member]

Hello

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

Greets

[Former Member]

Hello

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

Greets

[ThomasZloch]

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

Cheers

Thomas

[JozsefSzikszai]

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

ec

[Former Member]

EXISTS TABLE

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

regards

[Former Member]

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.

[Former Member]

check in table : DD02L

[Former Member]

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.

[former_member184158]

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