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'.
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,