Move data

[#1]

Dear Experts,

I need to move Master data from one company to new one.

I need to move Business partner and Items.

What is the best solution ?

Giuseppe

[Former Member · Accepted solution]

Hi,

You may check this thread......

Regards,

Priya

[Former Member]

Dear Giuseppe,

There are more than one option if the volume of master data is not too high. How many records do you need to move roughly?

Thanks,

Gordon

[Former Member]

Hi Giuseppe,

As been said, you could use DTW. If you want automated way to do this, you could create add-on utilizing DI API. However, if you don't want to involve in programming at all, I believe there is a newest tools from SAP called B1iSN which is perfect fit for your case.

Best Regards,

Hendry Wijaya

[Former Member]

DTW do not have any export option.

[vasileiosfasolis]

Hi

DTW is used only for importing data to SAP

in order to export them you can use many ways such as

select itemcode.......

or

by using the Microsoft management studio if you use MSSQL. there is an option that you can export specific tables

[Former Member]

Hi

Best way is Export the Item Master from one DB(Eg: select ItemCode,ItmsGrpCod, etc... from OITM) and Import to another DB via DTW. For BP Master also proceed the same way.

Regards,

Sudhir B.

[vasileiosfasolis]

Hi Giuseppe

the only solution is by using DTW

thanks