How do you migrate Legacy CIS data in to SAP IS-U CCS?

At a high level these are the two important types of master data that needs to be migrated from legacy CIS into SAP CCS. They are:

1. Business Master Data - Business Partner, Contract Accounts, Contracts.



2. Technical Master Data - Connection Object, Connection, Premise, Installation, POD and Device Location.

In addition to the above two types of master data, there are several other types of application & customizing data related to Billing (Rates, Rate Types, Rate Categories, Prices, etc), Work Management (Notifications, Orders, etc), Materials Management, Plant Maintenance and Quality Management modules that will need to be brought in before SAP CCS go-live. For the sake of this discussion, we will limit ourselves to the above two types of master data.

Migrating legacy CIS data into SAP acceptable format will need a careful analysis by an organization wide cross-functional team that is responsible for management of this data. These are some of the following factors you will need to keep in mind:

1. Is there duplication of data in Legacy CIS, which can be consolidated in to the NEW SAP CCS system?



2. Does the SAP number range for master data need to be same as in Legacy CIS system?



3. What tools are to be used for data migration - EMIGALL, LSMW, ABAP?



4. Validating and building input files to feed it into one of the above tools and getting it in to SAP.



5. Validating the SAP data loads and consistency.

What is SAP IS-U CCS?

IS-Utilities CCS (Customer Care & Service) hence forth referred to as SAP CCS is SAP's packaged solution for Electric, Gas, Water & Waste Management Utilities. SAP CCS consists of 5 major modules - FI-CA (Contract Accounting), Device Management, Billing & Invoicing, Customer Service (Front Office) and Work Management.

QUICK FACTS

• All basic front office processes such as Creation of New Accounts, Closing Accounts, Changing Billing Plans, Move-in and Move-outs are handled in the Customer Service.


• Once the Customer Service is done, field level activities such as Installation, Removal, Replacement, Certification and Meter Reading is handled in the Device Management module.


• Once the Meter Reads are available, Billing & Invoicing module handles the Billing of Customers.


• Contract Accounts Receivable & Payable module is in charge of receiving payments from customers and making payments out to vendors.


• All power outages and system interruption are reported to the Front Office, which then creates Notifications & Work Orders for Utility employees/contractors to go fix the problem.