SAP Note 329537 - Spool cut off at 1000 lines when sent to recipient

Symptom

If a batch job creates a spool and sends it to a recipients, only the first 1000 lines are sent.

Other terms

SAPOffice, spool list recipient, SM37, limitation, truncation, attachment, email, mail, incomplete, cut off

Reason and Prerequisites

For performance reasons, the output sent to SAPOffice is limited to 1000 lines.

Solution

If you wish to send spools longer than 1000 lines in Releases > 4.6B, proceeed as follows:

1. Apply the support packages or correction instructions mentioned in this note.

2. Create the following two entries in table TSPOPTIONS with transaction SE16:

option: BTC_FIRSTLINE value: <desired value, probably 1>

option: BTC_LASTLINE value: <desired value, e.g. 99999>

3. Call function module RSPO_OPTION_FLUSH (transaction SE37) with value NAME = '*'.

With a value of '2147483647' ( = 2^31-1) for BTC_LASTLINE, there will be no limitation.

Please note that this change may impact performance, depending on the selected line interval, as more data has to be processed.

In Releases < 4.6C or if you are not able to apply the support packages or corrections, you can accomplish this with a minor code change.

In program RSBTCRTE, change the parameter sent to the function module

RSPO_SPOOLJOB_TO_OFFICE as follows:

call function 'RSPO_SPOOLJOB_TO_OFFICE'

exporting

rqident          = spo_list_id

first_line        = 1

* last_line      = 1000 "<<< Delete

last_line         = 99999 "<<< Insert

receiver        = recipient_object

mail_title       = document_data-obj_descr

exceptions