Skip to Content
0
Former Member
Oct 30, 2012 at 09:15 AM

Android application integrate with SAP B1 database using xml.

71 Views

Hi Experts!

I have a requirement as follows.

I need to retrieve the data from OITM, OCRD and ORDR from the sap b1 database using the .net coding afterwards I need to generate xml files as follows as output...

-----------------------------------------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8" ?>

- <items>

- <item id="1" active="1">

<barcode>123456789</barcode>

<description>HP Black Printer Catridge</description>

<group>IBM Printers</group>

<type>Items</type>

<manufacturer>IBM</manufacturer>

<price-list>Base Price</price-list>

<unit-price>GBP 200.00</unit-price>

<item-no>0</item-no>

- <inventory>

- <available>350</available>

<committed>7</committed>

<instock>357</instock>

<item-cost>156.45</item-cost>

<ordered>1</ordered>

<warehouse-name>General warehouse</warehouse-name>

</inventory>

</item>

</items>

-------------------------------------------------------------------------------------------------

This output is for OITM table..

Similarly I have output for OCRD and ORDR tables also. But to get output like this how to write the coding ?

Here I wanna integrate Andriod Application with SAP B1 database using vb.net.

Can anybody help plz.......

Thanks in advance...