on 2016 Oct 25 5:59 PM
We would like to investigate technical feasibility of creating a SAP batch job that can run a query, And export the results to an excel spreadsheet and save to a location. Can any one me on this.
Request clarification before answering.
Hi,
The default output format on the job/process definition level is used to set
the mime-type used to open a file. It does not convert a file in text format to CSV format. The file needs to
be generated in CSV format by the ABAP job in the SAP system. So if you view the format as excel on SAP side, Then when downloaded to CPS, the CSV default format property is used to determine how to open the file. So can you please check the output file of the ABAP job in
the SAP system - Does the output file show in text format when you check the output file in SAP directly?
Also Can you please check if you have created the Registry key /configuration/mail/AutoExtension=false?
See the following information from the CPS admin guide:
**************************************
Automatic Extensions
SAP CPS appends extensions automatically to text files and HTML files, which do not already have a .txt or .html extension.
You can disable this by specifying one of the following:
1. @autoextension=false - in the comment of the format
2. Registry key /configuration/mail/AutoExtension/<Format_Partition>/<Format_Name>=false
3. Registry key /configuration/mail/AutoExtension=false
Note that the settings are parsed in this order, the first setting found is used. If none are found, the default is true.
*************************************
Regards
Adrienne
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
64 | |
10 | |
8 | |
8 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.