Skip to Content
0
Former Member
May 12, 2009 at 10:45 AM

pooled tables, cluster tables and projection views , join is not allowed'

1834 Views

Hi,

I have to get DMBTR value from BSEG table and BELNR value from BKPF table,

So i applied join for these two table but I am getting one error message

" for pooled tables, cluster tables and projection views , join is not allowed' BSEG' "

why i am not able to join these two table(BSEG & BKPF) even though I am having common field BELNR

How to resolve this issue. Please help me

my code is :-

select a~BELNR

b~DMBTR

from BKPF as a join BSEG as b on aBELNR = bBELNR

APPENDING CORRESPONDING FIELDS OF TABLE itab.