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

Posted by Sap Land Thursday, 7 July 2011 12:38

Posted by rory.goodwin
on Jul 7 at 3:41 PM

In my experience with SQVI, I have been able to link MARC-WERKS to MBEW-BWKEY and it works. Perhaps because is my environment the actual values for these fields are the same characters, but if you make BWKEY a selection criteria I think it will still work. I ignore those messages because I am often not concerned with displaying the plant's currency.

---------------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

__.____._