Hi,
We have a z report to display the service tax of customers. This report was executing as required till the previous month but wen we tried to execute it this month we are not getting either the report or errors.
When checked in SM50 we got the details listed below.
No Ty. PID Status Reasn Start Err Sem CPU Time Cl. User
1 DIA 1331222 Running Yes 157:02 1929 320 BASIS
Report / Spool action
ZFI_SERVICE_TAX
Main Program
ZFI_SERVICE_TAX
Action Table
Sequential Read RFBLG.
Could any one suggest me the reason and a solution for this issue.
Thanks in advance,
Neela
Edited by: Neela M B on Oct 8, 2010 12:02 PM
Hi.
1) Double click the line on SM50.
2) Copy the line "Last SQL statement".
3) Go to ST05, press "Enter SQL Statement"
4) Paste there the statement and press Explain
And then post here the result.
Rui Dantas
Seems to be a performance problem ...
Please post your SELECT command on this table (BKPF, BSEG, ...)
Add a comment