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