‎2012 Feb 13 8:05 AM
Dear All,
I am retrieving data from EDIDC table depending upon the creation date and message type. But it is consuming a lot time and hence while going for more than one month data , it gives run time error.
I found while going through debugger that maximum time is consumed by the SELECT query in retrieving the EDIDC data.
Is there any Function Module for retrieving EDIDC table data.
If so kindly let me know.
‎2012 Feb 13 8:15 AM
How can a fm replace this performance issue ? You have only two fields to be passed such as creation date and message type.
For the table EDIDC there is a secondary index 3 for message type. Did you use that ? What is your query written ?
If you look into the standard report RSEIDOC2, the field for creation date used is UPDDAT. It implies usage of secondary index 2
Refer line no 114
Regards
Kesav
‎2012 Feb 13 10:38 AM
Hi ,
Check this [Thread|http://forums.sdn.sap.com/thread.jspa?threadID=1139536&tstart=0].Hope will help you to read EDIDC table data.
Regards,
Saravana.S
Edited by: saravanasap on Feb 13, 2012 11:38 AM