how to create query in SQVI

[Former Member]

hi gurus

i want to make use of two tables and create query. how should i create one.

I am using tables j_1ipart2 and ekbe and i want to link fields refdoc of j_1ipart2 and belnr of ekbe. but i am not able to do

regards

Edited by: keetu on Apr 2, 2008 1:17 PM

[NathanGenez]

This is all explained in the online help. Have you looked at that yet?

-nathan

[Former Member]

Hi,

Basically you are creating a SAP Query for no of tables, please find the steps below.

1.Give quickview name XXXX and then select create tab.

2.Give Title and data source "table join"

3.Select either basis mode or layout mode(this is option how you do want the report basically)

4.Select insert table and give table name"BKPF" and select insert table once again and give the other table name like"MKPF"(Just example)

5.If you want to map reference the fields keep the curser on fields in fifferent tables and select reference fields.

6.Then go back and select the fields from doc headers from accounting and material and save, now your query is ready and you can execute so that you will be able to get the fields from both tables.

Hope understood and assign the points if you are cleared..

Thanks,

Vasu..