Data from Cluster Tables

[Former Member]

Hi,

I am fetching data from BSEG table , by using for all entries . But it is taking long time. Is there any other to do it for tables like BSEG ( Cluster tables ). Please help me .

Regards,

Prasad

[former_member186741]

depending on what type of data you want you may be able to use one of the associated tables instead. eg, BSID is open customer items, bsad is cleared customer items. This means every bseg entry for 'customers' has an entry in either bsad or bsad depending on whether or not it's cleared. There are other similar tables too, bsik,bsak..check them out in se11.

[Former Member]

Hi,

To avoid the following can be used,

for GL account details, use BSIS & BSAS

for Vendor accounts, use BSAK & BSIK

for Customer accounts, use BSID, BSAD,

Hope this helps,

Rgds,

[andreas_mann3]

hi,

look logical database BRF and where use list of that ldb

Andreas

[Former Member]

Hi Prasad

You could use hashed tables to

retrieve data from BSEG. That will be faster.

According to the analysis on how sap retrieves the data from a cluster table (like bseg),it's almost the same to use a

loop at ht_bkpf -> select from bseg ... endloop

or

select ... from bseg

for all entries in ht_bkpf where ....

Regards

Inder