topic Re: Link between tables in Application Development and Automation Discussions

Link between tables

Former Member — Fri, 14 Nov 2008 09:57:31 GMT

Hi,

how can I find the links between tables ?

I remember it is possible by a trx to look at links between tables, the trx shows a flow chart

with the link between all SAP tables.

Best regards

Former Member — Fri, 14 Nov 2008 09:59:11 GMT

You can use transaction SQVI

Former Member — Fri, 14 Nov 2008 10:09:32 GMT

Hi,

Use T.Code SQ01

Former Member — Fri, 14 Nov 2008 10:10:16 GMT

hi,

goto SE11->enter the name of the table you want to find the link.

for e.g EKKO. Press display .

On the application Table there is a button 'Graphic' (CTRLSHIFTF11). Press this button

to get list of table which are linked .You see a screen with the list of all tables which are linked

and on that screen when u press back u get a graphical flow chart box where u see all the tables

and their link .They will be shown in green color.

The below Step only works if you know some tables

other way is u can do it with SQVI transaction.Its called as Quickviewer screen.Create a view

by entering some name and press create .Its prompts for a dialog box and enter some title.

Below there is a drop list in DATA Source tab Choose table join and press enter.

Go to EDIT option in menu bar and enter the name of the table which u know. ADD similar tables

and if there is any link it will be shown below.

Former Member — Fri, 14 Nov 2008 10:11:53 GMT

Hi,

Goto the table for which you want to find the links from SE11.

Click on display.

Click on Graphic Button or CTRL + SHIFT + F11.

Regards,

Swapna.

Former Member — Fri, 14 Nov 2008 10:20:57 GMT

Hi,

In SQ02 we can find out the link between two tables.