Re: [sap-log-mm] Duplicate records when running wuery via SQVI

Posted by Sap Land Thursday, 7 July 2011 23:36

Posted by mack007 (consultant )
on Jul 8 at 2:34 AM

hi

i have found the problem and it has been resolved

you have to join mara to marc and then also join marc to mbew

there is a join already from marc to mbew with material number but you
have to create a further join on marc and mbew by linking plant to
valuation area.

This solves the problem.
Thanks for the responses
Mack

---------------Original Message---------------
From: Louis Corato
Sent: Thursday, July 07, 2011 4:00 PM
Subject: Duplicate records when running wuery via SQVI

The only thing to consider is what the value of "valuation type" (BWTAR) is in your system. If you can select only one of these per material/valuation area, you will be okay. If not, then every time there is another entry for valuation type for the same material/valuation area, the records will repeat. - Lou

__.____._