SQVI_ERROR IN JOINING KONV_KNUMV & VBRK_KNUMV

[Former Member]

Dear Export,

we have tray to make report through SQVI query with table KONV_KNUMV & VBRK_KNUMV

at the time joining the table, system give the error message "Table KONV cannot be used in a join",

also we have tray to use table JKONV instead of KONV but no data available in that table(JKONV)

Please suggest alternate solution.

Thanks

BK GAIKWAD

[jason_barton]

Try with logical database VFV. Use this as your starting point, and then analyze gaps (if any) and try to address with help of seasoned ABAPer.

Thanks,

Jason

[Former Member]

It's not an elegant suggestion, but it may work.

Extract your VBRK data and export into a spreadsheet.

Use the KNUMV plus the condition type to extract from KONV into another tab in the spreadsheet.

Use VLOOKUP to join the data and present the data that you actually want to see.

[Lakshmipathi]

Have you tried vice versa. That means, first consider table VBRK from where you link the field KNUMV to KONV table but I am not sure, whether in table join, KONV will work.

If not, you have to create a query where also, first consider VBRK table.

thanks

G. Lakshmipathi

[Former Member]

Dear Experts,

i have tray the same, means use VBRK table use first, & then tray to insert KONV table, but same message appeared.

Please tell me any other solution

BK GAIKWAD