Query Changes. Cluster table issue KONV

Former Member — Thu, 06 May 2010 08:07:15 GMT

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

Re: Query Changes. Cluster table issue KONV

andreas_mann3 — Thu, 06 May 2010 10:09:49 GMT

can'T you use LDB like VFV?

Former Member — Fri, 07 May 2010 07:21:44 GMT

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