topic Re: Table Konv in Application Development and Automation Discussions

Table Konv

Former Member — Tue, 13 Nov 2007 18:36:24 GMT

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?

Re: Table Konv

Former Member — Tue, 13 Nov 2007 18:38:52 GMT

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

Thanks

Seshu

Re: Table Konv

Former Member — Tue, 13 Nov 2007 18:41:30 GMT

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

Re: Table Konv

Former Member — Tue, 13 Nov 2007 18:52:08 GMT

What exactly is the problem you want to solve?

Rob

Re: Table Konv

Former Member — Wed, 14 Nov 2007 10:07:37 GMT

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

Re: Table Konv

former_member386202 — Wed, 14 Nov 2007 10:09:12 GMT

Hi,

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

Regards,

Prashant

Re: Table Konv

Former Member — Wed, 14 Nov 2007 10:43:59 GMT

Hi Julio,

KONV is Cluster table

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

Select KONV~KNUMV

KONV~KPOSN

KONV~KSCHL

KONV~KWERT

From KONV

Where KONV~KNUMV in (

Select VBRK~KNUMV

From VBRK Inner Join VBRP

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..

Reward points if useful

Thanks & Regards

ilesh 24x7

Re: Table Konv

Former Member — Wed, 14 Nov 2007 14:36:31 GMT

So, what code do you have so far?

Rob

Re: Table Konv

Former Member — Wed, 14 Nov 2007 14:39:29 GMT

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