Regarding table join in SQVI

[Former Member]

Experts,

I want to develop one query in SQVI.

My requirement is as below.

I want to develop a query in SQVI, which will show me for which materials( of material type ZPRT in my case) for which source list doesn't exist.

For this, I am developing a query in SQVI by joining table MARA& EORD, please guide me how to proceed?

Regards,

Shailendra

Edited by: Shailendra Sabale on Jul 8, 2009 4:52 AM

[Former Member · Accepted solution]

Hi

goto SQVI > give a Query name and then click on create.

next screen, you will have to choose option as "Join tables" and click on OK

Next screen you will have to insert table which you want to join.

System on its own check whether proper link can be established between the tables to run the query or not.

in your case, Since all three tables have unique common field MATNR, there wont b any problem in joining these table

once it is done, click on back

then you will have to choose, which are the field you want to be as Selection Parameters and which should be displayed after running the query(its you call as per your business requirement)

then save it

Hope this will help you

[Former Member]

Closed

[Former Member]

Hi

It is no problem if you decide to use table MARA and EORD only, then just go to SQVI.

but for the better result you may add MARC table, since EORD table is plant specific as well as MARC table.

here we go:

- name your quick viewer --> choose "Create" button

- specify the title as you like, data source: Table Join, and choose "Basis mode" option

- insert table MARA, and EORD subsequently (check your join condition as MARA-MATNR and EORD-MATNR)

- press Back button

- on the "List. fld. select" tab, you may select field Material Type, Material Number, Account number of Vendor (EORD-LIFNR)

- on the "Selection field" you may select Material type, Material number --> as a parameter in your selection screen.

- choose Save, and Back button, and Save again if prompted.

- then you can test it (execute)

hope it helps,

rob

[Former Member]

Hi Shailendra,

User Three Tables MARA, MARC, EORD as join table and choose fields as per your requirement.

Hope this will solve your problem.Then mark it answered.

Regards,

yagensh bhatt