Duplicate Inforecs

[Former Member]

Gurus,

Wonder if you can put your heads together with this annoying little problem.

We have circumstances, through poor set up controls etc whereby some inforecs are duplicated, either in two currencies or attached to two different vendors.

Considering the thousands of materials we deal with it is not a big problem though highly annoying, particularly when debit notes are produced for the wrong vendor etc.

Is there a quick and easy way/ trans / table interogation etc that can identify what materials are duplicated.

thankee kindly

[csaba_szommer · Accepted solution]

Hi,

SE16 + EINA provides the material-vendor combinations. You can create a PIVOT table if you download it into excel and you can get the duplicated records > after that you can mark the with DF.

(EINA-EINE tables together contains much more idetailed nformation on info records but only you have trouble with material-vendor pairs, EINA is enough I think.)

Csaba

I guess you have to take care of plant, purchasing organisations as well > you'd better create a query in SQVI using EINA-EINE...

Edited by: Csaba Szommer on May 29, 2008 4:26 PM