Skip to Content
Feb 02, 2010 at 11:14 AM

Fetching single field value from table in SAPscript forms


Hello Gurus,

In Training & Event Management, there is some standard mail notification like HR_ALL_TEIL is available which is triggered when any type action is performed like booking, firmly book, cancellation etc. When a mail is sent, the useru2019s designation is displayed as u2018Clerku2019 & the user ID is displayed. In place of user id, the name of the user ID should come. To display the name of the user,we have to use table USR21 to fetch the PERSNUMBER & ADDNUMBER by giving the user ID. In view mode we have to use V_ADDR_USR and give PERSNUMBER & ADDNUMBER to get the full name of the user.

can you pls suggest how to do this in most efficient way to do this as the same changes i need to reflect in 41 forms.