Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to join cluster table with transparent table?

Former Member
0 Kudos

Friends ,

i just wanna know as 2 how can we combine bseg and bkpf tables.

since bkpf is a transparent table and bseg is a cluster table.

regards

Essam

essamsaud@yahoo.co.in

3 REPLIES 3

Former Member
0 Kudos

Hi,

CLUSTER TABLE is a table which has one TABLE in the DATABASE mapped to several tables declared in the Data Dictionary.

That is Severl DDIC tables data will be stored in One database table.

That is the reason why you <b>cannot JOIN a cluster table</b> as the underlying databse table has data from othertables also.

Cluster table is to group some of the related tables and to store the data in archive format.

For a normal transperent table there is one Databse table. so you can JOIN with a normal transperent table

Regards

Former Member
0 Kudos

Hi Khan,

We cant perform joins on cluster tables, so first get the data from cluster table(BSEG) into internal table and use SELECT..with FOR ALL ENTRIES option on transparent table(BKPF).

SELECT * FROM BSEG

INTO IT_BSEG

WHERE <CONDITION>.

IF IT_BSEG[] IS NOT INITIAL.

SELECT <F1> <F2> FROM BKPF

INTO IT_FINAL

FOR ALL ENTRIES IN IT_BSEG

WHERE <CONDITON>.

ENDIF.

Thanks,

Vinay

Former Member
0 Kudos

Hi,

You can try it like this,

select * from BKFF into table it_bkpf.

if not it_bkpf[] is initial.

select * from bseg into...

for all enties in it_bkpf

where belnr = it_bkpf-belnr.

endif,

Reward if useful!