Skip to Content
0
Former Member
Sep 14, 2011 at 10:25 AM

How to make the SQVI through the linking of 4 tables

720 Views

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