topic Re: Facing problem in selecting from table vbrk in Application Development and Automation Discussions

Facing problem in selecting from table vbrk

Former Member — Wed, 13 Jun 2007 05:28:15 GMT

Hi,

I have developed a simple report for calculating the total logistic cost.

That program was working fine in the development server.

Now in production, its not working.

While debugging i found that its getting stuck at a select query where its fetching data from VBRK table and is getting timed out.

What should be done for reducing the time?

Please help.

Thanks in advance

Nitin

Re: Facing problem in selecting from table vbrk

Former Member — Wed, 13 Jun 2007 05:29:59 GMT

Hi,

Make sure the VBRK select is using an index...OR using the primary key..

Thanks,

Naren

Re: Facing problem in selecting from table vbrk

Former Member — Wed, 13 Jun 2007 05:31:36 GMT

hi nitin,

use where condition in select statement to minimize the selection criteria if u dont use the same in select statement.

reward points if helpful.

regards,

seshu.

Re: Facing problem in selecting from table vbrk

Former Member — Wed, 13 Jun 2007 05:36:52 GMT

mention all the fields of a WHERE condition in order maintained in table....because data is filtered based on order of fields mentioned in condition ...in case if u mention a primary key as last condition in WHERE clause then performance will not be good

Re: Facing problem in selecting from table vbrk

Former Member — Wed, 13 Jun 2007 05:40:13 GMT

hi,

must include all necessary filtering fields, after select statements use COMMIT WORK, it will free the memory....and if it still take too long..then put it in background process...

Re: Facing problem in selecting from table vbrk

dev_parbutteea — Wed, 13 Jun 2007 05:45:40 GMT

Hi,

try to add fields like GJAHR. it will restrict your select statement and improve performance.

Regards,

Sooness

Re: Facing problem in selecting from table vbrk

Former Member — Wed, 13 Jun 2007 05:49:43 GMT

Hi Naren ,Seshu & Aarun

First of all thanks a lot for replying.

The structure of my select query is

START-OF-SELECTION.

SELECT cityc regiogroup bzirk INTO TABLE it_ztaluka_1

FROM ztaluka_1

WHERE regiogroup IN pregroup.

IF sy-subrc NE 0.

MESSAGE 'No records in ztaluka_1.' TYPE 'E'.

ENDIF.

I N I T I A L I S I N G IT_VBRK F R O M VBRK *******

IF NOT it_ztaluka_1[] IS INITIAL.

SELECT vbeln bzirk regio cityc zzwerks knumv

FROM vbrk

INTO TABLE it_vbrk

FOR ALL ENTRIES IN it_ztaluka_1

WHERE zzwerks IN pzzwerks

AND regio IN pregio

AND cityc = it_ztaluka_1-cityc.

IF sy-subrc NE 0.

MESSAGE 'No records in vbrk.' TYPE 'E'.

ENDIF.

SORT it_vbrk BY vbeln .

The key field is vbeln,but that not included in my where condition as its not in my selection criteria also in the previous tables which r used in the program.

i found the order in the select qusery is not in the order of vbrk table.

That i will change.But since the key field is not included it will again cause problems na??

Re: Facing problem in selecting from table vbrk

Former Member — Wed, 13 Jun 2007 05:59:42 GMT

Hi sooness,

U suggested to add fields like GJAHR,in where condition or in the select statement itself?

If u dont mind plz clear my doubt.

Thanks in advance

Nitin

Re: Facing problem in selecting from table vbrk

Former Member — Wed, 13 Jun 2007 06:01:24 GMT

Hi Leonard

How to put in back ground?

Thanks ..

Nitin

Re: Facing problem in selecting from table vbrk

Former Member — Wed, 13 Jun 2007 06:02:39 GMT

hiii nitin

from ur source code it looks like u r slectiong data from vbrk on the basis of ur ztable on dev server. do you tranport the same structure on prod server along with your program code plz chk that

Re: Facing problem in selecting from table vbrk

Former Member — Wed, 13 Jun 2007 06:02:50 GMT

hi,

put your program in BDC...

Re: Facing problem in selecting from table vbrk

Former Member — Wed, 13 Jun 2007 06:10:57 GMT

Hi Gaurav,

That ztable is created by me only and i transported that to the production at the same time.

And in production when i debugged na,the internal table it_ztaluka_1 is getting filled properly.

Thank

Nitin

Re: Facing problem in selecting from table vbrk

dev_parbutteea — Wed, 13 Jun 2007 06:35:32 GMT

HI,

put it in where condition! thu you will retrieve data of current fiscal year only. Try to put other fields that will filter out unwanted data.

Reagrds,

Sooness