Skip to Content
0
Former Member
May 06, 2010 at 08:07 AM

Query Changes. Cluster table issue KONV

52 Views

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