Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Saving all the records of SAP table as XML

Hi Curtis..

Thanks for ur immediate reply..

I m in ETL project to access data from SAP to Access and vise versa.

I want to know some more details..

1.We usually retrieve the Business Partners List by using GetBPList() method and we traverse record by record and save it as a XML.(XML contains a single recordset)

Is there a way to retrieve full Business Partner Records in a single XML?

Please reply immediately

Thanks in Advance

Sooriyakala.P

replied

Following code works for me (in VB .NET):

Dim rs As SAPbobsCOM.Recordset

Dim query As String

Try

query = "SELECT * FROM OCRD"

rs = oCmp.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

rs.DoQuery(query)

Console.WriteLine("aantal regels ", rs.RecordCount) If rs.RecordCount > 0 Then Dim file As String = "c:\temp\bp.xml" Console.WriteLine("file: ", file)

rs.SaveXML(file)

End If

Catch e As Exception

Dim message As String = _

e.[GetType].ToString + ":" + vbCrLf + _

e.Message + vbCrLf + _

e.StackTrace

Console.Error.WriteLine(message)

MsgBox(message, MsgBoxStyle.Critical)

End Try

Regards,

Jacco

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question