Online Tutorials & Training Materials | STechies.com
Register Login

BSEG table reading

|| || 1

BSEG table reading
Stechies

Hi all,

I am trying to Accounting documments from BSEG table and doing some
manupulation on the data it takes lot of time to get data. Is there
any other table where i can read it faster OR should i create
additional index on that table.

Any Lights are Welcome.

SJ
------------------

The access to the following tables are much faster than bseg : You may
try looking into them : BSIS, BSAS, BSID, BSAD, BSIK, BSAK and BSIM.

Alternatively, try to limit your search by accessing BKPF first
followed by BSEG. BKPF contains the posting date field which is part
of an index. Try to limit the posting date in your selection criteria

if possible.

If the above solutions do not help, please re-post your question and
be more specific on what data you are trying to extract and the
selection criteria which you have used.

By the way, I dun think you can create indexes for a cluster table
like BSEG.

Hope this helps.

Regards,

Hwee Hoon


Comments

  • 02 Mar 2010 6:43 am
    Explain me please what is BSEG and BKPF ? i am using sqvi transaction.I came across these tables. kindly explain me the functionality of these tables.