Solved: DataSet text file to internal table

Former Member · ‎01-14-2015

Hi,

I have an XML file which is stored in AL11 as a one line string like below:

<?xml version="1.0" encoding= "UTF-8"?><GrpHdr><Matnr>1234567</matnr><MTART>type</MTART><MATKL>group</MATKL><BISMT>00000123</BISMT><VOLUM>17</VOLUM></GrpHdr>

I used:

DATA: lv_data TYPE string.

OPEN DATASET file1 FOR INPUT IN TEXT MODE ENCODING UTF-8. and READ DATASET

DO.

READ DATASET file1 INTO lv_data.

**lv_data will contain the same string line as the file appears in AL11.

ENDDO.

My questions is, how can I assign/map the fields in the file to my internal table of type customized table and store the new record in DB table?

Thank you,

Former Member · ‎01-14-2015

Thanks everybody for your help. I have used below guide with exactly the same and it works just as I wanted.

Guide towards a simple conversion of an XML file to ABAP Internal table, using XML parsing

Thank you.

former_member200338 · ‎01-14-2015

you can use transformation. Have a look on call transformation id in SDN

ipravir · ‎01-14-2015

Hi Eman,

If your process is very much frequent use, and there sould not be any changes in future, then i Suggest to go from creation a Transformation for the related XML type.

Creating a Transformation Program - ABAP Workbench Tools - SAP Library

Or your can use the below function module to read the store the XML informaiton in internal Table.

SWF_XML_TO_ABAP

or follow the below Link, which is related to your requirement.

Regards.

Praveer.