How to send Spool request in .xls format from SAP CPS

[Former Member]

Hi Experts,

We have a new requirement. Client is asking to send spool in x.ls format instead of txt format via mail. Is there any possibility to send spool request in .xls format from SAP CPS?

Regards

Rajkumar

[nanda_kumar21 · Accepted solution]

You can set the default output format of that job definition to CSV as shown below and the reschedule the job.

Thanks

Nanda

[Former Member · Accepted solution]

Hi Nanda,

Thanks for you Guidance. If CSV is selected it is not opening in Excel but opening in notepad only. I tried with Excelsheet option then it is working.

Regards

Rajkumar

[Former Member · Accepted solution]

Hi Raj. What support pack is your R3 system on? We were trying to meet this requirement as well but the related OSS notes were not applicable because of our support pack. Just wondering what SP level you are on. Thanks.

[Former Member · Accepted solution]

Hi Jonathan,

Please find details of the R3 system SP level we have.

Redwood Cronacle: Build: M33.98-71744

SAP R3 details:

SapRelease: 720 / 701

SAP application release     : 701

SAP kernel release          : 720

SP Level

SAP_BASIS 701 0014 SAPKB70114        SAP Basis Component

SAP_ABA        701 0014 SAPKA70114        Cross-Application Component

PI_BASIS 701 0014 SAPK-70114INPIBASIS Basis Plug-In

ST-PI 2008_1_700 0008 SAPKITLRD8        SAP Solution Tools Plug-In

SAP_BS_FND 701 0014 SAPK-70114INSAPBSFND SAP Business Suite Foundation

SAP_BW        701 0014 SAPKW70114        SAP Business Warehouse

SAP_AP        700 0030 SAPKNA7030        SAP Application Platform

WEBCUIF        700 0014 SAPK-70014INWEBCUIF SAP WEBCUIF 700

Regards

Rajkuamr

[nanda_kumar21 · Accepted solution]

when you try to open a CSV in excel it will ask you whether or not to open and it might even give options to choose which are column separating values and such.

Can you please provide me a screenshot on what happens when you try to open the CSV in Excel?

thanks

Nanda

[Former Member · Accepted solution]

Hi Nanda,

Even after providing value CSV in default output format, the file is being generated with .txt only not in CSV. The I tried with Excelsheet it worked and produced spool file with .xls format.

Regards

Rajkumar

[Martina_Gállego · Accepted solution]

Dear Rajkumar,

Please close the thread if your problem is resolved by giving correct/helpful answers.

http://scn.sap.com/community/support/blog/2013/04/03/how-to-close-a-discussion-and-why

Thanks!!!!

Best regards,

Martina

[Former Member]

This message was moderated.