topic Re: required program in Application Development and Automation Discussions

required program

Former Member — Wed, 14 Mar 2007 11:48:05 GMT

i wanted the program to display the table names when ever i enter a field name as a parameter....

for example

when ever i enter a parameter as carrid it should display all the table names to which it belongs and also should tell the relationship in that table....

that is ...... its a primary key or a foreign key in that particular table.

Re: required program

Former Member — Wed, 14 Mar 2007 11:51:06 GMT

data : p_field like dd03l-fieldname.

data : begin of it_tables occurs 0,
         tabname like dd03l-tabname,
         keyflag like dd03l-keyflag,
       end of it_tables.

select tabname keyflag from dd03l into table it_tables where fieldname eq p_field.

keyflag determines if it is key field or not

Message was edited by:

Chandrasekhar Jagarlamudi

Re: required program

Former Member — Wed, 14 Mar 2007 11:51:25 GMT

Hi,

Check the tables:

DD03L - for table fields

DD03t - for table field descriptions

DD02L - for tables

DD02T - for tables descriptions

and other tables starting with DD0*..

regards,

Anji

Re: required program

Former Member — Wed, 14 Mar 2007 11:52:27 GMT

u can go for where used list.

enter dataelement in se11, then press where used list icon,

it wil give the table name and relationship also.

regards,

sujatha.