topic Re: Reading a file after submit in Application Development and Automation Discussions

Reading a file after submit

Former Member — Sat, 04 Apr 2009 06:58:00 GMT

Hi All,

I am Submitting a standard transaction FPO4, this will create a file in the application server, i need to get the content of the file. I tried using the FM List to Memory and ASCII but didn't work out.

Could any one please suggest alternate method for doing the same. I would need to read the content of the file and create other report from the data.

Thanks & Regards,

Vijay Penumaka

Re: Reading a file after submit

Former Member — Sat, 04 Apr 2009 07:08:51 GMT

Hi,

If you know the file path on the application server then you can use the OPEN DATASET to read the data from the application server after the SUBMIT statement.

OPEN DATASET p_file FOR INPUT IN TEXT MODE. 
     IF SY-SUBRC EQ 0.
        READ DATASET p_file INTO WA.
        IF SY-UBRC NE  0.
           EXIT.
        ENDIF.
 
       CLOSE DATASET p_file.
    ENDIF.

Re: Reading a file after submit

Former Member — Sat, 04 Apr 2009 07:29:02 GMT

HI ,

u have to use in the following way..

DATA: BEGIN OF it_table OCCURS 0,

value(50) TYPE c,

END OF it_table.

OPEN DATASET file_name FOR INPUT IN TEXT MODE ENCODING DEFAULT.

READ DATASET file_name INTO wa_file.

split wa_file at space into it_table .

loop at it_table .

case sy-tabix.

when 1 .

it_data-del_note = it_table-value.

when 2.

it_data-del_note1 = it_table-value.

when 3.

it_data-del_note2 = it_table-value.

end case.

at last .

append it_data .

endat .

endloop.

CLOSE DATASET file_name .

Re: Reading a file after submit

Former Member — Sat, 04 Apr 2009 07:35:16 GMT

Hi,

Here the issue is file is getting created on the same path every time dynamically. say (/devabap/if/out/XXXX.0 for the first time and the next time we run the report file name would be /devabap/if/out/XXXX.1 etc.2,3,4,5,). I am now using the FM: FILE_GET_NAME to get the name and then proceeding further to get my output.

But when i am trying to use the above function module for a single run i am getting the correct result.

If i run the same report with different variant parallely in background then in the application server there are there are two files already created for two different run's as said above ( .0 and .1) the logic is such that i have to get the latest file and so a wrong file is getting picked up at the time of parallel run.

Note: When i Submit the transaction the ouput screen along with the data contains the file path & name as said above.I am trying to get the file name from the submit screen as the file is generated dynamically. For change in the instance (run) again there will be change in the file name. So system is not identifying the correct file.

Regards,

Vijay