topic Automatically fill fields in Application Development and Automation Discussions

Automatically fill fields

Former Member — Wed, 30 Nov 2005 00:21:07 GMT

I have 2 fields

Employee No. _________

Employee Name

I want the following, when the user fill the Employee No. and press Enter the Employee must appear automatically.

Where can I find info. about this?

Thanx

Re: Automatically fill fields

RichHeilman — Wed, 30 Nov 2005 00:46:20 GMT

In a selection screen?



data: xpa0002 type pa0002.

parameters: p_pernr type pa0002-pernr.
parameters: p_name(30) type c.

at selection-screen output.

select Single * from pa0002 into xpa0002
           where pernr = p_pernr.
if sy-subrc = 0.
concatenate xpa0002-vorna xpa0002-nachn into p_name 
        separated by space.
endif.

Regards,

Rich Heilman

Re: Automatically fill fields

Former Member — Wed, 30 Nov 2005 05:05:25 GMT

Hiii Jose,

What u have to do

*****************************************************

Suppose the dbtable is like this

emp_no "Employee_no.

emp_name "Employee Name

***********************************************

data: e_name type <dbtable-emp_name>.

case sy-ucomm.

when 'ENTER'.

Select emp_name into e_name from <dbtable> where emp_no = field1.

field2 = e_name.

endcase.

Hope this work 4 u.

Do reward if it works.

Regards

Sachin Dhingra