start routine taking too long
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?