SE16N Timeout:

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

regards,

venkat .

[Former Member]

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.