Hi,
I am developing an IDOC to File scenario. I have been provided with the following XML file format for the target. How do I proceed ? Should I import XML or XSD ? If XSD, then how can I generate one, which is acceptable.
XML File format:
<?xml version="1.0" encoding="UTF-8"?>
<nsDataExport><columns>
<column name="Purchase Order No" id="col0" type="System.String" />
<column name="Purchase Unit Price (Base Charge)" id="col1" type="System.Decimal" />
<column name="Purchase Delivery Date" id="col2" type="System.DateTime" />
<column name="Purchase Company Code No" id="col3" type="System.String" />
<column name="Purchase Cost Center Code" id="col4" type="System.String" />
<column name="Purchase Capital Acct No" id="col5" type="System.String" />
<column name="Purchase Vendor Company Supplier Code" id="col6" type="System.String" />
<column name="Location Code" id="col7" type="System.String" />
<column name="Room/Cubicle" id="col8" type="System.String" />
<column name="Floor" id="col9" type="System.String" />
<column name="Depreciation Begin Date" id="col10" type="System.DateTime" />
<column name="Depreciation End Date" id="col11" type="System.DateTime" />
<column name="Depreciation Useful Life (Duration)" id="col12" type="System.String" />
<column name="Depreciation Freq" id="col13" type="System.String" />
<column name="Depreciation Fixed Asset Master Record No" id="col14" type="System.String" />
<column name="Asset record Source (Imported From)" id="col15" type="System.String" />
<column name="Asset Record Source No" id="col16" type="System.String" />
<column name="Asset Type" id="col17" type="System.String" />
<column name="Model Version" id="col18" type="System.String" />
<column name="Fixed Asset No. " id="col19" type="System.String" />
<column name="Asset Description" id="col20" type="System.String" />
<column name="User Name (First)" id="col21" type="System.String" />
<column name="User Name (Last)" id="col22" type="System.String" />
<column name="Email" id="col23" type="System.String" />
<column name="Control Station Code Details" id="col24" type="System.String" />
<column name="Lessor Vendor Details" id="col25" type="System.String" />
<column name="Maint Depot Loc Code Details" id="col26" type="System.String" />
<column name="User details (People Soft ID)" id="col27" type="System.String" />
<column name="AirTime Vendor Details" id="col28" type="System.String" />
<column name="Supplying Vendor Details" id="col29" type="System.String" />
<column name="Maintenance Vendor Details" id="col30" type="System.String" />
<column name="Prior Location Code Details" id="col31" type="System.String" />
<column name="Installed Loc Code Details" id="col32" type="System.String" />
<column name="Chgbk Assigned Loc Code Details" id="col33" type="System.String" />
<column name="Warranty Vendor Details" id="col34" type="System.String" />
<column name="For-Use-At Loc Code Details" id="col35" type="System.String" />
<column name="Disposal Vendor Details" id="col36" type="System.String" />
<column name="Manufacturing Vendor Details" id="col37" type="System.String" />
</columns>
<exportExecution date="9/7/2007 7:16:19 PM" resultsSetId="d1deee3b-1010-4455-b8f1-53d9edb5a383">
<dataSource name="SAP_testing" guid="90fe1afa-54fe-4c1e-90c5-0cc57f6a5eb0" />
<rows>
<row rowNumber="0">
<column ref="col0">UNKNOWN</column>
<column ref="col7">HOU</column>
<column ref="col15">NotificationServersSS20060222</column>
<column ref="col16">2006022201674</column>
<column ref="col17">DESKTOP</column>
<column ref="col18">UNKNOWN</column>
<column ref="col19">38375435</column>
<column ref="col20">UNKNOWN</column>
<column ref="col22">Unknown</column>
<column ref="col23">Woody</column>
</row>
<row rowNumber="1">
<column ref="col1">0</column>
<column ref="col4">297</column>
<column ref="col5">1674</column>
<column ref="col6">XEROX</column>
<column ref="col7">ATW</column>
<column ref="col12">60</column>
<column ref="col13">MO</column>
<column ref="col14">PENDING</column>
<column ref="col15">InfoMan</column>
<column ref="col16">4940414</column>
<column ref="col17">PRINTER</column>
<column ref="col18">DC440</column>
<column ref="col20">XEROX DOCUMENT CENTRE MULTI FUNCTION DEVICE</column>
</row>
<row rowNumber="2">
<column ref="col7">UNKN</column>
<column ref="col8">Unknown</column>
<column ref="col9">Unk</column>
<column ref="col15">DavidCenter Sheet US Computer Assets</column>
<column ref="col16">38658SS10170</column>
<column ref="col17">MONITOR</column>
<column ref="col18">1702</column>
<column ref="col19">36590319</column>
<column ref="col21">Unknown</column>
<column ref="col22">Unknown</column>
</row>
<row rowNumber="3">
<column ref="col0">PB74251</column>
<column ref="col1">2357.1700</column>
<column ref="col4">297</column>
<column ref="col5">1685</column>
<column ref="col6">ENPOINTE</column>
<column ref="col7">HVS</column>
<column ref="col8">DMD01</column>
<column ref="col12">36</column>
<column ref="col13">MO</column>
<column ref="col14">PENDING</column>
<column ref="col15">InfoMan</column>
<column ref="col16">3825727</column>
<column ref="col17">PC</column>
<column ref="col18">6563/85U</column>
<column ref="col19">36579033</column>
<column ref="col20">IBM P3/600 64MB 10.1GB CD-ROM</column>
<column ref="col23">HVS</column>
</row>
<row rowNumber="4">
<column ref="col0">unknown</column>
<column ref="col3">US10</column>
<column ref="col6">HP</column>
<column ref="col7">ILN</column>
<column ref="col12">48</column>
<column ref="col15">FOUNDSS</column>
<column ref="col16">2.00612E+12</column>
<column ref="col17">PRINTER</column>
<column ref="col18">HPLSR1320@</column>
<column ref="col20">HP 1320 LASER PRINTER</column>
<column ref="col21">CustPersonName</column>
<column ref="col22">CustPersonName</column>
</row>
<row rowNumber="5">
<column ref="col7">ILN</column>
<column ref="col15">CDRSS20060808</column>
<column ref="col16">200608080214</column>
<column ref="col17">PC</column>
<column ref="col18">Unknown</column>
<column ref="col19">1040882</column>
</row>
</rows>
</exportExecution>
</nsDataExport>
Thanks,
Sachin.