Skip to Content
0
Former Member
Jul 29, 2005 at 11:43 AM

Performance

13 Views

Dear All,

I am having performance problem in my report .

And getting short dump also.

Would please suggest me how I will rectified it.

Code for your reference.

SELECT *

FROM pa0302

INTO CORRESPONDING FIELDS OF TABLE it_pa0302

FOR ALL ENTRIES IN it_p0001

WHERE massn IN ('01','08','12','EX')

AND pernr = it_p0001-pernr

  • AND ( ( begda BETWEEN w_frmdt and w_todt ) "PJ141004

  • AND begda = it_p0001-begda. "PJ921004

  • AND endda = it_p0001-endda ). " ).

AND begda <= w_todt.

LOOP AT it_p0001.

LOOP AT it_pa0302 WHERE pernr EQ it_p0001-pernr..

it_pernr-pernr = it_p0001-pernr.<-Short dump occurs

it_pernr-werks = it_p0001-werks.

it_pernr-persk = it_p0001-persk.

it_pernr-massn = it_pa0302-massn.

it_pernr-massg = it_pa0302-massg.

it_pernr-act_date = it_pa0302-begda.

IF it_pa0302-massn = '04' AND

( it_pa0302-massg = '02' OR

it_pa0302-massg = ' ' ).

it_pernr-own_int = 'X'.

ELSEIF it_pa0302-massn = '12' AND

( it_pa0302-massg = '01' OR

it_pa0302-massg = ' ' OR

it_pa0302-massg = '03' ).

it_pernr-own_int = 'X'.

ENDIF.

APPEND it_pernr.

CLEAR it_pernr.

ENDLOOP.

ENDLOOP.

Thanks in advance