I have got data from RSAQ_REMOTE_QUERY_CALL in xml data. I need to format that data in grid view. In that tag gives column value and tag gives Feild description respectively Below i have mentioned my xml data. \[code\]?xml version="1.0" encoding="UTF-8" ?> TABLES>FPAIRS>item> INDEX_A>0007</INDEX_A> INDEX_U>0008 /INDEX_U> TYPE>E/TYPE> /item> /FPAIRS>LDATA>item> LINE>002:OR,004:0001,002:01,007:SCEM_02,000:, 002
C;/</LINE> /item> /LDATA>LISTDESC>item> FADD /> FDESC>Sales Organization</FDESC> FNAME>VBAK-VKORG</FNAME> FCOL>SOrg.</FCOL> FNAMENEW>VBAK-VKORG</FNAMENEW> FNAMEINT>VKORG</FNAMEINT> FKEY /> FGTYP /> FNZERO /> FSUM /> FSONLY /> FSORT>00</FSORT> FSODS /> FSUBT /> FLPOS>0002</FLPOS> FNUMB>98</FNUMB> FNUMBT /> FNOSUM /> FSONP /> /item>item> FADD /> FDESC>Distribution Channel</FDESC> FNAME>VBAK-VTWEG</FNAME> FCOL>DChl</FCOL> FNAMENEW>VBAK-VTWEG</FNAMENEW> FNAMEINT>VTWEG</FNAMEINT> FKEY /> FGTYP /> FNZERO /> FSUM /> FSONLY /> FSORT>00</FSORT> FSODS /> FSUBT /> FLPOS>0003</FLPOS> FNUMB>98</FNUMB> FNUMBT /> FNOSUM /> FSONP /> /item>item> FADD /> FDESC>Division</FDESC> FNAME>VBAK-SPART</FNAME> FCOL>Dv</FCOL> FNAMENEW>VBAK-SPART</FNAMENEW> FNAMEINT>SPART</FNAMEINT> FKEY /> FGTYP /> FNZERO /> FSUM /> FSONLY /> FSORT>00</FSORT> FSODS /> FSUBT /> FLPOS>0004</FLPOS> FNUMB>98/FNUMB> FNUMBT /> FNOSUM /> FSONP /> /item>item> FADD /> FDESC>Sold-to party/FDESC> FNAME>VBAK-KUNNR/FNAME> FCOL>Sold-to pt/FCOL> FNAMENEW>VBAK-KUNNR/FNAMENEW> FNAMEINT>KUNNR/FNAMEINT> FKEY /> FGTYP /> FNZERO /> FSUM /> FSONLY /> FSORT>00</FSORT> FSODS /> FSUBT /> FLPOS>0005</FLPOS> FNUMB>98</FNUMB> FNUMBT /> FNOSUM /> FSONP /> /item>item> FADD /> FDESC>Material Number Used by Customer/FDESC> FNAME>VBAP-KDMAT/FNAME> FCOL>Customer Material Number/FCOL> FNAMENEW>VBAP-KDMAT/FNAMENEW> FNAMEINT>KDMAT/FNAMEINT> FKEY /> FGTYP /> FNZERO /> FSUM /> FSONLY /> FSORT>00</FSORT> FSODS /> FSUBT /> FLPOS>0006</FLPOS> FNUMB>98</FNUMB> FNUMBT /> FNOSUM /> FSONP /> /item>item> FADD /> FDESC>Net Weight of the Item/FDESC> FNAME>VBAP-NTGEW/FNAME> FCOL>Net weight/FCOL> FNAMENEW>VBAP-NTGEW/FNAMENEW> FNAMEINT>NTGEW/FNAMEINT> FKEY /> FGTYP /> FNZERO /> FSUM /> FSONLY /> FSORT>00</FSORT> FSODS /> FSUBT /> FLPOS>0007</FLPOS> FNUMB>98</FNUMB> FNUMBT /> FNOSUM /> FSONP /> /item> /LISTDESC> SELECTION_TABLE /> /TABLES>\[/code\]I need get output as like below format.Output: Sales Organization Distribution Channel Division Sold-to party Material Number Used by Customer Net Weight of the ItemOR 0001 01 SCEM_02 null PCPlease suggest me how to get this grid format from my xml data. Please reply as soon as possible.Thanks in advance
Regards,Joy
C;/</LINE> /item> /LDATA>LISTDESC>item> FADD /> FDESC>Sales Organization</FDESC> FNAME>VBAK-VKORG</FNAME> FCOL>SOrg.</FCOL> FNAMENEW>VBAK-VKORG</FNAMENEW> FNAMEINT>VKORG</FNAMEINT> FKEY /> FGTYP /> FNZERO /> FSUM /> FSONLY /> FSORT>00</FSORT> FSODS /> FSUBT /> FLPOS>0002</FLPOS> FNUMB>98</FNUMB> FNUMBT /> FNOSUM /> FSONP /> /item>item> FADD /> FDESC>Distribution Channel</FDESC> FNAME>VBAK-VTWEG</FNAME> FCOL>DChl</FCOL> FNAMENEW>VBAK-VTWEG</FNAMENEW> FNAMEINT>VTWEG</FNAMEINT> FKEY /> FGTYP /> FNZERO /> FSUM /> FSONLY /> FSORT>00</FSORT> FSODS /> FSUBT /> FLPOS>0003</FLPOS> FNUMB>98</FNUMB> FNUMBT /> FNOSUM /> FSONP /> /item>item> FADD /> FDESC>Division</FDESC> FNAME>VBAK-SPART</FNAME> FCOL>Dv</FCOL> FNAMENEW>VBAK-SPART</FNAMENEW> FNAMEINT>SPART</FNAMEINT> FKEY /> FGTYP /> FNZERO /> FSUM /> FSONLY /> FSORT>00</FSORT> FSODS /> FSUBT /> FLPOS>0004</FLPOS> FNUMB>98/FNUMB> FNUMBT /> FNOSUM /> FSONP /> /item>item> FADD /> FDESC>Sold-to party/FDESC> FNAME>VBAK-KUNNR/FNAME> FCOL>Sold-to pt/FCOL> FNAMENEW>VBAK-KUNNR/FNAMENEW> FNAMEINT>KUNNR/FNAMEINT> FKEY /> FGTYP /> FNZERO /> FSUM /> FSONLY /> FSORT>00</FSORT> FSODS /> FSUBT /> FLPOS>0005</FLPOS> FNUMB>98</FNUMB> FNUMBT /> FNOSUM /> FSONP /> /item>item> FADD /> FDESC>Material Number Used by Customer/FDESC> FNAME>VBAP-KDMAT/FNAME> FCOL>Customer Material Number/FCOL> FNAMENEW>VBAP-KDMAT/FNAMENEW> FNAMEINT>KDMAT/FNAMEINT> FKEY /> FGTYP /> FNZERO /> FSUM /> FSONLY /> FSORT>00</FSORT> FSODS /> FSUBT /> FLPOS>0006</FLPOS> FNUMB>98</FNUMB> FNUMBT /> FNOSUM /> FSONP /> /item>item> FADD /> FDESC>Net Weight of the Item/FDESC> FNAME>VBAP-NTGEW/FNAME> FCOL>Net weight/FCOL> FNAMENEW>VBAP-NTGEW/FNAMENEW> FNAMEINT>NTGEW/FNAMEINT> FKEY /> FGTYP /> FNZERO /> FSUM /> FSONLY /> FSORT>00</FSORT> FSODS /> FSUBT /> FLPOS>0007</FLPOS> FNUMB>98</FNUMB> FNUMBT /> FNOSUM /> FSONP /> /item> /LISTDESC> SELECTION_TABLE /> /TABLES>\[/code\]I need get output as like below format.Output: Sales Organization Distribution Channel Division Sold-to party Material Number Used by Customer Net Weight of the ItemOR 0001 01 SCEM_02 null PCPlease suggest me how to get this grid format from my xml data. Please reply as soon as possible.Thanks in advanceRegards,Joy