topic Re: Table View Select using Date Range Performance in Application Development and Automation Discussions

Table View Select using Date Range Performance

Former Member — Wed, 08 Feb 2006 19:29:17 GMT

Hello,

I'm Basis...Know a little ABAP. Our programmer is overloaded from our current 5.0 upgrade. He has a view (VBAP, VBAK, and VBUK). He is selecting several fields from this view and there is one obligatory field ERDAT. When I enter a single date, the report runs in a few seconds. The problem is when I enter a range (even if it is the same date) it uses the <Between> logic and the job runs for several minutes. Is there a way to improve performance selecting from this view using a date range? Why the big difference with the single ERDAT VS. the ERDAT with the range?

Thanks,

Phil Stracener

Re: Table View Select using Date Range Performance

RichHeilman — Wed, 08 Feb 2006 19:35:43 GMT

I have seen this behavior a number of times. I big part of it may be the fact that ERDAT is not part of the key and that it is not referenced in any index.

Regards,

Rich Heilman

Re: Table View Select using Date Range Performance

Former Member — Wed, 08 Feb 2006 19:36:50 GMT

as ERDAT is select option why dont u use IN S_ERDAT instead of <between> logic.

select * from view where erdat in s_erdat.

this may not solve ur prob but small hint

Re: Table View Select using Date Range Performance

RichHeilman — Wed, 08 Feb 2006 19:37:53 GMT

The select-option will still use the BT functionality internally.

Regards,

RIch Heilman

Re: Table View Select using Date Range Performance

Former Member — Wed, 08 Feb 2006 20:11:46 GMT

ERDAT is part of the index - but for VBAK, not VBAP. Make sure the select is on VBAK-ERDAT. But the BETWEEN may still be slow.

Rob

Re: Table View Select using Date Range Performance

Former Member — Wed, 08 Feb 2006 21:35:03 GMT

The ST05 Trace shows that it's using the correct custom index that has ERDAT in it. He is using VBAK-ERDAT in the view. I'm puzzled... Is this just working as designed?

Thanks,

Philip Stracener

Re: Table View Select using Date Range Performance

Former Member — Wed, 08 Feb 2006 21:42:17 GMT

Does the custom index have VBAK-ERDAT or VBAP-ERDAT?

Which ERDAT is used in the select?

Rob

Re: Table View Select using Date Range Performance

Former Member — Thu, 09 Feb 2006 14:29:42 GMT

It's using VBAK-ERDAT.

Thanks,

Phil

Re: Table View Select using Date Range Performance

Former Member — Thu, 28 Jun 2007 14:39:01 GMT

Hi Phillip,

We are having the exact same issue of a single date vs. a date range...

Did you resolve it?

Please suggest...

Thanks