Auto Data Transfer

[Former Member]

Hi Gurus,

We have a new automation requirement in our company. We want to automatically transfer Bill of Material from Excel sheets to the BoM in SAP Business One. Is it possible with core SAP? If not, is it possible using an Add-On? If it is Add-On please provide information of the Addon dealer or developer.

Please provide some thoughts or choices from your own experience and technical know how.

Thanks in advance & Best Regards.

[Former Member · Accepted solution]

Hi Kanu,

Please check the related SAP Notes:

Number	Short Text
0000907940	How to use the Schedule Run functionality via the DTW
0000899412	DTW_How to use Scheduled Run via the DTW

Following the Given step in the help file of DTW.

1. Generate. Xml through "save" the transfer setup in DTW.

2. Create. Bat file as below:

C:\Program Files\SAP\Data Transfer Workbench\DTW –s C:\Documents and Settings\Testing Interface File\config.xml

3. To schedule the run, choose Start->All Programs->Accessories->System Tools->Scheduled Tasks.

http://search.sap.com/notes?id=0000907940

http://search.sap.com/notes?id=0001357351

Regards,

Marcelo Silva Santos

[Former Member · Accepted solution]

Hi Marcelo,

Thanks for your reply.

I am not able to access the notes, and getting this message: Your authorization is not sufficent to get this note.

Regards.

[kothandaraman_nagarajan · Accepted solution]

Hi Kanu Pathak,

please refer details of SAP notes:

907940 - How to use the Schedule Run functionality via the
DTW

Symptom

DTW provides the Schedule Run function to import or update data
automatically, so that you can run DTW from code line.

Cause

Consulting

Solution

To arrange a Scheduled run, perform the following steps:

1. Create the file including all the configured information. In general, you
can follow the same steps described in the 'Importing the Data Files' section or
'Updating Existing Business Object' section of the DTW Help File.

              On the 'Importing data' Step of DTW Wizard, press Save to
create the xml file.

2. Write a batch file (*.bat) - you can open Notepad and then save the file
with the extension .bat

              The format of the bat file is as follows:

              "C:\Program Files\SAP\Data Transfer Workbench\DTW" -s
C:\config.xml

              Note: config. xml is an XML file saved at importing data
Step which includes login, object name, file, mapping, run parameters
information.

3. Choose Start->All Programs->Accessories->System
Tools->Scheduled Tasks to schedule the run.

1. 4. When the time for the Scheduled Task arrives the DTW will open
3. automatically, it will connect and the import/update will start.

To get an SAP notes, you need S-user ID and password.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

If  you got the answer, please close this thread by clicking helpful or correct answer.

Thanks & Regards,

Nagarajan

[pvsbprasad]

Hi,

We can do this using

1.DI API from Excel  to SAP or

2.Manually we can open the BOM Scrren throug Code and Post Automatically

I think we can try this also

3. write A service to To check and post the Code

Reagrds,

Prasad

[Former Member]

Hi.....

If you have ever heard about Task Centre Add-on, using this you can easily do this job for automatic import of anything at a scheduled time....

Regards,

Rahul

[kothandaraman_nagarajan]

Hi Kanu Pathak,

You can use DTW add on to transfer bill of material in SAP Business one.

The required DTW templates are  OITT and ITT1 templates which can be accessed from the path,

C:\Program Files (x86)\SAP\Data Transfer Workbench\Templates\Samples\1. Add New Data\Production\Bill of Materials

Hope helpful.

Thanks & Regards,

Nagarajan