Find relation between tables

[Former Member]

Hi experts,

How can I find the relation between tables? I mean, I can go to se 11 and compare each field of 2 tables manually, but it's very time consuming. Is there any possibilty to compare tables and find all the fields that can be found in both table?

[Former Member]

Go to SQVI transaction... Create a qucik view.. ztest.. give desc..etc

Select data source as table join.... enter

now one screen will come with blank data (blue scrren)

in that application toolbar second button .. click that.. enter VBAK..

click that again.. enter VBAP.. now an image will come with links b/w vbak and vbap.. you can use any no. of tables there....

[Former Member]

above method will give common fields only..

for all common fields do as follow

copy fields of table1 into excel sheet

copy fields of table2 into another excel sheet

sort fields and then search out for common fields using VLOOKUP functionality of excel sheet

[Former Member]

How can I copy all field in 1 step? Because I can copy using ctrl+y only 1 page in 1 step.