Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Performance Issue with BSEG cluster table

Former Member

‎2010 Oct 28 10:13 AM

0 Likes
721

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

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

Reply
3 REPLIES 3
Read only

ThomasZloch
Active Contributor

‎2010 Oct 28 10:18 AM

0 Likes
612

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

Read only

RaymondGiuseppi
Active Contributor

‎2010 Oct 28 10:22 AM

0 Likes
612

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

Read only

Former Member

‎2010 Oct 28 2:03 PM

0 Likes
612

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

Rob