topic Re: Data from Cluster Tables in Application Development and Automation Discussions

Data from Cluster Tables

Former Member — Fri, 28 Jul 2006 01:57:19 GMT

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

Re: Data from Cluster Tables

former_member186741 — Fri, 28 Jul 2006 02:06:00 GMT

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.

Re: Data from Cluster Tables

Former Member — Fri, 28 Jul 2006 10:14:39 GMT

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,

Re: Data from Cluster Tables

andreas_mann3 — Fri, 28 Jul 2006 11:17:35 GMT

hi,

look logical database BRF and where use list of that ldb

Andreas

Re: Data from Cluster Tables

Former Member — Fri, 28 Jul 2006 11:24:26 GMT

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

select ... from bseg

for all entries in ht_bkpf where ....

Regards

Inder