topic Read Application server file and upload into internal table in Application Development and Automation Discussions

Read Application server file and upload into internal table

Former Member — Wed, 18 Jun 2008 07:27:19 GMT

Another help needed guys,

My file in the application server is of format

Name Marks 1 Marks 2 Marks 3............

A 10 15 20

The only thing separating the columns is space.

Actually this file was downloaded from an internal table into the app server.

Now I want to load it back into the internal table.

How do I load this into internal table so that each column goes in separate internal table field.

Currently am using cl_abap_char_utilities=>HORIZONTAL_TAB but I can get only the first column name in my field1 of the internal table.

How should I applroach this?

Points will be awarded for useful answers.

Regards

Ankit

Re: Read Application server file and upload into internal table

Former Member — Wed, 18 Jun 2008 07:29:56 GMT

HI,

Try using fn module GUI_UPLOAD

Re: Read Application server file and upload into internal table

Former Member — Wed, 18 Jun 2008 07:31:52 GMT

HI,

after getting the data into a flat structure...use the 'SPLIT' command to move the data into internal table fields.

Regards,

Vamshi.

Re: Read Application server file and upload into internal table

Former Member — Wed, 18 Jun 2008 07:32:58 GMT

Hi,

You can use F4_DXFILENAME_4_DYNP to upload file from application server.

Reward if useful.

Regards

Susheel

Re: Read Application server file and upload into internal table

Former Member — Wed, 18 Jun 2008 07:39:51 GMT

Hi,

you just use open data set and read data set

and once the data into itab ucan use split statmt(if required)

Regds,

Murali

Re: Read Application server file and upload into internal table

Former Member — Wed, 18 Jun 2008 07:45:40 GMT

Hi ankit,

i think u have uploaded the tab delimited file in the application sever.

then suppose see if u r file is in the format of name#marks1#marks2#marks3.

then in the program u do like this..

first declare one internal table with one filed.

data:

c_hextab(1) TYPE x VALUE '09'.

data:

begin of t_data occurs 0,

line(256) type c,

endof t_data.

and declare one more intternal table

data:

begin of t_itab occurs 0,

name(15) type c,

marks1(4) type c,

marks2(4) type c,

marks3(4) type c,

endof t_itab.

then

open the file with

OPEN DATASET p_file FOR INPUT IN TEXT MODE.

then between do and endo do like this..

DO.

clear t_data.

READ DATASET p_file INTO t_data.

if sy-subrc ne 0.

exit.

else.

split t_data at c_hextab

into t_itab-name

t_itab-marks1

t_itab-marks2

t_itab-marks3.

append t_itab.

endif.

enddo.

i think it will be helpful to u

Please let me know wht type of file has been uploaded into application server.(tab deleimted, comma separated or something else).

Regards,

Sunil Kumar Mutyala.