Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Problem in Downloading Data to Application Server in XML Format

Former Member
0 Likes
508

Hi Friends,

I am downloading data in XML fomat into Application Server.

Code here:

l_streamfactory = l_ixml->create_stream_factory( ).

l_ostream = l_streamfactory->create_ostream_itable(

table = l_xml_table ).

*To Change the Encoding Type to UTF-8

s_encoding_type = 'utf-8'.

encoding = l_ixml->create_encoding( character_set = s_encoding_type

byte_order = 0 ).

call method l_ostream->set_encoding

exporting encoding = encoding.

*Rendering the document

l_renderer = l_ixml->create_renderer( ostream = l_ostream

document = l_document ).

l_rc = l_renderer->render( ).

*Saving the XML document

l_xml_size = l_ostream->get_num_written_raw( ).

data filepath TYPE string.

data filedir TYPE string.

data filename TYPE string.

data hhh like line of l_xml_table.

filedir = 'C:\usr\sap\PDG\DVEBMGS00\data\'.

CONCATENATE filedir 'poheader.xml' INTO filepath.

OPEN DATASET filepath for output In text mode.

LOOP AT l_xml_table into hhh.

TRANSFER hhh TO filepath.

ENDLOOP.

CLOSE DATASET filepath.

-


if i use for output <b>In text mode</b> it is breaking lines between tags

like

<ITEM><TD_PO_ID>4500012400</TD_PO_ID><TD_LINEITEMID>00010</TD_LINEITEMID><TD_LINEITEMDESC/><TD_MATERIALID>LCD SCREEN</TD_MATERIALID><TD_ORDERED_QTY>1 </TD_ORDERED_QTY><TD_ORDEREDUNIT_PRICE>100.00 </TD_ORDEREDUNIT_PRICE

<b>><</b>TD_UNIT_OF_MEASURE>EA</TD_UNIT_OF_MEASURE><TD_RECEIVABLE_FLAG>N</TD_RECEIVABLE_FLAG><TD_ERSIND>N</TD_ERSIND><TD_BILLEDQTY>0 </TD_BILLEDQTY><TD_BILLEDAMOUNT>0.00 </TD_BILLEDAMOUNT><TD_EXPDELIVERYDATE>06-14-2006 00:00:00</TD_EXPDELIVERYDATE><TD_GLACCOUNT/>

if i use for output <b>In binary mode</b> it is giving only first line in out put..

<?xml version="1.0" encoding="utf-8"?><AP_Purchase_Order_Header xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLoca

Help me regarding this.

Hi Friends,

I am downloading data in XML fomat into Application Server.

Code here:

l_streamfactory = l_ixml->create_stream_factory( ).

l_ostream = l_streamfactory->create_ostream_itable(

table = l_xml_table ).

*To Change the Encoding Type to UTF-8

s_encoding_type = 'utf-8'.

encoding = l_ixml->create_encoding( character_set = s_encoding_type

byte_order = 0 ).

call method l_ostream->set_encoding

exporting encoding = encoding.

*Rendering the document

l_renderer = l_ixml->create_renderer( ostream = l_ostream

document = l_document ).

l_rc = l_renderer->render( ).

*Saving the XML document

l_xml_size = l_ostream->get_num_written_raw( ).

data filepath TYPE string.

data filedir TYPE string.

data filename TYPE string.

data hhh like line of l_xml_table.

filedir = 'C:\usr\sap\PDG\DVEBMGS00\data\'.

CONCATENATE filedir 'poheader.xml' INTO filepath.

OPEN DATASET filepath for output In text mode.

LOOP AT l_xml_table into hhh.

TRANSFER hhh TO filepath.

ENDLOOP.

CLOSE DATASET filepath.

-


if i use for output <b>In text mode</b> it is breaking lines between tags

like

<ITEM><TD_PO_ID>4500012400</TD_PO_ID><TD_LINEITEMID>00010</TD_LINEITEMID><TD_LINEITEMDESC/><TD_MATERIALID>LCD SCREEN</TD_MATERIALID><TD_ORDERED_QTY>1 </TD_ORDERED_QTY><TD_ORDEREDUNIT_PRICE>100.00 </TD_ORDEREDUNIT_PRICE

<b>><</b>TD_UNIT_OF_MEASURE>EA</TD_UNIT_OF_MEASURE><TD_RECEIVABLE_FLAG>N</TD_RECEIVABLE_FLAG><TD_ERSIND>N</TD_ERSIND><TD_BILLEDQTY>0 </TD_BILLEDQTY><TD_BILLEDAMOUNT>0.00 </TD_BILLEDAMOUNT><TD_EXPDELIVERYDATE>06-14-2006 00:00:00</TD_EXPDELIVERYDATE><TD_GLACCOUNT/>

if i use for output <b>In binary mode</b> it is giving only first line in out put..

<?xml version="1.0" encoding="utf-8"?><AP_Purchase_Order_Header xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLoca

Help me regarding this.

2 REPLIES 2
Read only

Former Member
0 Likes
437

Murali,

Check this link. May be this is useful

Thanks,

Read only

sridharreddy_kondam
Active Contributor
0 Likes
437

Hi Krishna,

Just check this Weblog

<b>/people/r.eijpe/blog/2005/11/21/xml-dom-processing-in-abap-part-ii--convert-an-xml-file-into-an-abap-table-using-sap-dom-approach

And I think it would be easy now to transfer that itab into application server...

OPEN DATASET l_out_file FOR OUTPUT IN TEXT MODE

ENCODING DEFAULT.

  • Loop the itab and transfer...

TRANSFER wa_control-file TO l_out_file.

Hope the weblog is useful for u...

Regards,

sridhar