After addition of Nav attributes in 0material queries based on these info provider object are giving wrong results

[Former Member]

Dear Experts,

We have added five New Navigation attributes in 0Material, after addition queries based on these Nav attributes are giving us partial error.

In dev client it is working fine but in PROD it is giving us partial result. request your help to resolve this issue.

Regards

Manohar

[Former Member · Accepted solution]

Hi manohar

The wrong data is caused by an inconsistency with the X-table of infoobject 0MATERIAL.
Please try to fix the inconsistencies using the repair functionality
of transaction RSRV.

All Elementary Tests -> Master Data ->SID Values in X and Y Tables--->
-> Execute the report for infoobject 0MATERIAL
-> Use the "Correct Error" button to fix the errors found by
this report.

Regards

Puja