Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.