Recovery of Sales and Delivery Availability Stock
We have problems about requirements stock of sales and delivery on SAP system. User creates sales order as usual, and then logistic user creates delivery based on sales order. Somehow, the delivery document was deleted and then the problem began. The problem is stock still kept by the delivery document (see t-code CO09 – availability overview). It means the stock was not released and not available for selling.
Then how to recover or fixed the sales and delivery availability stock? We use sap abap report SDRQCR21 – Recovery of Sales and Delivery Requirements. This abap program is supposed to delete and fix the wrong requirement.
How to use this sap abap report? Below are the instruction of using SDRQCR21 – Recovery of Sales and Delivery Requirements, we found from SAP Notes.
1. On SAP Abap Editor, input report name SDRQCR21 and then run the program.
2. On initial screen of the report, there are 2 fields and 4 tickmark.
- Material and Plant. They’re used if you want the report processes the requirement only for selected material and plant. By selected material and plant, it may be reduce the runtime of report.
- Data Transfer. Tick “Data Transfer” if you want the report updates the requirement on database. I you do not tick, the report simulate the update only.
- Compare. By tickmat “Compare” parameter, the performance (runtime) of report will be improved. The report then corrects, deletes and creates only the requirements affected by the correction. If you do not select the parameter, the report completely reconstructs the database (for the materials/plants selected). You are suggested to always select “Compare” parameter.
- Planning entry. If you select the “Planning entry” parameter, the report creates planning file entries (entries for the planning run) for the materials/plants affected (and relevant according to the MRP type).
- Processing for material. If you tick the “Processing for material” parameter, the report saves the requirements (database commit) one after the other for each material/plant, instead of saving all the requirements in one step. Correspondingly, the log issued by the report is also sorted according to material and plant.
3. Execute the report. Before update the requirements, I suggest to simulate first. If you sure about the result, then the updating process can be done.
4. Check the result using T-Code CO09 or MD04 where it were updated or not.
There are some considerations while using this report.
- Even if you execute the report without a data transfer, you should still select the “Compare” parameter.
- The report may require a long runtime. Since you can only execute it at specific times.
- Only execute the SDRQCR21 report with a data transfer once you have made sure that no-one will process sales documents or deliveries (for the materials/plants according to the selection) whilst the report is running, either in the foreground (dialog) or in the background (rescheduling, collective run for creating deliveries, EDI-IDoc and so on).
Other people found this article using terms: SDRQCR21, SAP sdrqcr21, sap co09, SDRQCR21 sap, sdrqcr21 program sap, sap stock, SAP STOCK AVAILABILITY, stock SAP, Instructions for Using SDRQCR21, SAP MD04 tutorial