topic Re: select data from cluster table in Application Development and Automation Discussions

select data from cluster table

Former Member — Fri, 02 Jun 2006 10:10:02 GMT

Hi all,

Is there any method joining the BSEG, BKPF and KNA1 tables?

I want to select some customer who has an accounting doc in BKPF.

Thanks.

Re: select data from cluster table

Former Member — Fri, 02 Jun 2006 10:12:48 GMT

YOu cannot join Cluster tables, You have to select them indivudally and loop through the internal table or use the FOR ALL ENTRIES clause for the subsequent tables.

There is no other go.

Regards,

Ravi

Note :Please mark the helpful answers

Re: select data from cluster table

Former Member — Fri, 02 Jun 2006 10:15:03 GMT

ya by using kunnr(Customer Number 1) from kna1.

u find the information abt customer...

and for account doc number..

by using this kunnr u can get BELNR(Accounting Document Number) from BSEG..

<b>join b/w bseg and bkpf is not possible</b>...

Re: select data from cluster table

Former Member — Fri, 02 Jun 2006 10:19:36 GMT

Thanks Ravi,

But "For All Entries" is used with internal tables. How to use with the 3 tables?

Any Examples?

Re: select data from cluster table

dani_mn — Fri, 02 Jun 2006 10:22:43 GMT

select your values form the kna1 and bkpf into to internal table and then use for all-entries with bseg.

Regards,

Wasim Ahmed

Re: select data from cluster table

andreas_mann3 — Fri, 02 Jun 2006 10:25:06 GMT

hi,

there're extra tables to improve the performance for fi-documents - for customer: bsid, bsad

and there are existing views in standard - one is VF_DEBI

regards Andreas

Re: select data from cluster table

Former Member — Fri, 02 Jun 2006 10:25:16 GMT

Is there any method joining the BSEG, BKPF and KNA1 tables?

You can INNER JOIN KNA1 and BKPF first with your conditions and select it to an internal table.

Use FOR ALL ENTRIES for BSEG selection with the above internal table.

Cheers,

Thomas.

Please mark points if useful.

Re: select data from cluster table

abdul_hakim — Fri, 02 Jun 2006 10:25:28 GMT

hi macy,

you cannot use join for cluster tables.

you can fetch data from cluster table and then based on the result you could use FOR ALL ENTRIES addition for doing other validation from the other tables.There is no other go..

Cheers,

Abdul Hakim

Mark all useful answers

Re: select data from cluster table

Former Member — Fri, 02 Jun 2006 10:59:02 GMT

Hi Macy,

which Information do you need from BSEG, BKPF, KNA1.

Sometimes you can Use BSID or BSAD. They are faster to

select than BSEG.

Regards, Dieter

Re: select data from cluster table

Former Member — Fri, 02 Jun 2006 11:02:48 GMT

If you want to select the account document of a customer it should be better to use the secondary index table for customer accounting BSID (open item) and BSAD (cleared item) instead of use BSEG table.

Max