to write transformation code for the following xml data

Former Member — Mon, 06 Aug 2007 03:59:31 GMT

Hi Friends

How to write transformation code for the following xml data.. Please let me know immedately if any one know..

I have written as following but i encountered an eror staating -

The exception, which is assigned to class 'CX_ST_MATCH_ELEMENT', was not caught

and

therefore caused a runtime error.

The reason for the exception is:

XML matching error

Expected was element-start: "Negara" [ ] Read was invalid: " " [ ].

Go through my xml file , the code and code in simple transformation.. Please reply(transformation code) me as soon as possible

- <Negara>

- <item>

- <COUNTRY>

<ZDESC>Pening Lalat</ZDESC>

</COUNTRY>

</item>

- <item>

- <COUNTRY>

<ZDESC>Pening Lalat2</ZDESC>

</COUNTRY>

</item>

</Negara>

DATA : BEGIN OF XDATA OCCURS 0,

STR(255) TYPE C,

END OF XDATA.

DATA: XMLUPL TYPE string .

DATA : BEGIN OF ITAB OCCURS 0,

MANDT(3) TYPE C,

ZCODE(3) TYPE C,

ZDESC(15) TYPE C,

ZSAPCD(2) TYPE C,

END OF ITAB.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = 'C:\country.xml'

FILETYPE = 'BIN'

TABLES

DATA_TAB = XDATA.

LOOP AT XDATA.

CONCATENATE XMLUPL XDATA-STR INTO XMLUPL.

ENDLOOP.

CALL TRANSFORMATION ('Y_XMLCTRY')

SOURCE XML XMLUPL

result xml = ITAB[].

BREAK-POINT.

<?sap.transform simple?>

<tt:transform template="temp1"

xmlns:tt="http://www.sap.com/transformation-templates">

<tt:root name="ROOT1"/>

<tt:root name="ROOT2"/>

<tt:template name="temp1">

<tt:loop ref=".ROOT1" name="i">

<item>

<tt:loop ref=".ROOT2" name="c">

<MANDT>

<tt:value ref="$c.nummer" />

</MANDT>

<ZCODE>

<tt:value ref="$c.nummer" />

</ZCODE>

<ZDESC>

<tt:value ref="$c.name" />

</ZDESC>

<tt:value ref="$c.name" />

</ZSAPCD>

</COUNTRY>

</tt:loop>

</item>

</tt:loop>

</Negara>

</tt:template>

</tt:transform>

Thanking You

Devi

Re: to write transformation code for the following xml data

Former Member — Mon, 06 Aug 2007 04:08:48 GMT

[original link is broken]

topic Re: to write transformation code for the following xml data in Application Development and Automation Discussions

to write transformation code for the following xml data

Re: to write transformation code for the following xml data