Skip to Content

Initial Data Migration Over, The Fun Has Just Begun

Where I work the SAP Utilities solution is the heart of our SAP system.  Therefore when it was decided to merge two more utility companies into our existing company, I have to thank our ASUG SAP point of contact Ina Felsheim  who over 2 years ago helped arrange a data migration ASUG webcast for Utilities.

The great Ginger Gatling  provided the webcast.  Ginger has since moved on to cloud integration, but I am grateful to both Ina and Ginger for this webcast.  First I am not an expert in the SAP Utilities solution – it covers the gamut of device management, customer service, billing, FI-CA, and so much more.

SAP provides a rapid deployment solution for utilities using Data Services, and included in this migration solution are templates to use.   You don’t necessarily have to use the Data Services tool to even use the templates provided.  The spreadsheet templates helped provide a framework of the data mapping needed/required to fit into the SAP structures.

It also helped to have a SAP Experts subscription, as I listed to a recorded session given by SAP’s Paul Medaille  – this session helped me find and locate the needed templates.

For Rapid Deployment Solutions, SAP recommends you obtain consulting to help with the solution.  We decided not to do this and do it ourselves.  We installed Data Services in-house, and then used the RDS templates to migrate the SAP Utilities objects such as PARTNER, ACCOUNT, DEVICE, etc.

In my mind, here are the basic steps of the migration:

Step 1: Download the SAP Mapping Templates


This helps provide the framework of the legacy data you have and what it should map to in SAP.  This helped me a great deal as I was not an expert in this SAP area.

Step 2: Get the Data Services RDS Solution for Utilities Up and Running

SAP provides RDS installation instructions.


Since I didn’t have a background in Data Services, I also spent time in a 2 day SAP data migration class – I wrote about it here: Do you still need a live SAP Education Course?

I was very impressed by a co-worker who didn’t attend any training and immediately understood how to use Data Services.

Step 3: Start Populating the Spreadsheets from Legacy to Feed to Data Services


This was the best part of the project, because you populate the spreadsheets by object and this services as a data source to Data Services.  Data Services then generates a file that can be read by SAP’s migration tool EMIGALL.

Step 4: Use EMIGALL to Load SAP

Another co-worker spent time getting familiar with EMIGALL and it is a very handy tool to load data into SAP.  But to me, the Data Services solution did the heavy lifting for us non-SAP Utilities experts, to get the required, right data in a needed format.

I remember another ASUG customer presentation (Kellogg’s) on data migration – the goal for data migration should be 0 defects.  Getting close…

If you want more details, links, information, please reply below – and I will try to find time to write more about this.

You must be Logged on to comment or reply to a post.
  • Hello Tammy We are planning a similar migration as you described in this article. Therefore I have a question: From where did you get the SAP Mapping Templates in Step 1 ? It looks like an Excel-Sheet. Thanks for your answer, best regards Andreas

    • Hello Andreas - we downloaded them from Service Marketplace under the RDS section.

      They were a huge help before we got Data Services up and running.

      They have moved around the RDS on SMP since I downloaded these, so I am hoping Frank Densborn might be able to provide a specific link.

      It takes the pain away of data migration for sure!

      Best of luck,


    • Hi Andreas,

      The mapping templates do fit 100% and work together with the Rapid Data Migration content for SAP Data Services. You'll get the Excel templates and the *.atl project files to import into Data Services.

      This content is available at no extra cost in the Service Marketplace and the Software Download Center. Please continue reading here to find the right content that you are looking for:

      A better way to migrate your SAP data with Rapid Deployment Solutions

      There is also a data migration community here in SCN:

      Data Migration

      Best regards,


  • Hi Tammy Powlas hi Frank Densborn,

    Thanks for these valuable information, I am managing an IS-U data migration and therefore I am exploring what is the best option.

    In Rapid Data Migration through Data Services, for standard objects the jobs to be activated are preconfigured. I have the following fears on how Data Services is used for migration in case of:

    1) Standard tables extended with additional z-fields ?

    2) Z-tables for custom objects completely created from scratch ?

    Thank you beforehand,


    • Karim - we didn't have any custom Z-tables to migrate

      For custom fields, you simply add them to the transformation/spreadsheet mapping.  It all worked.

      Rapid data migration w/ Data Services is the way to go; if you are unfamiliar with Data Services I recommend looking at the training content at

      That said we did have team members who successfully used Data Services and the rapid deployment solutions without any training.

      Please note it has been a few years since I have done this - but I wouldn't do another IS-U migration again without the RDS solution

      • Tammy,

        thank you very much for your quick reply, indeed RDS offers a very good framework that will structure the project. I will investigate more on how to deal with custom objects through Data Services.


        • Talking about Material Master data load W23 template from RDS solution. You can use Parameter Extension In/Out structures to load custom fields related with Material Master only.

          For other custom data loads you can research to use custom IDocs and then create your own templates or even you can write LSMW recordings and use Data Services to punch-out the load files (*.LSMW files).


          • Hi Jonas,

            As you'll own the content once you install the Rapid Data Migration content in the SAP Data Services platform, it's actually easy to extend that. You could create custom IDoc segments and add Z-fields to any object just by following the IDoc Extension Guide that we add to each of the Rapid Data Migration packages:


            Please also check out for the SAP note that is available for each of the various packages (depending on the target SAP system).

            Best regards,


          • Hi Frank,

            do you know if exists some template/document in case I need create a custom IDoc following Rapid Data Migration concepts?



          • Hi Jonas,

            In fact, we do have IDoc extension guides who are explaining how to extend the IDoc (both, segments for new fields and IDocs for new segments) interface plus how to extend the DS data flow. These guides are always attached to the SAP note behind each and every Rapid Data Migration package (per target system). Please follow the link that I posted above and then go to the specific package and click on SAP note.



          • Thank you Frank.

            Appreciate your notes. I saw the documentation and it's good in case we need change some of RDM processes or create new ones.