Skip to Content
Author's profile photo Former Member

How to export printers only defined in default printer area in su01

To export and import the printers later we need their short names.

Lname , padest columns of table tsp03l  gives us the long and short name of the printer.  To find which of these printers are used as default printers by users we need to check  Spld column  from usr01.

We use distinct to choose unique names to eliminate duplicate printer names.  So the command for selecting short names of default printers used in an SAP systm with db2 database will look like this .

db2 => select distinct a.lname from sapdca.tsp03l a, sapdca.usr01 b where b.spld=a.padest

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.