my query is it, but is not fast enough :
OPEN CURSOR WITH HOLD l_cursor FOR
select afru~RUECK afru~aufnr budat
from afru join CRHD ON AFRU~ARBID = CRHD~OBJID
join afpo on afru~aufnr = afpo~aufnr
where ARBPL in WS and
( AUERU = 'X' ) and ( SATZA = 'V40' )
and afru~STZHL = 00000000 and STOKZ = space
and budat in dat and afpo~matnr in MATERIAL.
WHILE NOT l_cursor IS INITIAL.
FETCH NEXT CURSOR l_cursor
appending TABLE it_conf
PACKAGE SIZE 5000.
IF sy-subrc EQ 0.
ELSE.
CLOSE CURSOR l_cursor.
ENDIF.
ENDWHILE.
