topic SQVI in Application Development and Automation Discussions

SQVI

Former Member — Tue, 22 Apr 2008 18:58:52 GMT

Just wishing someone 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

Re: SQVI

Former Member — Wed, 23 Apr 2008 04:51:17 GMT

Hi,

using sqvi tcode you can find relationship between tables.but some times it will show wrong relationship.

don't prefer this in all cases open tables find what is the difference and find if any foreign key relationship with table using fiels.

it's an best procedure according to my experience.

Re: SQVI

Former Member — Wed, 23 Apr 2008 04:54:43 GMT

Hi,

Use function module CS_BOM_EXPL_MAT_V2 for multi level explosion, simular to CS12 functionality.

Regards,

Raj.