topic Reading data from flat file in aplication server in Application Development and Automation Discussions

Reading data from flat file in aplication server

Former Member — Tue, 12 Dec 2006 04:55:33 GMT

hi all,

can any body provide code how to read data from flat file which is in application server.

thanks in advance

Re: Reading data from flat file in aplication server

anversha_s — Tue, 12 Dec 2006 04:58:21 GMT

hi,

chk this sample code.

parameters: p_file like rlgrap-filename obligatory
default '/usr/sap/upload.xls'.
 
types: begin of t_data,
vbeln like vbap-vbeln,
posnr like vbap-posnr,
matnr like vbap-matnr,
werks like vbap-werks,
megne like vbap-zmeng,
end of t_data.
data: it_data type standard table of t_data,
wa_data type t_data.
 
open dataset p_file for output in text mode encoding default.
if sy-subrc ne 0.
write:/ 'Unable to open file:', p_file.
else.
do.
read dataset p_file into wa_data.
if sy-subrc ne 0.
exit.
else.
append wa_data to it_data.
endif.
enddo.
close dataset p_file.
endif.

Rgds

Anver

Re: Reading data from flat file in aplication server

Former Member — Tue, 12 Dec 2006 05:36:44 GMT

hi anvar thanks a lot.

similarly i had to split that(file) data in that file(based on size into small files).again i had to send this splitted file into application server.

can u help me in this regard.

Re: Reading data from flat file in aplication server

anversha_s — Tue, 12 Dec 2006 05:38:29 GMT

hi siva,

Sorry, i am not sure how to do that.

can u post this requirement as a new question.

then others can help in this matter.

Rgds

Anver

Re: Reading data from flat file in aplication server

Former Member — Tue, 12 Dec 2006 05:44:22 GMT

ok anvar

thank you

Re: Reading data from flat file in aplication server

Former Member — Tue, 12 Dec 2006 08:29:31 GMT

hi anversha,

i have small doubt.the path of the file p_file should definitely be in application server. can it work if the file is in presentaion server(reg the code given by u.

regards

siva

Re: Reading data from flat file in aplication server

anversha_s — Tue, 12 Dec 2006 08:34:21 GMT

hi,

u can run the Transaction CG3Z

to upload the file from local pc to application server.

rgds

anver