Queue clearing taking long time

[Former Member]

Dear All,

We deleted SNP orders from APO using the program /SAPAPO/RLCDEL. We are sending this deletion to R/3.

However there are lot of queues getting stuck in R/3 inbound and they are taking long to get cleared.

When we debugged, we found that its taking a long time on MDSB table in R/3.

Could someone provide some inputs on this?

Regards,

Kedar

[Former Member · Accepted solution]

Kedar,

MDSB is not a table, it is a view. It basically represents the RESB table.

When you delete a planned/production order, you also delete the dependent requirements, which are found in RESB.

However there are lot of queues quote getting stuck in R/3 inbound 

What do you mean by 'a lot'?

and they are taking long to get cleared.

How long is too long?

Deleting orders by use of RLCDEL should be considered to be a non standard process. If you are talking about 10 orders taking a half hour, then this is excessive, and you should consult with your Basis people for possible bottlenecks, starting with the R/3 server. If you are saying that deleting a thousand orders takes a half hour, I don't see this as excessive. You can restart 'stuck' cif queues periodically using standard SAP reports, perhaps in a batch job.

Rgds,

DB49