Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
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?
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.
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?
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.
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....
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.
Bluesky
