BKPF table performance.

[Former Member]

Dear experts,

I want some document types

blart - 'Z1','Z2','Z3'

bukrs - SCL

I have no belnr.I have no gjahr.

Now retrieval is slow.It takes about 3 mins to fetch 197 (Z1,Z2,Z3) .

I am really going mad o n this query .I tried awtyp = 'BKPF'.I tried

belnr > 0.Not helping me much !!.Plz help

[Former Member]

Yes !.Last but not the least i need this information from BKPF table

[peter_peng]

Hi,

I think the better way is to create a index according to your fields which are used to select data.

Good luck.

Peter

[Former Member]

Dear Peter,

I already read quite a few forums of users in problem using this table.And all i can attribute all this is bad design of

schemas done by sap.Brand takes it name and people suffer.

A very similar table is mseg where we are facing problem about fast retrieval.MB51 with passage of time is

becoming slow.A customer expects a finished product with zero defect.But SAP has only and only defects.

[Former Member]

Dear Peter,

I already read quite a few forums of users in problem using this table.And all i can attribute all this is bad design of

schemas done by sap.Brand takes it name and people suffer.

A very similar table is mseg where we are facing problem about fast retrieval.MB51 with passage of time is

becoming slow.A customer expects a finished product with zero defect.But SAP has only and only defects.

[Former Member]

Its quite obvious that it is taking 3mins for fetching 3 records, you need to try out with some

idea on keeping the fiscal year and document number. I can suggest you like according to the

requirement put a range of fiscal years in the select query so that performance can be raised.

Like

DATA: h_gjahr TYPE gjahr,

l_gjahr TYPE gjahr.

h_gjahr = sy-datum+0(4).

l_gjahr = h_gjahr - 1.

select bukrs BELNR GJAHR BLART from bkpf into itab where bukrs eq 'SCL',

gjahr BETWEEN l_gjahr AND h_gjahr.

So in my case i will fetch the records according to the current fiscal year and previous fiscal year.

Make some idea like this but...

Caution: Make sure wht will be fiscal years that need to bring into picture with your functional guy.

Regards

VEnk@

Edited by: Venkat Reddy on Nov 26, 2009 12:59 PM

[SuhaSaha]

Dear Aditya,

I chek in my system SAP has provided a standard index for these fields. Check in your system if the index is available based on Company Code & Doc. Type (BKPF~3).

BR,

Suhas