In module pool program search help problem.

Dear All,

In event Process on value-request(POV).

I want to create search help for one filed suppose MATNR is this filed .Now when i pressing F4 on that field that time only 541 movements type materials on specific date ,vendor and plant should come into that search help.

In short i want to give some condition for that search help and on that logic values or materials should come into search help after pressing F4.

I did like this ,

SELECT * FROM mkpf

INTO TABLE it_mkpf

WHERE budat = date1.

this date1 is from that screen only but value is not coming in that.

how to take that date while pressing f4 on matnr field.

if sy-subrc = '0'.

SELECT matnr FROM mseg

INTO table values_tab

FOR ALL ENTRIES IN it_mkpf

WHERE mblnr = it_mkpf-mblnr

AND mjahr = it_mkpf-mjahr

AND bwart = '541'

AND werks = '5101'

AND lifnr = '10005'.

endif.

From above select query that material i m taking.

but first select query is not executing bcoz of that date1 value is empty.

please give me the ans to come out from this issue.

Thanks & Regards,

Sanket.