SAP tableObjectTSP01ModuleBASIS

TSP01 table — Spool Request Header Table

TSP01 is the header table for spool requests. Each row represents one spool request created in the system, whether from a background job step, an online print, or an ABAP list, and carries the owner, creation timestamp, title, status, page count and target output device. It does not hold the actual print data, only its metadata.

This page covers TSP01, the SAP table that holds one row per spool request generated in the system. It focuses on the fields consultants actually query when tracing missing or stuck printouts, how TSP01 relates to the underlying content and job tables, and the common mistakes made when reading it directly instead of through SP01.

Published 15 Sept 2026· 1,071 words

What it stores

One row in TSP01 represents a single spool request: the administrative record created every time output is generated in the system, whether by a user printing a list interactively, a background job step producing output, or an interface routine calling an output function. TSP01 stores the request's identity, who created it, when, what it was titled, its current status, how many pages it contains, and which output device it was directed to. The actual formatted content pages, the raster or list data, live elsewhere; TSP01 is purely the control record that SP01 and SP02 display when a user or administrator looks at the spool queue. A spool request can exist in TSP01 long after the job that created it has finished, and can outlive the printer or device it was originally targeted at if that device configuration has since changed.

Key fields

  • RQIDENT - the spool request number, the primary key used everywhere else to reference this request
  • RQCLIENT - the client the spool request belongs to
  • RQOWNER - the user or technical user under whom the request was created, not necessarily the person who later releases or prints it
  • RQDATE - creation date of the spool request
  • RQTIME - creation time of the spool request
  • RQTITLE - the free-text title or name shown in SP01, often the report or job step name
  • RQSTATE - the current status of the request (waiting, in process, completed, error, and so on)
  • RQPAGES - number of pages contained in the spool request
  • RQDEST - the output device the request is or was directed to
  • RQPRIO - the print priority assigned to the request

How it joins the data model

  • TSP01-RQIDENT = TSP03-RQIDENT joins the header to the table holding the actual spool content and page data
  • TBTCP-LISTIDENT = TSP01-RQIDENT links a background job step to the spool request it produced, which is how a scheduled report's output is traced from the job log back into the spool queue
  • TSP01-RQOWNER is compared against the user master to distinguish output created by a real user session from output created under a background processing user
  • A spool request forwarded to fax or email shows up with the same spool number referenced in the send job status record, which is how a send failure is traced back to the originating request in TSP01

How to read it safely

TSP01 is client-dependent; always restrict on RQCLIENT first in any productive system that runs multiple clients, since the table accumulates spool requests from every client on the instance. RQIDENT alone is a good access path if the number is already known, but in troubleshooting the usual starting selection is RQOWNER plus a date range on RQDATE, or RQDEST plus RQDATE when the complaint is about a specific printer. The table grows continuously in an active system and reorganisation jobs periodically purge old entries, so a direct SELECT without date restriction on a long-lived production system can return an enormous result set. Reading through SP01 or SP02 is normally safer than a raw table browse, since those transactions apply the same restrictions with proper authorisation checks.

How to prove it in the data

A user reports a report they ran yesterday afternoon never printed. Select TSP01 with RQOWNER equal to the user id and RQDATE equal to yesterday's date. If a row exists, RQSTATE shows whether the request is still waiting, was already printed, or ended in error, and RQDEST shows which device it was sent to, which often reveals the request went to the wrong or a disabled printer rather than disappearing.

ECC vs S/4HANA

TSP01 is unchanged in shape and purpose moving from ECC to S/4HANA. The spool subsystem architecture was not part of the S/4HANA data model simplification, so the table is read and written the same way, and there is no compatibility view replacing it. SP01 and SP02 continue to operate against it directly.

Common pitfalls

  • Treating RQOWNER as the person who physically printed the document. It is the creator of the request, which for background jobs is a technical user, not the end user who later views or releases the output
  • Deleting rows from TSP01 directly to reclaim space. The content in TSP03 and any linked job or archive references become orphaned, and the correct way to remove spool requests is through the spool administration transactions or the standard reorganisation job
  • Assuming a high RQIDENT value indicates the total volume of spool ever produced. Spool numbers are reused after reorganisation, so the counter does not track lifetime volume
  • Reading RQSTATE codes as self-explanatory without checking the status legend used by SP01. The same letter code can mean different things depending on whether the request went through a printer, an archive, or a business communication channel
  • Querying the table without a client or date restriction on a busy system and causing a long-running, resource-heavy selection when the same answer is available quickly through SP01 with proper selection criteria
  • Concluding a request marked complete was actually delivered to paper or to the recipient's inbox. RQSTATE reflects the state within the spool system, not confirmation that a physical printer produced the page or that an email or fax transmission succeeded

Whose problem this is

Ownership sits with Basis, specifically whoever administers the spool and output management setup. Application teams raise the symptom (a report did not print, an interface output vanished), Basis confirms the state of the request in TSP01 and traces it forward into the printer or output channel configuration.

Related SAP objects

Reviewed pages this object connects to in the ERPClimb knowledge graph.

Source: ERPClimb — https://erpclimb.com/sap-tables/tsp01ERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.