Linking SD tables in SAPquery

[Former Member]

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

[Former Member]

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

[Former Member]

I don't have a system in front of me, so I may have some field names wrong.

I thought you could get the condition header from VBRK (field KNUMV?) and link to KONP-KNUMH. The item has to be linked as well... VBRP-POSNR -> KONP-KOPOS.

[Former Member]

Hi Bernard,

Please check this link perhaps it may help to link above tables.

http://www.sapgenie.com/abap/tables_sd.htm

Regards,

Ferry Lianto

Please reward points if helpful.