topic Re: To create a file on Application Server in Application Development and Automation Discussions

To create a file on Application Server

Former Member — Fri, 22 Sep 2006 05:27:36 GMT

How can i create a File on Application Server ?

Please send code for that .

e-mail-- kknewdelhi@gmail.com

Re: To create a file on Application Server

Former Member — Fri, 22 Sep 2006 05:31:40 GMT

Hi krishna,

1. we will have to use

the commands

OPEN DATASET, TRANSFER, CLOSE DATASET

2. Just see F1 help on it.

3. Also note that the filename

to open

is case sensitive in case of UNIX/AIX

application servers.

regards,

amit m.

Re: To create a file on Application Server

Former Member — Fri, 22 Sep 2006 05:31:42 GMT

hi,

we use OPEN DATASET and CLOSE DATASET commands for creating a file on application server.

u can see them in AL11.

OPEN DATASET <filename> FOR INPUT IN TEXT MODE.

LOOP...

TRANSFER <itab> to <filename>

ENDLOOP.

CLOSE DATASET <filename>.

reward if found useful...

Re: To create a file on Application Server

Former Member — Fri, 22 Sep 2006 05:32:08 GMT

<b>CG3Z</b> - Upload a empty file to a application server from presentation server.it create a file in application server.

Re: To create a file on Application Server

Former Member — Fri, 22 Sep 2006 05:32:32 GMT

Hi,

Go thro' the link, this might help,

http://www.sapdevelopment.co.uk/file/file_downloadsap.htm

Rgds,

Re: To create a file on Application Server

Former Member — Fri, 22 Sep 2006 05:35:04 GMT

Hi Krishna Kuamr,

there is a slight change in Pawan's Code to write to an Application Server.

OPEN DATASET <filename> FOR <b>OUTPUT</b> IN TEXT MODE.

LOOP...

TRANSFER <itab> to <filename>

ENDLOOP.

CLOSE DATASET <filename>.

Re: To create a file on Application Server

Former Member — Fri, 22 Sep 2006 05:36:26 GMT

Hi Krishna,

Check your mail now.

Regards,

Vinay

Re: To create a file on Application Server

Former Member — Fri, 22 Sep 2006 05:36:44 GMT

Use OPEN DATASET Stmt.

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.

Re: To create a file on Application Server

Former Member — Fri, 22 Sep 2006 05:55:01 GMT

Hi,

in first reply i have posted code for reading file from application server.

this code will create file on applicaton server.

in this code i have added "length" statement which is use to catete record when you have no data for the last field. for example you have data in you itab like..

ABC 123 XYX

WER 453 SDF

ASS 577

QWE 321 232

in this situation when you dont have record for the third row, file will be created with blank record.

open file on application server.

open dataset <file name> for output in text mode.

transfer the record first.

transfer itab to <filename> length len.

close the file at Application Server.

close dataset <filename>.

Re: To create a file on Application Server

Former Member — Fri, 22 Sep 2006 06:04:37 GMT

Use code:

DATA:

dsn(40) VALUE

'\usr\sap\TDV\DVEBMGS00\data\stat.dat',

rec(80).

First use opendataset.

read datset and last close dataset.

OPEN DATASET dsn.

IF sy-subrc = 0.

DO.

READ DATASET dsn INTO rec.

IF sy-subrc <> 0.

EXIT.

ELSE.

WRITE / rec.

ENDIF.

ENDDO.

ENDIF.

CLOSE DATASET dsn.

Re: To create a file on Application Server

Former Member — Fri, 22 Sep 2006 06:09:32 GMT

Sorry.

Use transfer insted of read staments

Thanks