Hi ,
i am getting timeout error after one hour after executing my z report and i checked in st22 and it is telling that timeout happened at statement case cobrb-konty in below code.
please tell me what may be problem and how to improve performance.
**************************************
FORM GET_SETTLEMENT_INFO.
clear : cobrb.
*concatenate 'OR' ekkn-aufnr into tobjnr.
select single kostl anln1 anln2 konty aufnr ps_psp_pnr
into (cobrb-kostl, cobrb-anln1, cobrb-anln2, cobrb-konty,
cobrb-aufnr, cobrb-ps_psp_pnr )
from cobrb
where objnr = tobjnr
and perbz = 'PER'.
if sy-subrc <> 0.
select single kostl anln1 anln2 konty aufnr ps_psp_pnr
into (cobrb-kostl, cobrb-anln1, cobrb-anln2, cobrb-konty,
cobrb-aufnr, cobrb-ps_psp_pnr )
from cobrb
where objnr = tobjnr.
endif.
case cobrb-konty.
when 'AN'.
concatenate cobrb-anln1 '-' cobrb-anln2 into tdata-ACCESSKEY.
when 'KS'.
tdata-ACCESSKEY = cobrb-kostl.
when 'OR'.
tdata-ACCESSKEY = cobrb-aufnr.
when 'PR'.
WRITE: cobrb-ps_psp_pnr TO tdata-ACCESSKEY.
when others.
clear tdata-ACCESSKEY.
endcase.
ENDFORM. " GET_SETTLEMENT_INFO
********************************************
Moderator message: what you can do now has been discussed many times, so
Edited by: Thomas Zloch on Dec 5, 2011 5:04 PM