02-27-2007 4:28 PM
i have two tables zfm_handy and zfmkstel.
my requirement is i want to update and insert data to the ztables by using screen.
screen fields r TELNUM (keyfield), KARTNR (keyfield) based on these two fields i m getting other fields data like PERNR, PINNR,IMEI.
If u enter telnum and press enter get the output like this
TELNUM +49(151)150124
KARTNR 172673637373
PERNR 742
IMEI HUTCH
The above fields r created in se51.
my requirement is when the field PERNR exist then dispaly a name near by like this
PERNR 742 NARENDRA CHOWDARY
NARENDRA(FIRST NAME) CHOWDARY(LASTNAME)
these fields r getting from table PA0002 with fields NACHN and VORNA
no need to go for se51 to display name.
02-27-2007 4:31 PM
Hi,
Create a text label next to the field ..
Then in the PBO..get the values from the table PA0002.
PROCESS BEFORE OUTPUT.
MODULE GET_TEXT.
***CODE
MODULE GET_TEXT.
SELECT SINGLE * FROM PA0002 WHERE PERNR = SCREEN_FIELD-PERNR.
IF SY-SUBRC = 0.
SCREEN_FIELD-PERNR_NAME = PA0002-NACHN.
ENDIF.
ENDMODULE.
Thanks,
Naren