Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from JG-SAPHR on Oct 15 at 5:58 PM 1. Txn AL11: Check / note down the directory name where you want the report
2. Txn SQ02: Check the dataset which you want to use; if necessary add any user fields, add any ABAP code to validate/check and output the field. Save the dataset, generate it. Adjust it if necessary and generate again.
3. Txn SQ01: Using the dataset from above create the query as per your business requirements. Save the query and immediately go to SE38;
4. Txn SM32 or STVARV: For report period, date etc, it would be better to use a variable name (e.g., reporting period or date) - Maintain TVARVC to set up one or more variant names. Set up the variable data as required. This will need to be maintained before executing a job as set up below.
5. Txn SE38: this should now have the program module name generated from the query; if not use part of the query name as a wild card and search for the module name. Select the appropriate one. It should also have the system/client name in the selection list.
Execute(or hit PF8) the prog module, this should bring up selection screen. Enter any selection criteria as required - e.g., emp group/subgroup, payroll area, etc. Enter the report directory (from AL11 step) and add a report name under the directory. Save the variant for the prog module.
Use the selection variable names from step 4 with variable type T or B as required.
6 Txn SM36 - Set up job to run the prog module above,
(see links
http://scn.sap.com/docs/DOC-46829
http://wiki.scn.sap.com/wiki/display/Basis/How+to+ maintain+and+monitor+background+jobs+via+SAP)
7. txn SM37: Enter the job name from step 6 above. If necessary release it; Check if completed or if it has any problems. Check completed jobs for any output.
| | | ---------------Original Message---------------
From: Girish
Sent: Wednesday, October 15, 2014 8:34 AM
Subject: Export Data From SAP ERP to Excel/.csv using SAP Query
Hi,
I need to export data from SAP ERP to excel/.csv using SAP Query with background job and file should be store on App Server(Tcode AL11).
If it's possible, then please let me know the steps.
If it's not possible by SAP Query then which other options are available?
Please let me know. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
