SAP Profit Center Reorganization: Essential Steps and Best Practices

Requirement Background: Business team decided to change the Profit Centers of list of Materials as per the business requirement. Or user maintained wrong profit center for few new materials and came to after few days of operation.

Solution: Change of Profit center of an existing material is really a painful activity which must be done if the requirement is really needed.

Below prerequisites must be handled to change the Profit Center. Ideally it is recommended to do on 1st of the month where both current and previous periods are in open stage. The approval must be taken from Finance business lead as the postings need to be done in the previous period.

  • Check MD04 and close all open Purchase Requisitions (ME52N), Inbound Delivery (VL32N) etc.
  • For open Sales orders, you can use MASS transaction with Object Type = BUS2032 and change the Profit Centre in bulk.
  • Note: If the business wanted to update the Profit center for already completed Sales Orders, users must create Return process to nullify the previous sales process.
  • For open Production orders, you can use COHV or CO02N
  • Use MARDH table to find the previous period stock with exact storage location.
  • Pass Plant, list of Materials, Year Current Period-LFGJA = Year, Current Period-LFMON= as per the period, Unrestricted ≠0 to get the Materials which need previous period stock.

Note: Most of the companies block 561/562 after Go-Live. So that I am recommending using 201/202 with Dummy cost center to do this activity.

Case 1 – Previous Period and Current period have same stock.
Previous period: 10 PC.
Current period: 10 PC.

Steps to clear stock:

  1. Execute Post Goods Movement (MIGO).
  2. Post goods issue with movement type 201 for quantity 10 PC in the previous period. This will clear the stock in the previous period so that the stock quantity in current period and previous period is same.
  3. Check material master-MM03-Accounting 1 View, after the posting of the goods movement you will have:
    Previous period: 0 PC.
    Current period: 0 PC.

Case 2 – Previous Period has less than Current period stock.
Previous period: 10 PC.
Current period: 15 PC.

Steps to clear stock:

  1. Execute Post Goods Movement (MIGO).
  2. Post goods issue with movement type 201 for quantity 10 PC in the previous period. This will clear the stock in the previous period and will leave 5 PC in the current period.
  3. Post goods issue with movement type 201 for quantity 5 PC in the current period to clear the stock completely.
  4. Check material master-MM03-Accounting 1 View, after the posting of the goods movement you will have:
    Previous period: 0 PC.
    Current period: 0 PC.

Case 3 – Previous Period has more than Current period stock.
Previous period: 15 PC.
Current period: 10 PC.

Steps to clear stock:

  1. Post a goods receipt with movement type 202 for quantity 5 PC in the current period so that the stock quantity in current period and previous period is same.
  2. Post goods issue with movement type 201 for quantity 15 PC in the previous period.
  3. Check material master-MM03-Accounting 1 View, after the posting of the goods movement you will have:
    Previous period: 0 PC.
    Current period: 0 PC.
  • Then change the Profit Centre with MM02 Transaction
  • Then reset the Profit Centre in Purchase Orders with the program.

For account assigned Purchase orders, the profit center comes from cost object like Cost center. In case of normal PO, the profit center is affected from the Material Master although it is not visible in PO level or any table level.

In case of changes to the Profit center, you can use the below program to reset the Profit center.

Input the Program – ZECPCAEK in SE38 Transaction and click on Execute button.

Now you will see the below screen. You can input the list of Purchase Orders to be reset and remove the Test check box.

Note: You run once with TEST flag to see all good or any other error messages from SAP before doing actual run.

Attention: you can use report ZECPCAEK only for purchase orders without account assignment objects. If you have purchase order with accounts assignments, you must change the purchase orders manually. In general, the usage of this report should be evaluated carefully as inconsistencies could occur for incomplete processes.

This solution can only be used if you use the classic General Ledger. For New General Ledger a Profit center Reorganization tool is available for a profit center change (see note 1810605)

The functions for the profit Centre reorganization as part of General Ledger Accounting (new) are a component of the SAP standard product SAP Landscape Transformation (SAP LT). Therefore, you need a license for this product to use the functions. Contact your account manager regarding the purchase of a license. For more information about the license purchase as well as installation and using SAP LT in connection with its solution for profit Centre reorganization, see SAP Note 1534197

In S/4 HANA, the steps are similar but open PO reset option won’t work and many other challenges. I will plan a blog about S/4 HANA soon with your valuable feedback and support.

Best Regards,

Ganesh Padala


Discover more from GANESH SAP SCM

Subscribe to get the latest posts sent to your email.

Leave a Reply