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

i used LDB for BKPF-BSEG ..any ALTERNATIVES to improve PERFORMANCE.

i basicaly draw data from BKPF and BSEG...for all GL accounts(HKONTS) In a COMPANY CODE(BUKRS) for a FISCAL YEAR(GJAHR)

I basicaly SUM up the NET VALUES(DMBTR) for a HKONT and display it across all COST CENTRES.

Since the Requirement needs GL's as COLOUMN HEADINGS and KOSTL as ROWS,

I used DYNAMIC INTERNAL TABLE concept...

However the runtime is high(as expected)..

DID I WRITE THE BEST CODE?

i used LDB for DRAWING DATA...

and rest is all basic coding for DYNAMIC ITABS..

now how can i better it?

the tables are indexed..

will using any other approach fasten the speed?????????????

also i ahve no idea how BW will come handy..

are these kind of reports supposed to be done in BW?

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jan 05, 2009 at 12:32 AM

    Hi,

    as you expected the running time of your report is high. I do not think you can improve it significantly. I would you use standard select from BKPF and BSEG (using FOR ALL ENTRIES) instead of logical DB.

    Here is also nice blog about selecting FI documents from BSEG.

    /people/rob.burbank/blog/2007/11/12/quickly-retrieving-fi-document-data-from-bseg

    Cheers

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 05, 2009 at 09:13 AM

    >

    > are these kind of reports supposed to be done in BW?

    Sounds very much so (if you have a BW already anyway). Also see if you can use table COSS.

    Thomas

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 05, 2009 at 10:47 AM

    If the starting point for your report is HKONT, I'd try using as a starting point for the selects tables BSIS or BSAS both of which hold FI lines data indexed on HKONT.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2009 at 05:22 AM

    Hello Gaurav,

    The Table BSEG is a cluster table and hence any queries on this table that does not use the Document number will cause performance problems.

    To resolve the performance problems in your report try using database tables BKPF, BSIS and BSAS instead of using the LDB for fetching the data.

    Hope this helps!

    Regards

    Vijai

    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.