Delete entries in /SAPAPO/POSMAPN with /SAPAPO/SDORDER_DEL

[andreas_weingartner]

Hi Guys,

we´re having many orders in table //POSMAPN that are not existing in liveCache.

We assume that these are obsolete orders that can be deleted with report //SDORDER_DEL.

My question:

What is the prerequisite for orders being deleted from //POSMAPN with //SDORDER_DEL?

Or in other words: Which entries in //POSMAPN are considered as "obsolete" by //SDORDER_DEL?

Thanks a lot for your help.

Andreas

[babu_kilari4]

Hello Andreas,

When you run the /SAPAPO/SDORDER_DEL program, you should run the program to delete the orders from both Live Cache and Database ( see the 2nd tab on the selection screen of this program). This way you can ensure that it is deleted properly. Otherwise, when you run //CCR or //SDRQCR21 it only checks the livecache. Since, it has already been deleted in your case, you can give it a try to see if you can delete the orders from DB using option "Delete from DB" ( see the 1st tab).

Also, usually the order gets disappeared from LC once the order is PGIed, however a bit of information is still available on APO side and thats where this program would delete it to counter that. The reason why the order line info is still stored in APO is due to the fact that the order lines can always be reverse PGIed and the delivery can also be deleted. So, it is a wise option to run this program by providing the Period in the selection screen which is usually the MBDAT and as a regular practice you can provide a date range that is less than 90 days or so.

Hope this helps

Babu Kilari

[andreas_weingartner]

Hi Babu,

Thanks for your reply.

Using  /SAPAPO/SDORDER_DEL or /SAPAPO/SDRQCR21, is there any risk to delete orders that shouldn´t have been deleted?

Thanks

Andreas

[babu_kilari4]

Hello Andreas,

/SAPAPO/SDRQCR21 as such doesn't delete the order whereas it might create the order entry in APO, if it is missing. Also, it looks for consistency between R/3 and APO systems and whenever there is an inconsistency it correct it.

When it comes to /SAPAPO/SDORDER_DEL program; it doesn't delete unnecessary orders as long as you choose the right date range in the selection screen. As a best practice, usually we delete 90 days old orders in a CPG environment. So, in your case choose the oldest orders that are open and try to evaluate a period less than that and delete them. So, it is more of a business intelligence that play a role here. It could be 90 days, 120 days...180 days. Choose wisely.

Hope this helps.

Babu Kilari