Spool Format is not properly created

[Former Member]

Dear All,

Actually after application of patches, even x_65_225, also coming in the disturbed format that is some of the coloums are going to second line, to increase the coloumn we have followed the following steps, however we are getting the same disturbed format, is there anything I missed?, Please help me

Note that this solution is for downloading wide formats only - not printing...

Here is what I did:

To create format Y_1024_1023 (New name!)

1) Transaction SPAD

2) Click "Full Administration" button

3) Click on "Device Types" tab

4) Click "Display" button next to "Format Types" field

5) Place cursor on X_65_255

6) Click in menu Format --> Create using template (F5)

7) Change Number of rows to 1023 (if set to 65, you will have more pages and hence more headers)

9) Change Number of Columns to 1023 (as wide as can be displayed in SP01)

8)Give new name to format e.g. Y_1023_1023

To create spool device YSPOOL:

1) Transaction SPAD

2) Click on "Device/Servers" tab (first tab!)

3) Click 'Display" button next to Output Devices field

4) Click "Create" button (Shift-F1)

5) Give output device long name (e.g.YSPOOL) and short name (e.g.YSPO)

6) Device attributes tab --> Device type = ASCIIPRI (Some generic ASCII printer) - I actually used a ZU_ASCII created in our system but ASCIIPRI should also work.

7) Access method tab --> Host printer = some value (e.g. outfile2)

😎 Save

Now assign Y_1024_1023 to Device type:

1) Transaction SPAD

2) Click on Device types tab

3) Enter "ASCIIPRI" in "Device types" field and click display button

4) Click on "Formats" button (F6)

5) Click on "Create' button (Shift-F1)

6) In popup, type Y_1023_1023 (or use drop-down to choose from)

7) Save

Per OSS Note 186603 --> Call SPAD and choose Settings -> Spool System -> Other. Select 'SP01: Number of Lines for List Display from Format'. You may have to clear cache via SPAD->Goto->Cache control -->Click "Reset Cache Settings".

Now, when you schedule your background job, choose YSPOOL as your output device and choose the format as Y_1024_1023. The spool generated from this job will be 1023 columns wide and 1024 lines long (less headers!). Note that opening such a large spool (long & wide) will consume lots of app server memory so exit out as soon as download to presentation server is complete.

[Former Member]

Dear,

All the reports, I had just mentioned the example, all the reports in the background are behaving like this. We have basis and abap patch level 64. Kernal release 155.

Ravi.

[Former Member]

Dear,

We are running the report in the background in which we have 15 coloums, before applying the patches, when we select the format x_65_255, all the 15 coloums use to come in the single line and it look like a neat and clean table that we can export it to excel.

Now the scenario has changed( even if we select the same format x_65_255) , we are getting the out put in which first line consist of

7 colums and the remaing coloums are coming in the next line, please see the previous and this time out put.

Previously : Sales Office SALES GROUP DIV. ....... CD AMT

Value Value Value Value

NOW: Sales Office SALES GROUP DIV. .......

Value Value Value

CD AMT

Value

Please see the diffrence, this CD amount is coming in the next line and the single row is divided into two rows due to this.

I want it in the single row, it is creating confusion when we export it to excel.

Ravi.

[Former Member]

Hi Ravi,

Can I plese have the reportname,SAP release and support pack level?

Regards.

Ruchit.

[Former Member]

Hello Ravi,

What is the meaning of : " some of the coloums are going to second line". Please explain the detail the issue you are facing.

Regards.

Ruchit.