Hello Gurus:
I have had to use BOTH 'null' and 'space' (ofcourse I tried 'initial' too...) when selecting data from PRPS table, otherwise all the required records were not fetched. I had to do this on two different occassions. The first is a SAP provided field and the other is customer's enhancement. I have cut-paste the two code blocks. Any ideas why?
Thanks in advance,
Sard.
***********(1)**************
select posid objnr func_area zzfunct from prps into
corresponding fields of table it_wbs
where func_area is null or
func_area eq space.
************(2)**************
select prps-pspnr prps-posid prps-post1
...
into (wa_test1-pspnr, wa_test1-posid, wa_test1-post1,
...)
from prps
where prps-posid in s_wbs and
... and
( prps-zzmlind is null or prps-zzmlind eq space ).
.
append wa_test1 to it_test1.
clear wa_test1.
endselect.
