Skip to Content

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

Export Business Partners to XML

Hi all,

How do i export all data in Business Partners table into XML without using SQL statements? I tried exporting records one by one using getbykey method but is there any way to export all the records to a XML?Plz help.

replied

Hi Janaki,

No, I do not recommend to use only SQL (it may happen to be necessary, if you need to maximize performance).

There's a mechanism that you can run a query on the Business Partner table - e.g. "SELECT CardCode FROM OCRD" and connect the result (DI API's Recordset object) with the business object (Recordset property of the Browser sub-object of business obejcts) and export the business object data to XML (record by record).

The DI API samples which are shipped with the SDK + the new SDK E-learning etc. explain how it works in detail - or simply search for "DataBrowser Operations" in the SDK Helpcenter 2005. There you will find the sample code as well.

Regarding change of the table name from OCRD to sth else:

Of course this could (theoretically) become an issue, but I would see the risk as far below 1%

HTH,

Frank

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question