Skip to Content
avatar image
Former Member

Performance: Importing Items

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 26, 2008 at 11:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 27, 2008 at 09:13 PM

    Hi Owen,

    Thanks a lot for giving me detailed information.

    Have a nice weekend.

    Regards,

    Geetha

    Add comment
    10|10000 characters needed characters exceeded

    • 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