on 2019 Dec 11 12:57 AM
We got old version BOMs which are expired and locked in ECC. The validity date got updated in APO PPM. But the PPM still shows as active though they are not in valid date. We are not able to delete old PPM’s as the status is active. What is the best way to change the status to inactive for all old PPM’s.
Request clarification before answering.
Hello Jeff,
Getting information using tables in APO is very tricky, I think ECC would be easy.
You can start by identifying these from ECC MKAL table for the production versions, as you say they are locked and have a valid to date in past. You can pass these in /SAPAPO/MASS_DELETE_PPM. This program runs for a very long time and gives some pain in the neck. Use small batches of materials at a time in parallel sessions if you have a lot to del.
You can also try this, once you have identified the PV, make some change in the PV send it via change transfer CFP3, this should change the status to inactive. Try this for one or two first if it works, C223 and CFP3 could do the trick.
Also consider scheduling a CFP3 daily before any CFM1/CFM2s for the PPM.
I had a similar situation and after doing this exercise few times in few months I ended up creating a program in APO which does this cleaning job for me.
It uses BAPI_PPMSRVAPS_GETLIST to find the PPMs, this BAPI will return all the necessary information to test PPMs as per your logic, then BAPI_PPMSRVAPS_DELMULTI_PLAN to del which failed the test. Cool thing about this BAPI is it will del PPMs even with order assignment.
You can also use the BAPI_PPMSRVAPS_GETLIST to find the PPMs in APO, table PPM will give you the valid from and valid to date, use it in test mode pass the plant and download it in XLS.
I think you have many ideas now.... 😉
Regards,
Abhishek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Abhishek,
Sorry for late reply. Just came back from vacation. We got user exit that's the reason the status is not getting updated in APO. I am working with developer to fix the problem. Thx for your input.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Any more thoughts!!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I cannot use /SAPAPO/MASS_DELETE_PPM for active PPM's, unless we know which PPM's are active though the validity date is expired. So, I am thinking of identify PPM's which are active and in Invalid date ( through table) and then delete them using above program? Thx for your input.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Mr. Brahmankar,
Yes, still it's not changing the PPM status to inactive. Thx for your input.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Did you locked the PPM and then sent changes through CFP3?
Have you tried MASSD?
Please try this /SAPAPO/PPM_CLEAN_UP if it can help here for any inconsistency.
Did you try the report /SAPAPO/MASS_DELETE_PPM for PPM deletion with active status? I think it should work.
Best Regards,
R.Brahmankar
Hello,
Did you try CFP3 to re-transfer the PPM for changes?
If you change PPM to Locked status, in the CIF transfer it will make the correspond PPM as inactive.
And in /SAPAPO/PPM_DEL you can select all the inactive PPMs for deletion.
Also note you change the PPM status using the mass maintenance transaction MASSD in APO to change status to inactive.
Best Regards,
R.Brahmankar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 12 | |
| 10 | |
| 8 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.