Abnormal MRP list

[Former Member]

Dear

There is a abnormal sales order in our SAP system. This sales order has been completed delivery and billing. I have checked all status for the all relevant documents(order,DN,GI, and Billing). all of those are completed. However, the sales order requirement still display in our MRP/stock list even if I multiple run MRP/MPS planning. So, SAP still generate plan order for the sales order. I guess this is a bug. So, anybody can help?

Regards

Henry

[Former Member · Accepted solution]

Henry,

There are occasionally inconsistancies in SAP's requirements management. Occasionally, the requirements table (VBBE) gets out of synch with the other sales order tables. This may be your problem.

SAP has supplied a standard program SDRQCR21 to correct. I suggest you run it only against a single plant/material combination. If you want to 'clean up' ALL faulty entries, try to find a time when your system is more or less idle. Running it against large datasets when there is Sales Order maintenance going on can cause additional inconsistancies. Review OSS 25444 and related messages.

[OSS note 25444|https://service.sap.com/sap/support/notes/25444]

Regards,

DB49

[Former Member]

You maybe delete sales order items?If you do,you can add it in SO item,then you can refuse it in the item.

Regards

William

[Former Member]

Hi DB49

I have a question to you. Should I tick which options in SDRQCR21?

Please give me instruction.

Regards

Henry

[Former Member]

Henry,

In your case, (one matl/one plant) the most important ones:

Material - reqd

Plant - reqd

Check 'Data transfer' to 'repair', leave unchecked to just display proposal, but make no changes.

Check 'compare' to see detail of changes that will be made.

Optional to check 'planning entry'. There are better ways to fix planning file if it is broken

Optional to check 'document lock'. You should check this, but, like it says, if you do, all associated sales/delivry documents will be locked until the process finishes. Depends on your business environment.

For one plant/material, the process usually just takes 3-20 seconds, depending on the number and complexity of the sales docs. For multi-part-multi-plant selections, IT CAN TAKE HOURS AND HOURS.

Good idea to read all the OSS notes when you get a chance. SAP has more 'consistancy' programs that are designed to fix similar problems in other areas. Start with the one I mentioned.

Rgds,

DB49

[Former Member]

hi

Table VBUK

BESTK: Null

LFSTK: C

LFGSK: C

WBSTK: Null

FKSTK: Null

FKSAK: Null

BUCHK: Null

ABSTK: A

GBSTK: C

KOSTK: Null

LVSTK: Null

Table VBUP

BESTA: Null

LFSTA: C

LFGSA: C

WBSTA: Null

FKSTA: Null

FKSAA: Null

ABSTA: A

GBSTA: C

KOSTA: Null

LVSTA: Null

Regards

Henry

[Former Member]

Hi,

In addition to the above inputs from DB49, i notice that the Goods Movement & Pick status for the item is blank. Normally when you do a picking & issue the material via VL02n, the status would be C. So kindly check how the issue has been done. I suspect the processing of this delivery is not done as per normal flow. Also the rejection status is A, so check the reason for the same

Open the outbound document via vl03n & check in status overview tab. Also trace the method employed, should give you more clues.

Regards,

Vivek

[Former Member]

Hi

I have checked all documents. delivery Qty is qual to ordered Qty, movetype 601 goods issue Qty is qual to ordered Qty. So, I say this is abnormal MRP list.

Regards

Henry

[Former Member]

Hi,

Can you let me know the below field values for the sales order:

Table VBUK

BESTK

LFSTK

LFGSK

WBSTK

FKSTK

FKSAK

BUCHK

ABSTK

GBSTK

KOSTK

LVSTK

Table VBUP

BESTA

LFSTA

LFGSA

WBSTA

FKSTA

FKSAA

ABSTA

GBSTA

KOSTA

LVSTA

[Former Member]

Hi,

Please open the sales order & check the qty ordered. Now verify if the entire qty has been delivered. You can get these details by going to VA03 & click on document flow.

Also go to MB51 report & check for the movements posted for this material, if am right, you should see a 601 movement for delivery.

Also, do you see the entire sales order qty in MD04 as open or only a part of it?

Check the above & revert.

Regards,

Vivek