for all enrtries

hallow i have a problem with for all entries ,when i have <b>0000 in jobid</b> i get wrong result and when i do in in loop i get o.k. result,but the problem is the <b>performance</b> in loop becuse in my table i have loot of data .

regards

LOOP AT itab INTO wa_itab.

SELECT pernr orgeh persk stell

FROM pa0001

INTO (wa_mb_emp_tab-pernr , wa_mb_emp_tab-orgeh,

wa_mb_emp_tab-employee_subgroup , wa_mb_emp_tab-stell )

• FOR ALL ENTRIES IN teken_itab

WHERE orgeh = '00009999'

AND ( persg EQ '6' OR persg EQ '7' OR persg EQ '8' )

AND stell = wa_itab-jobid.

IF sy-subrc = 0.

APPEND wa_mb_emp_tab TO mb_emp_tab.

CLEAR wa_mb_emp_tab.

ENDIF.

ENDSELECT.

ENDLOOP.