03-26-2007 10:48 AM
Hi Folks,
Lets take a scenario of populating an ouput internal table with fields from 4 unknown sap tables(relation between the tables is unknown). How can we check the relationship between those tables to populate the internal table..? What are the possible ways to check the relationship between tables..?
Can u please help me on this.
Thanks n regards,
ram.
03-26-2007 10:51 AM
Hi
you can check the relationship between those tables using abapquery
t code SQ02. crete a new one and enter the tables from that u can find the realtion ships.
M Kalpana
03-26-2007 11:05 AM
hi,
go to sqvi ,in creation mode, in table join area if u enter all four tables system would suggest what is the relationship between all the tables and fields
reward if this helps !!!!!
03-28-2007 6:45 AM
Hi <b>Ram</b>,
I tried the following method to find relation between tables and i think it is quite useful. I hope this will be of some use to you.
-> Goto SE11 and display one of the tables.
-> Click on the <b>Graphic</b> icon on the toolbar or use shortcut ctrlshiftF11
-> It displays all the related tables by foreign key and even gives you all check tables involved. If the list is a long one, you can even use <u>Find</u> option to check if the other tables you are trying to find relation with, exist in the screen.
Hope this Helps!! Do get back!!
Regards,
<b>Naveenan</b>.
11-20-2007 3:11 PM