Skip to Content

Excel generation through batchjob

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jan 05, 2017 at 02:04 PM


    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.




    Add comment
    10|10000 characters needed characters exceeded