MM Reopen posting period - MMPI transaction

Today I had to deal with this MM reopen period issue.
Problem: One user opened by mistake period 06 year 2005 but they still had documents for posting in period 04.
Solution: The solution is running the MMPI transaction and read note 48781.


This is a post I found on sap.ittoolbox.com SAP forum which explain some basic steps to reopen the MM period.

1. Lock all users out of PRD
2. Take snapshot of MB5L for all materials at company code for current and previous periods

3. Add User parameter MMPI_READ_NOTE with value = current date in this format YYYYMMDD

4. Stop all processing that updates inventory values

5. Run t-code MMPI with correct period

6. Run Z_DEl_HIST_ENTRIES program

7. Take MB5L snapshot for all materials at company code fs01 for current and previous periods

8. Validate that values match on MB5L pre-post snapshots or are appropriate.

9. Unlock all users in PRD

10. Remove User parameter MMPI_READ_NOTE from user ID

Good luck if you have such a problem.
Be carefully if you want to reopen a period that is far in the past!!!!

SAP BW Learning Guide

Check out this SAP BW Learning Guide from searchSAP.com. There's also other SAP Guides on this site.

SAP NetWeaver Guide

Check out this SAP NetWeaver Learning Guide from searchSAP.com.

SD - Minimum Order Value

In the SD module there is no starndard configuration for issueing a warning or message error if the order value is less than a certain value. But the system can be configured to add a surcharge calculated as as difference between minimum order value and actual order value.
All the configuration is described in this SAP note: 18173.

Power Point Presentations

We, as SAP consultants have to make lots of Power Point Presentation in order to show to the clinet how its procesess are modeled in SAP. I think this book, Beyond Bullet Points by Cliff Atkinson can improve our presentation skills. Cliff holds an blog on Power Point Presentation.

SAP IS-U group

I forgot to share with you this SAP ISU group. IS-U is the Industry Solution for Utilities module with can be integrated with SAP R/3. For about an year I work with SAP IS-U on a big project. For more information here are some links:
SAP Website
SAP Help
Anyone working with IS-U?