08-02-2014 9:08 AM
Hi friends..
I got the requirement for downloading the data from application server in the background. How should I do this any body can explain me? client asking it is mandatory? i want to do the automated process. so I need to download the data in the back ground. any body please help me. how should I do the process.?
08-02-2014 9:12 AM
Hi,
please process the report in the background mode and it will generate the spool then you can download the same there is an option at the top to run the report in background mode.
for automated process you can schedule the report on daily basis in SM36.
Regards:
Akash Ahuja
08-02-2014 9:21 AM
i have tried with in the background for download the data. after some time job has cancelled. I have developed the report using open data set and read dataset for downloading the data. after job scheduling how to check the spool? let me tell?
08-02-2014 9:27 AM
Hi,
First please check why this job got cancelled in Tx-SM37 and also the spool also shown in this transaction.
Regards
Akash Ahuja
08-02-2014 9:52 AM
for uploading the background working successfully... for download the job has cancelled because of the below the error log.
Job started
Step 001 started (program Z_SALESORDER_DOWNLOAD, variant &0000000000000, user ID PWCIN)
Could not ascertain code page
Job cancelled after system exception ERROR_MESSAGE.
thanks & regards
raj
08-02-2014 10:05 AM
Create a file in Application server using open data set and use FTP to transfer your data to any systems.
Regards,
Vadamalai A.
08-02-2014 10:12 AM
dear vadamalai,
I have created the file in the application server. can you tell me how to use FTP and as well as tell me steps for downloading the data in the background. because I don't have an idea about FTP.
thanks & regards
Raj
08-02-2014 10:51 AM
Hi Raj Kumar,
This Link will surely help you to download data from application server.
http://scn.sap.com/docs/DOC-10182
If you search in SCN you will get many helpful documents and discussions, no need to
ask a question.
thanks,
vidyasagar
08-02-2014 11:17 AM
First develop the program using below code and schedule as background job. This will generate file for mail/ftp.
CONCATENATE 'TEST_'S_DATE '.XLS' INTO V_NAME.
IF SY-SYSID EQ 'BEP'.
CONCATENATE '/FOLDER/' V_NAME INTO LV_FILENAME.
ENDIF.
OPEN DATASET LV_FILENAME FOR OUTPUT IN BINARY MODE .
LOOP AT IT_LINES INTO LS_TLINE.
TRANSFER LS_TLINE TO LV_FILENAME .
ENDLOOP.
CLOSE DATASET LV_FILENAME.