topic extract file from application server in Application Development and Automation Discussions

extract file from application server

Former Member — Wed, 21 Feb 2007 17:09:49 GMT

Hi, All

in our application server ther is a file in
tmp\sap\legacy\filename_yyyymmddhhmmss.txt this file gets generated every day night so when i run my program i need to get the data in the file to my internal table.

i have to use data sets to do this

can any one send me the code for this please

thanks,sri

Re: extract file from application server

Former Member — Wed, 21 Feb 2007 17:13:07 GMT

Hi,

PARAMETERS: p_file(100).

DATA: BEGIN OF itab OCCURS 0,

f1(10),

f2(20),

*******Give the field names accordingly to the length of each column..

END OF itab.

START-OF-SELECTION.

OPEN DATASET p_file.

IF sy-subrc = 0.

DO.

READ DATASET p_file INTO itab.

IF sy-subrc <> 0.

EXIT.

ELSE.

APPEND itab.

CLEAR itab.

ENDIF.

ENDDO.

ENDIF.

CLOSE DATASET p_file.

Thanks,

Naren

Re: extract file from application server

Former Member — Wed, 21 Feb 2007 17:16:22 GMT

Thanks naren

and where do i give the file name which i have in the application server because a new file will be created every night

thanks

Re: extract file from application server

Former Member — Wed, 21 Feb 2007 17:17:19 GMT

Type READ on your ABAP editor then put cursor on top of READ and press F1 key. Select the READ DATASET option. The Help has sample code.

Regards

Nic

Re: extract file from application server

Former Member — Wed, 21 Feb 2007 17:24:25 GMT

Hi,

If the file is created once in a day..Why do you have time in the filename..

To solve this issue..

you can create a logical file name in the FILE transaction..

You can give parameter in the filename..

Then use the function module FILE_GET_NAME by passing the logical file name and SY-DATUM in the PARAMETER_1 parameter...

It will give the physical filename..

Thanks,

Naren