BSEG BKPF join

[Former Member]

I need to join two tables BKPF and BSEG and get some fields .. but my issue is that BSEG is a cluster table and it doesnt allow me to join.

Please give me a way out.

thanks in advance

arshad

[Former Member]

I need to join two tables BKPF and BSEG and get some fields .. but my issue is that BSEG is a cluster table and it doesnt allow me to join.

Please give me a way out.

thanks in advance

arshad

[Former Member]

Hi arshad,

1. FOR ALL ENTRIES.

2. It is recommended that

first select entries from only one table

(say, BKPF),

3. After that, using the internal table,

FOR ALL ENTRIES, and BSEG table,

select the relevant entries from BSEG table.

4. Performance wise, this will be very fast.

regards,

amit m.

[former_member186741]

you can't directly join on BSEG but depending on which data you want to access you might be able to use an alternative table. eg, BSID or BSAD for open or cleared customer items or BSIK/BSAK for open or cleared vendor items.

[Former Member]

HI

GOOD

No,it is not possile to join cluster table like BSEG

I would suggest you to do a selection from BKPF ( into table t_bkpf ) and then do the second selection on BSEG using "for all entries in t_bkpf" .

THANKS

MRUTYUN

[andreas_mann3]

hi,

use bsis/bsas, bsik/bsak, bsid/bsad

-> here're fields of bkpf and bseg for different kinds of accounts

A.