Skip to Content
author's profile photo Former Member
Former Member

bseg table issue

hi experts,

why the performance of select query involving BSEG table gets increased. I found that this is a cluster table. But i'm not able to grasp the technical reason behind this delay.

thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 10:49 AM

    Hi Gaurav,

    BSEG table is a cluster table which is combination of many tables like BSAD, BSID ( Secondary Index for Customer). BSIK and BSAK ( Secondary Index for Customer) and there are some other tables related to G/L accounts as well whose data is stored in BSEG but I do not remember the name at this time.

    Hence the data is very huge in this table and so the poor performance.

    Thanks,

    Lalit Kabra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 09:04 AM

    Hi Gaurav,

    BSEG is a big table which contains all items of financial transaction.

    To reduce the access time, or to speed up your query, you'll have to, first, select data in BKPF and then using the "for all entries" statement to retrieve data on BSEG. ( optimize using the key )

    ( Joins aren't allowed on cluster tables )

    Hope this helps,

    Erwan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Gaurav,

      No you don't have nothing to do with bkpf ! 😉

      If you want to improve your performance, you'll have to do a "<b>select</b>" on BKFP then a "<b>for all entries</b>" in BSEG.

      ( BKPF is the header table linked to BSEG )

      I guess, you can restrict you selection in BKPF on BUKRS or GJAHR or even BALRT, BLDAT, BUDAT ... this is very important.

      Then you retrieve the following fields :bukrs, belnr, gjahr which will be in input of the "for all entries" on BSEG.

      Your perf. will be much better.

      Hope this helps,

      Erwan

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 02:11 PM

    This should clear it up a bit:

    <a href="/people/rob.burbank/blog/2007/11/12/quickly-retrieving-fi-document-data-from-bseg">Quickly Retrieving FI document Data from BSEG</a>

    Rob

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.