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.
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 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
Hope this helps.