List of SAP Printers, Corresponding Print servers and print queue with Port used

If we need to check printer, access method used in printer, print server and print queue name, then we can get all this information from T-Code SPAD. This is useful if printer list is small, but getting this information for large number of printers is not practical from SPAD.

We can get this information form DB level via table TSP03D. Below command will give you all required information.


# Set output format

COLUMN NAME FORMAT A15
COLUMN PALPDHOST FORMAT A20 WORD_WRAPPED
COLUMN PAMETHOD FORMAT A6
COLUMN PAPROSNAME FORMAT A15
COLUMN NAME HEADING PRINTER
COLUMN PALPDHOST HEADING PRINT-SERVER
COLUMN PALPDPORT HEADING PORT
COLUMN PAMETHOD HEADING METHOD
COLUMN PAPROSNAME HEADING PRINT-QUEUE

# Command

select Name, PAMETHOD, PAPROSNAME, PALPDHOST, PALPDPORT from SAPSR3.TSP03D;


Above command can be updated with where clause if you need information specific to one print server or any other requirement.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Powered by WordPress.com.

Up ↑

%d bloggers like this: