Performance: Importing Items

[Former Member]

Hi,

I have a custom database, which has the information about items. I need to get the data from that database (perform some transformations) and create new items in SAP.

I'm using DI API, and it takes me around 3-4 seconds to create each item. (I have done the optimizations possible by me.)

I wonder whether I can interface with DTW, to create the necessary excel sheet programmatically, and automatically launch the DTW to import the items.

Do you have any idea how to do that ?

What is the command line arguments we need to pass to DTW?

Thank you so much.

-Geetha

[Former Member]

Hi Owen,

Thanks a lot for giving me detailed information.

Have a nice weekend.

Regards,

Geetha

[Former Member]

Hi,

Actually I checked the performance of different segments of code.

And I found out that, for adding items it does not take that much time, but, when adding items I need to add goods receipt (to add an item to the inventory), and that's what is the bottleneck.

Please let me know your inputs, whether there is any way I can improve the performance of it/ is there any other alternative for it?

Thank you so much...

I use the following function to add GR for every item:

Private Sub AddGoodsReceiptInventory(ByVal strItemCode As String)

Dim OIGN As SAPbobsCOM.Documents

OIGN = objSbo.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oInventoryGenEntry)

OIGN.Lines.ItemCode = strItemCode

OIGN.Lines.Quantity = 1

OIGN.Lines.WarehouseCode = strWH

If OIGN.Add() <> 0 Then

-

---

End If

End Sub

Regards,

Geetha

[former_member201110]

Hi Geetha,

The DTW uses the DI API to write to the database so I doubt you'd get any performance benefit (assuming your code is as efficient as the DTW code) and it might even be slower. The DTW has no API so I don't think you can manipulate it through code.

Are you using XML to create your items or are you setting all properties via code? I typcially find using XML is faster so, if you are not already doing so, you could pull your data from your database, transform it in to one of the SBO item schemata and then use the DI API to load it.

The DI API and DI Server are the only certified APIs that allow you to create items in SBO (outside of the user-interface). Any import tools (eg DTW, iBolt, Flow etc) all make use of one or other of these APIs so they should exhibit similar performance. Of course, direct SQL input would be much faster but it is strictly forbidden by SAP's support agreement.

Kind Regards,

Owen