How can I clean only wrong entries from customers in S066 (not all)?

[former_member603880]

Hi!

We have many, many pending orders that have impact in our customer credit limit.

So, I need to clean the S066 but I can not filter this table by order... And the report RVKRED77 does not have orders to be filtered. It clean everthing and there is some orders Ok!

How can I clean only that orders in S066??

Thanks in advance and best regards.

GLippmann

[Shiva_Ram · Accepted solution]

If you know the sales order numbers, then can you put reason for rejection on the line items of those sales orders? If those orders need to be reactivated, then remove the reason for rejections.

Regards,

[former_member603880 · Accepted solution]

Thanks for your reply, Shive.

There are more than 50,000 items in this case. There is no possibility of this amendment be made manually. The ideal would be a standard program or BAPI. Did you know any way to help me?

BR,

GLippmann

[Lakshmipathi · Accepted solution]

In continuation to what Shiva has suggested, you can achieve this by executing MASS.  After executing this tcode and input Object type BUS2032 do the following:-

• select Sales Order Item Data and click on "Fields"
• select field name MASSVBAP-ABGRU and execute
• click "Multiple selection" arrow on right side against "Sales Document"
• Copy paste the required sale orders need to be blocked
• Input some Reason for Rejection against "New values" and click on 6th icon (Carry out a Mass change)

Now check the above table.

G. Lakshmipathi