topic Re: SE16N Timeout: in Application Development and Automation Discussions

SE16N Timeout:

Former Member — Tue, 20 May 2008 18:55:43 GMT

Hi All,

SE16N times out for VBAP table with 17Mil Records.

There is a need to get the Document Items which were created or Changed with in the last five days.

What are the alternatives of getting this data?

Does an index on date, create any additional performance issues?

Thanks and Regards,

Raj K.

Re: SE16N Timeout:

Former Member — Tue, 20 May 2008 18:59:38 GMT

anytime you create an index you are basically duplicating the table in your DB.

however, you may not have much choice if you want to select directly on VBAP by date.

can you select from VBAK to see if any Docs had changed then use that to look up which items in VBAP have changed?

EDIT: sorry, i just checked and it looks like VBAK doesn't store a change date for the document level.

Edited by: robert phelan on May 20, 2008 9:01 PM

Re: SE16N Timeout:

Former Member — Tue, 20 May 2008 19:10:15 GMT

hi check the cdhdr or cdpos.. tables in that date range

regards,

venkat .

Re: SE16N Timeout:

Former Member — Tue, 20 May 2008 19:12:05 GMT

Thanks for the Reply Robert and Venkat.

VBAK has a changed date, however, it would be much better if a Lookup does not have to be made from VBAK.

I'm looking for any other way where i can use VBAP directly instead of a lookup on another table.

Re: SE16N Timeout:

Former Member — Tue, 20 May 2008 19:49:54 GMT

write a code to display the records (ALV or something) and run it in background. Then go to SM37 to check the output. The program will not time out.

Re: SE16N Timeout:

Former Member — Tue, 20 May 2008 20:24:23 GMT

if it were between selecting VBAK or VBAP by date range, it would be better to select VBAK first since it has fewer entries. Then select VBAP based on VBAK-VBELN.

However, you can certainly explore creating a new Index for VBAP-change_date.