topic VBAP Table in Application Development and Automation Discussions

VBAP Table

Former Member — Mon, 15 Sep 2008 13:33:31 GMT

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.

Re: VBAP Table

Former Member — Mon, 15 Sep 2008 13:36:18 GMT

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.

Re: VBAP Table

former_member182354 — Mon, 15 Sep 2008 13:38:11 GMT

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

Re: VBAP Table

saranwin — Mon, 15 Sep 2008 13:39:31 GMT

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.

Re: VBAP Table

Former Member — Mon, 15 Sep 2008 13:39:38 GMT

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.

Re: VBAP Table

Former Member — Mon, 15 Sep 2008 13:47:28 GMT

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

Re: VBAP Table

Former Member — Mon, 15 Sep 2008 17:12:17 GMT

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...........