topic Re: Tcode to see the sql join in Application Development and Automation Discussions

Tcode to see the sql join

Former Member — Fri, 28 Dec 2007 08:42:21 GMT

What is the tcode to see how the tables are related in sql.

Re: Tcode to see the sql join

daixiong_jiang3 — Fri, 28 Dec 2007 08:57:50 GMT

an alternative tool can help you.please refer to transaction SQVI. type a quickview name and then click the CREATE button.

in the next screen, give a description in the TITLE, choose the datasource as Table join,then enter.

in the third screen,click the second button named Insert table or just shiftf1, you can insert the first table(you need to type the table name),then shiftf1 again, you can add another table.then you can see the link between the two tables.

if you want to add many tables,just do shift+f1 again and again

Re: Tcode to see the sql join

Former Member — Fri, 28 Dec 2007 08:59:40 GMT

Hi,

go to SQ02, there give the sample infoset name then press 'Create' button, fill the 'name' and select the radio button 'Table join by basis table' enter the table name against to that radiobutton field, press enter, then you can get the table given along with some pushbutton in application tool bar there select the "insert table" button , A popup will ask you for the another table name, enter the table name and press enter, which will display the related fields in those 2 tables, like wise you can give another table also, if you don't want the other table you can have the 'delete' button by choosing that table.

Reward if useful.

Thanks,

Sreeram.

Re: Tcode to see the sql join

Former Member — Fri, 28 Dec 2007 09:21:49 GMT

Hi i hv d list of TCodes,if u hv gv me ur mailid.i wl forward.