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

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

Posted by LCC352 (Sr. Mgr, ERP/Financial Systems)
on Jul 7 at 3:59 PM

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

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

__.____._