Determining relationships between tables

[Former Member]

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?

[Former Member]

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

[Former Member]

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

[Former Member]

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...

[Former Member]

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

[Former Member]

hi

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