Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

start routine taking too long

Hi

I have the below select statement in my start routine

select creditor ac_doc_no from <FI active table> for all entries in <internal table> where

creditor = <internal table>-creditor and

posting date > <internal table>-creditor and

posting date <= sy-datum and

posting key = '31'.

the internal table containg 1 row for each creditor and posting date.

the dso the select is reading has only got 180,000 records in it.

this select statement is taking 1 hour to run and also fails on memory. I have checked st05 trace and it seems that the number of records being read is more than what is in the dso. example, i loaded data for only 1 creditor which has 11000 records in the FI DSO. but when i check in st05, it is showing number of records as 131000. any idea why.

i have created secondary index on the dso which includes creditor, posting date and posting key but does not make any difference. i have used hint command to force this to use the secondary index but no difference.

anyone any ideas?

thanks

Not what you were looking for? View more on this topic or Ask a question