Skip to Content
author's profile photo
Former Member

Load An XML in sbo, and SQL Server

Hi I have created an XML that correspond to a sales Order, I want to load this sales Order in my Sap Business One, and to introduce the data in the tables ORDR, RDR1, is there a way to load the XML in my sistem and generate a sales order in my Sap??.

Thanks and sorry for my English

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Jun 18, 2004 at 11:38 AM

    Hi again:

    I have found the following method to read the data form an XMl:

    Private Sub XMLRead(oCompany As SAPbobsCOM.Company, vBP As SAPbobsCOM.Documents)

    Dim FileName As String

    Dim Ecount As Long

    Dim ii As Long

    FileName = "C:\Archivos de programa\SAP Manage\XML\Order1.Xml"

    'Get the number of Business object in the file ...

    Ecount = oCompany.GetXMLelementCount(FileName)

    'Loop threw the objects and when finding the first

    'BusinessPartner object , load it and stop.

    For ii = 0 To Ecount - 1

    If oCompany.GetXMLobjectType(FileName, ii) = oOrders Then

    'Read the Business object data

    Set vBP = vCmp.GetBusinessObjectFromXML(FileName, ii)

    Exit For

    End If

    Next ii

    End Sub

    My cuestion is, how to set the data after reading the XMl in SBO.

    Thank's

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Jun 22, 2004 at 07:24 PM

    Hi,

    you should probably load your sales order xml in an application and then use the DIApi to create a sales order. SAP will store the sales order in sql server then.

    HTH Lutz Morrien

    Add comment
    10|10000 characters needed characters exceeded