How to join two tables

[Former Member]

Sir,

Please tell me the procedure to join two tables through SQVI

and also how to know that a particular transaction code is hitting which all tables

Thanking You

Juhi sinha

[Former Member]

Hi

Suppose you need for a material in a plant, the material type (MTART) and material group (MATKL) besides the above you information you got from MARC.

You can join MARC with MARA. Set the data source while creating the query to Table join. Give MARC first against the table. Then go to table join area and enter MARA second. Play around to link both these tables, there are enough icons to help you there. There you will have to provide link condition. You shall link both tables based on the common field MATNR.

When you come back to the original screen, you will find both the tables field.Pick whatever you need in both selection tab (based on what fields your selection is going to be) and the list tab (what you need to see in the output).

assign points if useful