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>