Skip to Content
Former Member
Jul 18, 2006 at 01:58 AM

Linking SD tables in SAPquery


Hi Everyone,

I'm in the middle of creating a SAPQuery for my users to use. However, i am having trouble in linking a particular table, as i get the following error message:

"Table KONV cannot be used in a join"

What i am trying to do is to link SD tables VAPMA, VBRP, VBRK, KNA1 with KONP. The problem now is that i am unable to link KONP with the earlier mentioned tables, so i need to include another new table KONV to provide a link between them.

From what i can find out in SE11, KONV is a cluster table, so does it mean there is no way to link them?

Is there any other way to link those 4 earlier tables i mentioned with KONP?

Thanks in advance