find the duplicate meterial no

[Former Member]

hi all

i have an issue

we have loaded master data 0material to 2 info objects and 1 cube so user found some duplicate meterial no in data

so how to find these duplicate meterial no .

is it posible to create infoset and join both the objects

[Former Member]

Hi

Check out the SID table of your material. In your DTP, change the error handling to Update valid records, reporting not possible. so that you can sort out duplicate records while loading itself

Regards,

Venkatesh

[Former Member]

Hi Venkatesh

That issue got resolved Thanks for your quick response.

I have one more issue.

0 material master object loading the data into info cubeZRREUC16 and infoobjecZEPMPRODt. user found some duplicate records in the data.

She requested to create a report to trace that duplicate records on infocube and infoobject. that scenario have created a multi provider and insert the cube and info object. In query level i took one common field material and i have aplied the formula . but its not working .She wants see only invalid materials in query out put screen

Can you please suggest me how to create a query to tracing the material duplicate records.

[Former Member]

pls see http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/603aa0d7-f100-2d10-a3a4-d2ad2938ba11

[Former Member]

Hi Anshulr,

I saw your link that is very helpful to me thanks for your quick response,

actually i have to compare the material data of infocube and info object this combination customer exit will work or we have to we create a infoset.

please suggest me

Thanks,

Bhaskar