SQVI

Just wishing some one can help me ,

To list all materials at a plant with their BOM components and respective quantities. I tried a SQVI with

MAKT, MARA,MARC,MAST,STKO,STPO but is duplicating fields and also mixing up Alt.BOMs. Not sure where am I making mistake. I am not an expert in joining tables.

Thanks

Vardev