WDF 2342823 - How to use DTW to import mass data into SAP Business One in the Intercompany environment

WDF 2342823 - How to use DTW to import mass data into SAP Business One in the Intercompany environment

Symptom

You have installed SAP Business One Intercompany Solution, however, you would like to use DTW to import mass data into different SAP Business One companies.

Solution

Prerequisites:

  1. Make sure no user is connected to any SAP Business One company throughout the import process.
  2. Make sure no records exist in SEVT table of SBO-COMMON database.
  3. Stop SAP Business One Integration Service and SAP Business One EventSender Service.

DTW Import Wizard Execution:

  1. Prepare template: in the DTW template, ensure that the field "U_CTX_REIC" has the value 'Y' for all the global item/business partner master data records.
  2. Open the DTW console and login into any one participating head office or branch company (not the consolidation company).
  3. Run the DTW wizard with the template for importing global items/business partner master data. Once the wizard is finished, close the DTW console.
  4. Perform steps 1 and 2 for all the other participating branch companies (except the consolidation company). And ensure that the same DTW template is processed in all the participating branch companies.
  5. Log in SQL Server Management Studio or HANA studio.
  6. Back up SBO-COMMON database
  7. Execute the query in SBO-COMMON database: DELETE FROM SEVT
    Note! By using the update query you agree with liability conditions described in the following disclaimer:
     http://wiki.sdn.sap.com/wiki/display/PEQ/Home
    If you do not agree with the disclaimer, please contact the support organization for further processing of the reported issue.
  8. Start SAP Business One Integration Service and SAP Business One EventSender Service.

Product
Product or Product Version
B1 INTERCOMPNY INTEGRATION 2.0
SAP B1 10.0 FOR SAP HANA
SAP B1 9.3 FOR SAP HANA
SAP BUSINESS ONE 10.0
SAP BUSINESS ONE 9.3