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

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

SAP Print Queue and Printer details from DB level

We can get this information from the DB level via table TSP03D. Below command will give you all the required information. Below commands are specifically for Oracle DB.

# 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.