Skip to Content
0
Former Member
Sep 10, 2007 at 11:46 PM

Importing XSD

44 Views

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.