2006 Jun 14 6:54 AM
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.
2006 Jun 14 7:27 AM
2006 Jun 14 7:29 AM
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