cancel
Showing results for 
Search instead for 
Did you mean: 

KONV Table Question!

Former Member
0 Kudos

Hello Experts -

I'm trying to create an SAP query and need to use some fields from the KONV table.

I need to join this with VBAK, VBAP and VBPA.

But when I'm creating the InfoSet for the query, its saying I can't join KONV table because its a clustered table.

What other tables should I look into?

I need the following fields:

- KWERT

- KINAK

- KMPRS

- KSCHL

Thanks in advance for all your help!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Thats drawback of SAP query, it doesnt allow cluster table and there is no other table from wich u can get all pricing relevant field and thats constraint or restiction in SAP query otrherwise everyone will go for SAP query rather then ABAP/BW for reports and pls note that in production with more number of data's, ur SAP query will take hell lot of time to fetch u result...i mean perfirmance will not be good ...so pls go for custamized report through ABAP....

Regards

Jagdish

Former Member
0 Kudos

Thanks for your input.

Former Member
0 Kudos

HI everyone,

why did you not consider the Logical Database VAV - containing all the sales data including KONV? It can be used for "normal" queries and as well for SQVI.

br

Astrid

Answers (0)