Data Migration Via Excel & ABAP

[former_member182007]

Dear Experts,

We have a scenario where we will migrate the ERP data which is on MS Navision ( Microsoft ERP). Considering there is less number of records for key data objects like customer, vendor, material, GL like 10K ~ each. there are some open transactions as well as typical AP, AR etc.

Data quality is Ok, mostly there would be one to one mapping. Plan is to get the extracts in excels, validate there itself with some queries and enriched excel will be loaded to SAP HANA via ABAP programs. Obviously there would be Value mappings etc. will be maintained separately.

Anyone came across this kind of scenario? Please let me know if you see any challenge here.

Many thanks in advance.

Rgds

Deep

[former_member187605]

Don't reinvent the wheel. Use the Rapid Data Migration to SAP ERP and SAP CRM V3.42 solution. That package is freely available for you to download from SAP Service Marketplace. Download instructions are in SAP Note 1791183.

Input for the package are Excel files, that's perfectly in line with what you're envisaging.

[former_member431649]

Totally agree with Dirk.  Alternatively replace the excel files with direct access to either the MS SQL server tables/views.  Otherwise get the extracts from the source system to be created based on the Excel Input definitions for the Rapid Data Migration package.

[mageshwaran_subramanian]

Is Data Services part of your plan for data extraction and transformation?.

If MS Navisionruns on MS SQL Server , you can use Data Services to connect to it to extract the data,then transform by applying the mapping rules and then load into SAP HANA