Question:
Recently I came accorss one report painter 12 month rolling actuals cost center report which is made by report painter. This report is slow. TheSQL trace shows that
. access new table.
. data pages are read in advance
. pure sequential prefetch is used
. new table:
. SAPR3.COSP
. table space locked in mode: N
. Accesstype: by index.
. Index: SAPR3.COSP~1 (matching index)
. Index columns (ordered):
. OBJNR
. MANDT
. LEDNR
. VERSN
. WRTTP
. GJAHR
. VRGNG
. with 1 matching columns of 7 index columns.
Please help how to make the performace improvement in Painter to make all the matching column of index column
Answer:
hi ,
as per my knowledge u cann't increase performance of reports which are Generated thru Report Painter . But what u can do is u can change the Chat/Key figures for what Report Selection which is tough Job for a ABAPers .
2. other option is u have to develop a Report based on the Key figures , and this one also Big one .
Please , i am telling on my experience . I have workedout on trail balance report.
regards
Prabhu
_________________
With Best Regards
Prabhu
TC-Team SAP
Pepsi India
nethranp@hotmail.com