FM to get table names based on data element

[Former Member]

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

[former_member194669]

Please check DD03L

a®

[matt]

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

matt

[Former Member]

Hi,

Check the table DD03L with field ROLLNAME

[Former Member]

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

[Former Member]

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

Thanks,

Sudheer. A

[Former Member]

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