Skip to Content
0
Former Member
Sep 23, 2005 at 02:17 AM

How to select betrg from CRT by transparent table?

42 Views

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