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...