topic code to transfer xml file to abap internal table using transformation in Application Development and Automation Discussions

code to transfer xml file to abap internal table using transformation

Former Member — Fri, 03 Aug 2007 03:29:06 GMT

Hi friends

Given the following xml file .the requirementis to display and transfer the xml file to internal table usin transformation and gui_upload.If any onehaving simple code on this please send .

Can any one sugest the steps to be followed to write source code using simple transformation.

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

- <Negara>

- <item>

- <COUNTRY>

<ZDESC>Pening Lalat</ZDESC>

</COUNTRY>

</item>

- <item>

- <COUNTRY>

<ZDESC>Pening Lalat2</ZDESC>

</COUNTRY>

</item>

</Negara>

Thaking You

Re: code to transfer xml file to abap internal table using transformation

Former Member — Fri, 03 Aug 2007 03:44:58 GMT

hi..

1. itab --- > xml

xml ---> itab.

2. This program will do both.

(just copy paste in new program)

REPORT abc.

*----

DATA

DATA : t001 LIKE TABLE OF t001 WITH HEADER LINE.

DATA : BEGIN OF itab OCCURS 0,

a(100) TYPE c,

END OF itab.

DATA: xml_out TYPE string .

DATA : BEGIN OF upl OCCURS 0,

f(255) TYPE c,

END OF upl.

DATA: xmlupl TYPE string .

FIRST PHASE
FIRST PHASE
FIRST PHASE

*----

Fetch Data

SELECT * FROM t001 INTO TABLE t001.

*----

XML

CALL TRANSFORMATION ('ID')

SOURCE tab = t001[]

RESULT XML xml_out.

*----

Convert to TABLE

CALL FUNCTION 'HR_EFI_CONVERT_STRING_TO_TABLE'

EXPORTING

i_string = xml_out

i_tabline_length = 100

TABLES

et_table = itab.

*----

Download

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filetype = 'BIN'

filename = 'd:\xx.xml'

TABLES

data_tab = itab.

SECOND PHASE
SECOND PHASE
SECOND PHASE

REFRESH t001.

CLEAR t001.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = 'D:\XX.XML'

filetype = 'BIN'

TABLES

data_tab = upl.

LOOP AT upl.

CONCATENATE xmlupl upl-f INTO xmlupl.

ENDLOOP.

*----

XML

CALL TRANSFORMATION ('ID')

SOURCE XML xmlupl

RESULT tab = t001[].

<b>Reward points if useful</b>

Regards

Ashu

Re: code to transfer xml file to abap internal table using transformation

Former Member — Fri, 03 Aug 2007 03:59:57 GMT

good

go through this report

http://www.sap-img.com/abap/xml-file-to-word-document-through-sap.htm

thanks

mrutyun^

Re: code to transfer xml file to abap internal table using transformation

Former Member — Fri, 03 Aug 2007 04:13:28 GMT

Hai Ashu

How to write code in transformation (simple transformation ) .

Than You