How to make the SQVI through the linking of 4 tables

[Former Member]

I have a document no.i.e.9300801724.

I am getting the Internal No ( DOCNO ) from J_1IPART2 by put the doc.no.9300801724,then,I am putting the Internal no. ( DOCNO ) into J_1IPART1 and get the output of Material Document (MBLNR).Third,I am using the table,SE16-MSEG,and getting the Purchase Order (EBELN ) by given the input of Material Document i.e. already got from J_1IPART1.Now,I want to make the SQVI of all these 3 tables with including a new table of BKPF sothat I could get document no. ( BELNR ) from BKPF.

Now,the summary are:-

1-J_1IPART2

Input-FAWREF Output-DOCNO

2-J_1IPART1

Input-DOCNO Output-MBLNR

3-MSEG

Input-MBLNR Output-EBELN

4-BKPF

Final output should be BELNR

Is it possible to get all the datas from making the SQVI of above 4 tables?

Regards

Pradeep Kumar Gupta

[Former Member · Accepted solution]

Hi,

This can be achived through info set query. Below are the steps to create the info set query.

1. first create SQ03 user group to which query will be assigned

2. create infoset SQ02 and select the table and fields required for the output but ensure that there should be common field in each table you are using. system will show you the graphical display of table linkages.

3. Assign usergroup to infoset

4. Create query using SQ01 system will prompt you to select the info set and user group created in the above steps to select.

5. Give the desired name in description and select the basic list icon to select the field that need to be displayed in the output.

Hope it is clear and useful

Regards,

JB

[Former Member · Accepted solution]

Thank you very much.

[Former Member]

It's very easy, just go to tx. SQ01->Quick Viewer then set a name and go to create, in the next windows fill the info. required and select table join in data source..... the next step is select your tables and stablish the relations.

[Former Member]

Thank you sir.

[Former Member]

Hi, yes you can do it, but via SQ02(infoset), using tips from previouse answer

[Former Member]

thanks for the nice answer.

[Former Member]

Hi

For joining any tables thru SQVI there has to one common field in each of the tables. Unless there is a common filed in each of the table, you may not connect the same.

Now regarding the output data, If data from any one of the table if not appearing in output, then try to connect with link as outer left join.

Thanks

Sachin

[Former Member]

Thank you for the solution.