Skip to Content
0
Jun 06, 2011 at 07:19 AM

XML to ABAP

42 Views

Hi Experts,

I am having trouble in processing the below XML to ABAP internal table.I just need the value from tag <FORMATTED_VALUE> into internal table.If COLUMN = 0,first column in internal table,if COLUMN = 1, second column in internal table.

Can anyone pls help.

<DATA_CELLS>
- <DATA_CELL column="0" row="0" type="NORMAL">
  <VALUE type="CALENDAR_DAY">20101029</VALUE> 
  <DISPLAY_VALUE type="CALENDAR_DAY">20101029</DISPLAY_VALUE> 
  <FORMATTED_VALUE>29.10.2010</FORMATTED_VALUE> 
  </DATA_CELL>
- <DATA_CELL column="1" row="0" type="NORMAL">
  <VALUE type="CALENDAR_DAY">20101101</VALUE> 
  <DISPLAY_VALUE type="CALENDAR_DAY">20101101</DISPLAY_VALUE> 
  <FORMATTED_VALUE>01.11.2010</FORMATTED_VALUE> 
  </DATA_CELL>
- <DATA_CELL column="2" row="0" type="NORMAL">
  <VALUE type="CALENDAR_DAY">20101029</VALUE> 
  <DISPLAY_VALUE type="CALENDAR_DAY">20101029</DISPLAY_VALUE> 
  <FORMATTED_VALUE>29.10.2010</FORMATTED_VALUE> 
  </DATA_CELL>
- <DATA_CELL column="3" row="0" type="NORMAL">
  <VALUE type="CALENDAR_DAY">20101101</VALUE> 
  <DISPLAY_VALUE type="CALENDAR_DAY">20101101</DISPLAY_VALUE> 
  <FORMATTED_VALUE>01.11.2010</FORMATTED_VALUE> 
  </DATA_CELL>
  </DATA_CELLS>