Table Konv

[Former Member]

I need to create a query using table konv. As the konv is a cluster table, the system doesn't allow this join.

Is it possible to create view for table konv?

or which other possibilities are there to solve my problem?

[Former Member]

Better to write simple ABAP Program since KONV Table will not allow to write join.

Thanks

Seshu

[Former Member]

Hi Julio,

look at this ..

http://fuller.mit.edu/hr/cluster_tables.html

You can access cluster tables only via Open SQL,

and only without using joins.

hope it helps you..

Reward poits if useful

Thanks & Regards

ilesh 24x7

[Former Member]

What exactly is the problem you want to solve?

Rob

[Former Member]

I would like to generate a query using vbrk and konv table.

[Former Member]

So, what code do you have so far?

Rob

[Former Member]

You can not use KONV Table in Query since it is cluster table.

if you are not ABAPER then you can ask technical person create simple ABAP Program.

Thanks

Seshu

[former_member386202]

Hi,

Better to use FOR ALL ENTRIES to retriev data from KONV.

Regards,

Prashant

[Former Member]

Hi Julio,

<b>KONV is Cluster table</b>

Try out in this way.. Modify according to ur requirement....

Select KONV~KNUMV

KONV~KPOSN

KONV~KSCHL

KONV~KWERT

From <b>KONV</b>

Where KONV~KNUMV in (

Select VBRK~KNUMV

From <b>VBRK</b> Inner Join <b>VBRP</b>

On VBRK_{VBELN = VBRP}VBELN

Where VBRK_{KNUMV = KONV}KNUMV

And VBRP_{POSNR = KONV}KPOSN

)

================================

U can't perform JOIN with Pooled or Cluster tables

See another example like this...

To join A018 and KONP .... here A018 is Pooled table... Look at below threads...

Hope ur problem is solved now..

<b>Reward points if useful</b>

Thanks & Regards

ilesh 24x7