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

Posted by Sap Land Tuesday, 5 July 2011 08:53

Posted by jmarchionna
on Jul 5 at 11:51 AM

Since you are using MBEW, it is possible to have multiple entries for a
material number due to multiple valuation areas.

thanks,
Jim

---------------Original Message---------------
From: mack007
Sent: Tuesday, July 05, 2011 11:29 AM
Subject: Duplicate records when running wuery via SQVI

I have written a query which uses tables mara, marc and mbew, makt

if i only use mara, makt and marc i have no problems. Once i add mbew, the problems begin. I get the warning message saying that t001w - waers is missing. so i include it as well , yet the problem persists. If i run the query for a particular data set, i expect 3 records to be displayed. But I get 15 records and It seems to me like the other 12 records are all duplicates.

any one experience a similar issue beofre and if so how did u resolve

thanks
mack

__.____._