topic Re: Tables exist in database in Application Development and Automation Discussions

Tables exist in database

Former Member — Thu, 06 Mar 2008 03:14:25 GMT

Hi,

Is there a way to check if the table that I input is exist in sap database?

For example,

check against zabc in se11. It does not exit. Thus, return the error message to user.

I need to kind of function in my current program.

Please help.

Re: Tables exist in database

Former Member — Thu, 06 Mar 2008 03:24:28 GMT

Hi,

select tabname from DD02l into dd02l-tabname

where tabname EQ 'zabc'.

IF sy-subrc NE 0.

WRITE :/No table existed.

ENDIF.

Re: Tables exist in database

Former Member — Thu, 06 Mar 2008 03:31:06 GMT

hi,

In this case:

if sy-subrc NE 0.

message EXXX.

endif.

if u display as an error msg then only if u enter the correct value u can process it else it won't.. if u don't want it to be displayed as error msg go for Warning(W) , Information(I) instead of E.

Thanks

Arunprasad.P

Re: Tables exist in database

Former Member — Thu, 06 Mar 2008 03:38:24 GMT

Thanks.

select tabname from DD02l into dd02l-tabname is what i am looking for. Thanks

Re: Tables exist in database

Former Member — Thu, 06 Mar 2008 05:43:40 GMT

Hi ..

if i wan to check on fields, may i know what table can i use?

Re: Tables exist in database

Former Member — Thu, 06 Mar 2008 05:47:23 GMT

found it .. Use DD03L.

Thanks.