topic Re: Determining relationships between tables in Application Development and Automation Discussions

Determining relationships between tables

Former Member — Wed, 10 Dec 2008 08:57:01 GMT

Hi all,

I would like to know if it is possible to determine how tables are related to each other (foreign ley relationship) using some pre built ABAP program if it already exists. Else, can you please tell me how we can do this using any other method?

Re: Determining relationships between tables

Former Member — Wed, 10 Dec 2008 09:01:12 GMT

Hi,

Follow this process. You can easily discover the relationships among tables.

1. Use SQVI transaction,
2. Create a View
3. Enter title,
4. Choose the Data source as Table Join
5. Now use Insert table option.
6. And insert the tables which you want. It will propose the relation between them.

Thanks

Nitesh

Re: Determining relationships between tables

Former Member — Wed, 10 Dec 2008 09:01:59 GMT

go to SE11 and give some tbale name and dispaly then agagin click graphic button or press

controlshiftF11

you can see the realtion between tables with your enterd table...

Re: Determining relationships between tables

Former Member — Wed, 10 Dec 2008 09:02:11 GMT

hi sam,,,,

just go to se11, and display the contents of table,

In the Application tool bar there is a button Where-used-list with icon of 3 arrows, click on that button then a POP-Up will come select the check-box of DB tabel and uncheck all other checkbox...

it will give the list,, no report available for that functionallity this can be achieved with se11 only....

Thanks

Saurabh

Re: Determining relationships between tables

Former Member — Wed, 10 Dec 2008 09:13:50 GMT

just try to follow these steps

Use SQVI transaction->Create a View>Enter title->Choose the Data source as Table Join->Now use->Insert table option->And insert the tables which you want. It will give you the relation between them.

hope this helps

regards

Aakash Banga