Query Changes. Cluster table issue KONV

[Former Member]

Hi Abap forum,

I have query regarding the ABAP query.

There is an existing query and I want to make changes to it.

I want to add table KONV, however being a cluster table I am not able to add.

My next step.

In infoset - Extras - I added the table KONV to link it with KONP.

(Two tables have KNUMH in common)

it gives me -

SELECT SINGLE * FROM KONV

WHERE KNUMV =

AND KPOSN =

AND STUNR =

AND ZAEHK =

Here I tried to link these two tables using KNUMH, however I am unable to.

Can any one tell me how to link two tables KONP and KONV, both have common field KNUMH.

Let me clear you on my requirement seperately -

Table KONP is already in Query. I want to join table VBRK.

However this is only possible using table KONV.

KONV has both filelds of above two tables, therefore can be used to join.

KONP - KNUMH

VBRK - KNUMV

KONV - KNUMV and KNUMH

Therefore I want to join both tables using KONV.

Please help me with this query issue.

Thanks and regards,

Sheetal

[andreas_mann3]

can'T you use LDB like VFV?

A.

[Former Member]

What is LDB and VFV? pls tell me in more detail.