2007 Mar 14 11:48 AM
hi
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.
2007 Mar 14 11:51 AM
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
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.
2007 Mar 14 11:51 AM
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
2007 Mar 14 11:51 AM
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
2007 Mar 14 11:52 AM
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.
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |