Hello community,
For a project, my company wants to migrate SAP Business One to S4/HANA. How do I implement the data migration? To download data from SAP Business One, I can write an SQL command, but I then need to upload it to S4/HANA and that can may be done by add-on ABAP programs. Any ideas or suggestions?
Thank you for your help.
Avoid doing direct SQL extract + custom ABAP upload. It works for small cases but becomes risky and hard to manage at scale.
A better approach is to use structured migration methods like SAP Migration Cockpit or ETL tools, along with proper data mapping between SAP B1 and S/4HANA.
Also, don’t migrate everything. Clean the data first and consider moving only master data and open balances, while keeping historical transactions in the legacy system.
Most issues in these projects come from poor data mapping and lack of testing, so run multiple test migrations before going live.
Hello Vincent, S4/HANA provides a standard tool for data import. Check with your partner the availability of a tool called LSMW (Legacy System Migration Workbench). Check this note: SAP Note 2538170