topic Re: FM to get table names based on data element in Application Development and Automation Discussions

FM to get table names based on data element

Former Member — Thu, 09 Apr 2009 17:38:27 GMT

Hi,

Is there any FM to get table names which contain a particular data element. My requirment is I need tables which have LAND1 as data element and I need to cross verify some particular country codes. in all these tables.

Thanks in advance,

Sudheer. A

Re: FM to get table names based on data element

former_member194669 — Thu, 09 Apr 2009 17:42:15 GMT

Please check DD03L

a®

Re: FM to get table names based on data element

matt — Thu, 09 Apr 2009 17:42:20 GMT

DD03L. Field "ROLLNAME" is the data element. TABNAME is the table.

matt

Re: FM to get table names based on data element

Former Member — Thu, 09 Apr 2009 17:43:24 GMT

Hi,

Check the table DD03L with field ROLLNAME

Re: FM to get table names based on data element

Former Member — Thu, 09 Apr 2009 17:43:41 GMT

Hi,

You can use the table DD03L to check for the tables that have used the data element (ROLLNAME).

Ex..

SELECT TABNAME
             INTO TABLE T_TABLES
             FROM DD03L 
            WHERE ROLLNAME = 'LAND1'.

Thanks

Naren

Re: FM to get table names based on data element

Former Member — Thu, 09 Apr 2009 19:10:33 GMT

Thanks for your reply But I need only tables, it is giving structure, views and all. How to restrict.

Thanks,

Sudheer. A

Re: FM to get table names based on data element

Former Member — Thu, 09 Apr 2009 19:12:45 GMT

Hi,

Once you get the table name from DD03L go to the table DD02L to check if it table or structure..

For this you can use the field DD02L-TABCLASS

Thanks

Naren