topic Re: Performance Issue with BSEG cluster table in Application Development and Automation Discussions

Performance Issue with BSEG cluster table

Former Member — Thu, 28 Oct 2010 09:13:11 GMT

Hi Experts,

we are trying to get SHKZG (Debit/Credit Indicator) from BSEG Table by passing BELNR, BUKRS,SAKNR and MATNR. But we are having issue with the performance, as BSEG is cluster table and also we are not using Primary Keys to retrieve the data.

Is there any underlying index tables where we can get this information? Please let me know.

Regards,

Raju

Re: Performance Issue with BSEG cluster table

ThomasZloch — Thu, 28 Oct 2010 09:18:33 GMT

BUKRS and BELNR are the first two fields of the primary key and should allow quick access to BSEG if filled with single values.

How does your where-condition really look like, if it is using IN ranges, tell us how these are filled during runtime.

Always include GJAHR as well to avoid unwanted results from different fiscal years.

Thomas

Re: Performance Issue with BSEG cluster table

RaymondGiuseppi — Thu, 28 Oct 2010 09:22:04 GMT

Classical question, look for FI so called [accounting secondary index tables|http://www.sdn.sap.com/irj/scn/advancedsearch?query=fisecondaryindexes]. I suggest BSIM (or BSIS and BSAS cleared or not items) which have your selection fields.

Check for missing fields.

- You can join BSIM (or BSIS and then BSAS) with BKPF if required.

- For field only present in BSEG you can then use A SELECT FOR ALL ENTRIES using the full primary key.

-> Wiki [How SAP addressed the performance issues with cluster table BSEG?|http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=180356001]

Question :aren't you able to pass some (pertinent) criteria for GJAHR to get full primary key of BKPF and RFBLG cluster table.

Regards,

Raymond

Re: Performance Issue with BSEG cluster table

Former Member — Thu, 28 Oct 2010 13:03:22 GMT

See [Quickly Retrieving FI document Data from BSEG|/people/rob.burbank/blog/2007/11/12/quickly-retrieving-fi-document-data-from-bseg]

Rob