SAP PS Data Migration

 

After successfully completing another Go-Live of an SAP Project (Project System module and it’s integration with FI/CO, AA, FM/GM, PM, SD) combined with a very complex Data Migration track in which I lead the SAP PS migration activities, I wanted to share some of the most important lessons I learned from this project.

 

Important elements to consider:

  • The SAP Data migration track is a project within the SAP project. Without it there is no Go-Live.

  • You will need a variety of resources to successfully deliver this track :

    • Data migration Lead/Coordinator

    • Subject matter experts on the client side

    • SAP Functional consultants with data migration experience

    • ABAP developers

    • A data validation / Quality assurance team

  • Various Migration runs are necessary to test and fine tune the migration tools and cleanse the data to be uploaded into SAP. The number of runs will depend on the complexity of the migration project as well as the quality of the data to be migrated.

 

SAP Migration Project typical steps:

  • Requirement gathering during workshops.

  • Data mapping.

  • Identifying the various programs needed in order to upload the data into SAP (LSMW, BDC, ABAP Programs, …)

  • Functional/Technical specifications.

  • Development of the various migration tools/programs.

  • Testing and fine tuning of the tools (Iterative process).

  • Data cleansing (Iterative process).

  • Multiple data migration runs.

  • A final data migration simulation run.

  • Go-Live (Project cutover activities and Data Migration + Quality assurance).

 

SAP PS Important Considerations:

  • Use the LSMW tool as much as possible. Almost everything can be loaded trough this tool.

  • Using LSMW ensures that all exits, enhancements, workflows are triggered during the migration process.

  • Start by importing the project definition by copying a template with a dummy WBS element.

  • Load the WBS structure. The dummy WBS element will serve as a reference to correctly integrate the new WBS structure.

  • Delete the dummy WBS Element.

  • Load the network activities.

  • Load your actual dates if required.

  • Load the settlement rules.

  • Activated all the user and system statuses.

 

These are the most common steps you’ll require to successfully load your SAP PS structures into SAP. Additional steps could be required:

  • Load user specific information in the customer enhancement screen.

  • Load project budgets.

  • Load HR resources.

  • Load historical costs.

  • Etc.

 

In case, you need to load Long texts or PS texts for example, you will need an ABAP developer to develop a program that allows you to load this specific information into your SAP PS projects.

Enjoy your data migration journey and when it comes to SAP PS, LSMW is the key !