‎2005 Jun 21 7:51 PM
Hi,
I want to automate a process to export a report output into Excel, so I try to use CATT.
I successfully ran program and created its output report in Excel format. But, when I save the file into a folder on my computer I got a "Runtime error CALL_FUNCTION_CONFLICT_TYPE".
How can I automate the process to save a report (in Excel format) into my local folder?
Thank you very much,
TB
‎2005 Jun 23 6:34 AM
Hi,
Check this link for CATT related information.
http://www.sap-basis-abap.com/sapab027.htm
http://help.sap.com/printdocu/core/Print46c/en/Data/Index_en.htm
‎2005 Jun 23 11:13 AM
Hi,
Automating a report to save a excel file in to your local folder does require the change in the file name when it is saved. say the case when the program gets executed for multiple times then the file which will be saved for the multiple times with the same file name will have the last run data.
so in all case just change the filename while saving with a random number attached to its end.
so while creating the file name:
ws_random type i.
call function 'QF05_RANDOM_INTEGER'
IMPORTING
RAN_INT_MAX = 10000
RAN_INT_MIN = 1
EXPORTING
RAN_INT = ws_random
EXCEPTIONS
INVALID_INPUT.
concatenate 'C:\test' ws_random '.XLS' into ws_filename.
call function 'WS_DOWNLOAD'
exporting
filename = ws_fielname
tables
datatab = i_data
exceptions
"
"
Regards,
Jagath