09-15-2008 2:33 PM
Hi Group,
This issue I am facing is on R3T that is a testing server.
In the selection screen if I enter a particular user for Created By field (ernam) its taking ages to show the records, and finally its going to time out dump.
Could you share you ideas on this?
Regards,
Kumar.
09-15-2008 2:36 PM
ernam is not a key field in VBAP table ( you will def get time_out dump ) , try to use the key fields to get your output.
09-15-2008 2:36 PM
ernam is not a key field in VBAP table ( you will def get time_out dump ) , try to use the key fields to get your output.
09-15-2008 2:38 PM
Hi,
Keep the SQL tracer on ST05....and then check which is the SQL statement that is eating the processing time and try to optimize it....
Raghav
09-15-2008 2:39 PM
Hi,
For the particular input value there are so many records in the table( which your fetching the value). So, give the one more input selection creteria to select the value from table.
For Example : If you bukrs only it will contain more data from the table
If you bukrs and prctr it will reduce some data and will not take so much time to display
Regards,
Saran.
09-15-2008 2:39 PM
There are no indexes defined for ERNAM in VBAP nor is it part of the key fields. Obviously it would take long to get the required data. An alternative is to create a search index but that wouldn't be much effective either.
09-15-2008 2:47 PM
Hi virgo rhyme,
in Table VBAP
VBELN
POSNR
are two primary key fields...
As u r fetching data without giving primary key fields the system will take a lot time to retrive all the data created by user ERNAM...
As There will be so mch of records present for the user in VBAP for that particular user....
I would like you to use VBAK first....
Specify ERNAM there get all VBELN and
then pass this VBELN in VBAP and you will get the result...
As VBELN is the KEY field here..
and it will improve the performance as well...
Use FOR ALL ENTRIES here...
Hope it will solve your problem..
Thanks & Regards
ilesh 24x7
09-15-2008 6:12 PM
hi,
u r using the non-key field for selection that's why it was taking ages........so u need to pass the key fields vbeln,posnr along with ur field name...try this
all d best...........