topic Re: How to update internal table from XML? in Application Development and Automation Discussions

How to update internal table from XML?

Former Member — Mon, 09 Jul 2007 16:18:17 GMT

Hi All,

How to update an internal table or table from XML file.

I cannot use XSLT transformation (call transformation) or iXML factory classes (if_ixml )

since I am coding in 4.6C system and both are not present...

Is there any other way to do it?

Thanks in advance for the help.

Thanks and Regards,

Ankit

Message was edited by:

Ankit

Re: How to update internal table from XML?

Former Member — Mon, 09 Jul 2007 16:49:22 GMT

Use GUI_UPLOAD Function module.

In exporting

mention table = internal table.

Reward me if its helpful.

Ravi

Re: How to update internal table from XML?

Former Member — Mon, 09 Jul 2007 17:44:52 GMT

Hi Ravi,

I want to load XML data into internal table,

How is this going to help me?

Regards,

Ankit.

Re: How to update internal table from XML?

former_member194669 — Mon, 09 Jul 2007 18:23:57 GMT

Hi,

Use function module 'TEXT_CONVERT_XML_TO_SAP

aRs

Re: How to update internal table from XML?

Former Member — Mon, 09 Jul 2007 18:31:27 GMT

hi Ars,

I have rewarded points for your answers, i think this just might work,

But im finding it difficult to use, do u have any working example of this FM.

Regards

Ankit

Re: How to update internal table from XML?

former_member194669 — Mon, 09 Jul 2007 18:37:48 GMT

http://www.jt77.com/development1/programming-26330.html

aRs

Re: How to update internal table from XML?

Former Member — Mon, 09 Jul 2007 18:44:04 GMT

Hi,

Please check also FM SMUM_XML_PARSE.

Also have a look at Thomas's blog and check out Unit 10.

/people/thomas.jung3/blog/2005/05/15/abap-46c-to-640-delta-training

Regards,

Ferry Lianto

Re: How to update internal table from XML?

Former Member — Tue, 10 Jul 2007 07:04:34 GMT

Hi Ars,

I am getting short dump with exception conversion failed.

Here is my code:

Report zzz.

DATA : itab_steps LIKE TABLE OF uacc_step WITH HEADER LINE.

DATA : BEGIN OF itab OCCURS 0,

a(100) TYPE c,

END OF itab.

type-pools: TRUXS.

data: TAB_RAW_DATA TYPE TRUXS_XML_TABLE,

TOT_SIZE TYPE I,

TOT_SIZE1 TYPE I.

data: begin of TAB_CONVERTED_DATA occurs 0,

data1(250) type c,

end of TAB_CONVERTED_DATA.

DATA: xml_out TYPE string .

FILENAME1 = 'C:\xx.xml'.

CALL FUNCTION 'TEXT_CONVERT_XML_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR = ';'
I_LINE_HEADER =

I_TAB_RAW_DATA = tab_raw_data

I_FILENAME = filename1

I_TOTALSIZE = tot_size

TABLES

I_TAB_CONVERTED_DATA = TAB_CONVERTED_DATA

EXCEPTIONS
CONVERSION_FAILED = 1
OTHERS = 2

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

break-point.

Re: How to update internal table from XML?

Former Member — Tue, 10 Jul 2007 07:08:46 GMT

declare <b>filename1 TYPE RLGRAP-FILENAME</b>.

Re: How to update internal table from XML?

Former Member — Tue, 10 Jul 2007 07:12:08 GMT

sorry, its missing in code, but its already declared.