data Retrieving from XML format to internal table(deep structure)

Former Member — Wed, 15 Nov 2006 21:43:05 GMT

hi all,

can anybody help me how to Retrieving data from XML format to internal table(deep structure)

and if u have any sample code for that please send it.

my internal table is like this

DATA: BEGIN OF ty_text,

vbeln TYPE vbeln,

posnr TYPE posnr,

seqno TYPE seqno,

textid TYPE tdid,

tdline TYPE tdline,

END OF ty_text.

DATA: BEGIN OF ty_item,

vbeln TYPE vbeln,

posnr TYPE posnr,

product TYPE matnr,

prodes TYPE arktx,

ordqty TYPE kwmeng,

werks TYPE werks_d,

unitprc TYPE netpr,

dispct1(16),

dispct2(16),

dispct3(16),

text LIKE table of ty_text,

END OF ty_item.

DATA: BEGIN OF ty_header,

vbeln TYPE vbeln,

slstype TYPE auart,

vkorg TYPE vkorg,

vtweg TYPE vtweg,

spart TYPE spart,

soldto TYPE kunnr,

billto TYPE kunnr,

shipto TYPE kunnr,

bstkd TYPE bstkd,

bstdk(10) TYPE c,

prsdt(10) TYPE c,

audat(10) TYPE c,

ketdat(10) TYPE c,

zterm TYPE dzterm,

inco1 TYPE inco1,

item like table of ty_item,

END OF ty_header.

DATA: it_header LIKE TABLE OF ty_header WITH HEADER LINE .

and my xml file is like this:

<?xml version="1.0" encoding="utf-8" ?>

- <SO>

<BSTKD>sample chg 1000</BSTKD>

- <ITEM>

- <item>

<PRODUCT>CEMENT2</PRODUCT>

<PRODES>cement type 2</PRODES>

- <TEXT>

- <item>

</item>

- <item>

</item>

</TEXT>

</item>

- <item>

<PRODUCT>CEMENT2</PRODUCT>

<PRODES>cement type 2</PRODES>

- <TEXT>

- <item>

<TDLINE>Test Cement Product</TDLINE>

</item>

</TEXT>

</item>

</ITEM>

</SO>

regards,

prasad

Re: data Retrieving from XML format to internal table(deep structure)

Former Member — Fri, 17 Nov 2006 15:02:04 GMT

Read the documentation for class : CL_IXML

BR< JAcek

Re: data Retrieving from XML format to internal table(deep structure)

Former Member — Fri, 17 Nov 2006 21:29:13 GMT

Try the function module SMUM_XML_PARSE

Re: data Retrieving from XML format to internal table(deep structure)

athavanraja — Sat, 18 Nov 2006 13:38:31 GMT

check this thread where i had given a sample code for transforming XML into nested ITAB

Regards

Raja

topic Re: data Retrieving from XML format to internal table(deep structure) in Application Development and Automation Discussions

data Retrieving from XML format to internal table(deep structure)

Re: data Retrieving from XML format to internal table(deep structure)

Re: data Retrieving from XML format to internal table(deep structure)

Re: data Retrieving from XML format to internal table(deep structure)