Hi,
I wanna count the amount of betrg where the betrg< 100000,
and can i get pernr from transparent table like pa0002 for this betrg ,or if i can join these tables.
DATA : result TYPE pay99_result.
DATA : rt_header TYPE LINE OF hrpay99_crt.
LOOP AT result-inter-crt INTO rt_header .
IF rt_header-lgart = '/180' .
IF rt_header-betrg < 100000 .
pay10 = pay10 + 1.
ENDIF.
IF pay10 <> 0
PERFORM frm_excel_cell USING l_count 22 pay10 0 .
"fill the excel cell with pa10.
ENDIF.
ENDIF.
ENDLOOP.
thank you
regards _ a total newbie.
Message was edited by: nick zhao