MD04 Transaction issue

[Former Member]

When I execute the transaction MD04 with material/Plant combination ther is listed one delivery which already is finished. What shall I have to do that the delivery will not listed in this transaction?

I understood i can run program SDRQCR21.I just need to know how to run and any implication by running this program.I ran this program in simulation mode i figured out 2 entries.Can anybody guide me in this issue?

[aramsum · Accepted solution]

Hi,

The program reorganizes the stock requirements list. This program cleans up items that appear in the stock requirements list that should not be there (e.g. planned orders that have been deleted, deliveries that have been processed but still appear, etc).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.

Go through the OSS Note: 547277

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.

select the material and plant you wish to run the correction;

select the option data transfer when you actually wish to run the correction on the database;

select compare always in order to improve performance. Without selecting this the whole database for material/plant will be regenerated;

select planning entry to ensure the material is included in the next MRP run;

the option Processing per material results in a different log.

After this your MRP overview should be back in sync.

Regards

Ram Pedarla

Edited by: RamPedarla on Sep 8, 2009 1:18 PM