Data Conversion Documents

One of the critical steps in the implementation of an SAP solution is data-conversion planning and preparation. Data conversion is the translation of data from one format to another so that it can be used in another application or system. As with any new project/system implementation, the data conversion approach is a very important step that lays out the principles and guidelines for the data conversion process.

Below you will find downloadable documents to guide you and your agency as you prepare your data for conversion. Note, many of the Excel reference documents have multiple worksheet tabs.

If you have any questions about any of the Data Conversion Documents, please contact Jill Williams at BobbieJill.Williams@sceis.sc.gov or (803) 832-8052.

Data Conversion Documents
Document Name	Area	Add/modified
Conversion Data Due Dates - (69kb MS Word) Agencies Approach and Plan for Data Conversion - (239kb PDF)	All All	July 27, 2009 June 29, 2009
Funds Reservation Conversion Guide - (1mb MS Word) The Conversion Guide includes the following embedded file: Funds Reservation Template	FI - Funds Reservation	September 29, 2009
Asset Master Conversion Guide - (3.7mb MS Word) Useful Life Chart - (29kb Excel) The Conversion Guide includes the following embedded file: Asset Master Data Template	FI - Assets	Asset Master Conversion Guide Updated: Oct. 27, 2009. (Asset Class 2000 deleted from the Asset Master Data Template spreadsheet.) Useful Life Chart Published: August 21, 2009
Sponsored Programs Conversion Guide - (1mb MS Word) Note: The Sponsored Programs template should be completed BEFORE the Grant template. The Conversion Guide includes these embedded files: Sponsored Programs Data Template Sponsored Programs Master Data Document	FI - Sponsored Programs	Updated Aug 10, 2009: Updated "Sponsored Programs MD Document," other assistance. Published June 30, 2009
Grant Master Data Conversion Guide - (2.8mb MS Word) The Conversion Guide includes these embedded files: Grant Master Data Template GM Datalists for Grant Master Data Uploads Grant Master Data Elements NOTE: The Sponsored Programs template should be completed BEFORE the Grant template.	FI - Grants	June 30, 2009 Updated Aug 10, 2009: Additional fields in MD Template, new notes in MD Elements, other assistance. Updated July 27, 2009: Revised Grant Value field (page 3), and added new field to Grant Master Data Template.
Grant Budget Master Conversion Guide - (1mb MS Word) Grants Management Derivation Lists - (87kb Excel) The Conversion Guide includes the following embedded file: Grant Budget Data Template	FI - Grants	Aug 6, 2009 Aug 21, 2009
Customer Master Conversion Guide - (1.9mb MS Word) The Conversion Guide includes the following embedded file: Customer Master Load Data Template	FI - Customer	June 29, 2009
Open Accounts Receivable Conversion Guide - (1mb MS Word) The Conversion Guide includes the following embedded file: Open AR Invoice Data Template	FI - Accounts Receivable	Updated Aug. 19, 2009
Material Master Extension Conversion Guide - (3.6mb MS Word)	MM - Inventory Management Only the agencies below will use this Guide: Corrections CJA Education DHEC DJJ DMH DMV DNR PPP DPS SLED DSIT DOT Voc Rehab	Updated Sept. 15, 2009
Bill of Material Conversion Guide (3.53 MB MS Word)	MM - Inventory Management Only the agencies below will use this Guide: Voc Rehab	July 14, 2009
Inventory Purchase Orders Conversion Guide - (2.8mb MS Word) The Conversion Guide includes the following embedded files: Purchase Order with Inventory Data Template Unit of Measure Reference Table	MM - Inventory Management Only the agencies below will use this Guide: Corrections CJA Education DHEC DJJ DMH DMV DNR PPP DPS SLED DSIT DOT Voc Rehab	Updated Sept. 15, 2009
Inventory Balances Conversion Guide - (2.7mb MS Word) The Conversion Guide includes the following embedded files: Inventory Balance Data Template SAP Plant Numbers Reference Table	MM - Inventory Management Only the agencies below will use this Guide: Corrections CJA Education DHEC DJJ DMH DMV DNR PPP DPS SLED DSIT DOT Voc Rehab	Updated Sept. 15, 2009
Agency Contract Conversion Guide - (4.6mb MS Word) Agency Contract Conversion Presentation - (161kb PDF) Agency Contract Conversion Handouts - ( 926kb MS Word) The Conversion Guide includes the following embedded files: Agency Contract Data Template.xls	MM - Agency Contracts	July 1, 2009 July 30, 2009 July 30, 2009
Open Purchase Orders Conversion Guide - (3.1mb MS Word) The Conversion Guide includes the following embedded files: Standard Purchase Order Template Standard Asset Template Blanket Agreements and Blanket Orders Template Framework Orders and Agreements without Funding Template Standard Capital Projects Template Master Template (combines all above templates) Unit of Measure Reference Table	MM - Procurement	August 4, 2009
Sales Contracts Conversion Guide - (4.4mb MS Word) The Conversion Guide includes the following embedded file: Sales Contract Data Template	SD - Sales and Distribution Only the agencies below will use this Guide: Corrections DPS DSIT Voc Rehab	July 24, 2009
Open Sales Orders Conversion Guide - (4.4mb MS Word) The Conversion Guide includes the following embedded file: Open Sales Orders Data Template	SD - Sales and Distribution Only the agencies below will use this Guide: Corrections DPS DSIT Voc Rehab	July 24, 2009
Pricing Conditions Conversion Guide - (3.5mb MS Word) The Conversion Guide includes the following embedded file: Pricing Conditions Data Template	SD - Sales and Distribution Only the agencies below will use this Guide: Corrections DPS DSIT Voc Rehab
Project Systems (WBS) Conversion Guide - (2.74mb MS Word) The Conversion Guide includes the following embedded file: Project Systems Data Template	FI - Project Systems Only the agencies below will use this Guide: Adjutant General B&CB Corrections Criminal Justice Acad. DDSN DHEC DHHS DMH DMV DNR PRT DPS SLED Tech Schools Vocational Rehab.	Updated Sept. 16, 2009