MD04 - Inconsistencies after PGI - SDRQCR21

What is the use of SDRQCR21 (SAP note 1166713) standard SAP program?
I have got a issue with this program.  The issue (problem) stated is as follows:
Program SDRQCR21 was ran on material XYZ for plant ABC. It did not work. The item is still on MD04. Unable to use material as it is being held on the MD04 screen.

This program is used for to regenerate the sales/delivery requirements.

Example: sales order 1000 is created on some date.

Now may be you have put the reason for rejection to the sales order but the stock requirement list MD04 is still holding the qty against to the sales document.

Execute SDRQCR21 program by selecting data Transfer option.

MD04 will remove the Hold qty against to the sales order.
 

I have a sales order, sales order is fully delivered and MD04 doesn’t have this record displayed. You can see it has no sales orders by using the Find in List function (Cnt-F) in mdo4. The find MRP Elements tab shows you no sales orders exist for this material plant (sales order item ). So don’t understand why it shows up as an error. Why does the program think it needs to delete this sales order entry from md04, when it has nothing in MDO4 .

Run the program SDRQCR21 in SA38.

In the ensuing selection screen, Give the inputs of material number, plant and if possible document number, and execute.

You have to schedule this job before MRP run at plant level (creating variant from SE38).

After executing this, the completed delivery will disappear and MD04 will have real data only.
 

SDRQCR21 report doesn't update MD04 result.
We had quite a lot customer orders be re-scheduled everyday for some reason.  According to OSS note : 25444 & 998102 we have to run the report SDRQCR21 with option "data transfer" to correct stock /requirement list.  But nothing happen after run the report.

Go through the OSS Note: 547277

It may be useful.

From the OSS Note:25444

Below write-up may be useful:

Item Material Index

If you enter the 'Material' or 'Plant' selection criteria, the report returns correct results only if the document items affected are contained correctly in the relevant material index (VAPMA, VLPMA). This prerequisite is usually met. Only if you have good reason to suspect that the index is inconsistent, that the report has returned incorrect results because of inconsistencies, or that the report terminated with SAPSQL_ARRAY_INSERT_DUPREC because of inconsistencies, check the TVIND Customizing table and see Note 128947 and/or 33267 for information about correctly reconstructing the material index.

Get help for your SAP PP Problems
SAP PP Forum - Do you have a SAP PP Question?

SAP Production Planning Books
SAP PP Certification, Interview Questions and Configuration Books

SAP PP Tips
SAP PP Tips and Production Planning/Control Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.