Skip to Content
avatar image
Former Member

SQVI_ERROR IN JOINING KONV_KNUMV & VBRK_KNUMV

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 03, 2010 at 01:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Jun 03, 2010 at 01:27 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 03, 2010 at 08:03 PM

    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

    Add comment
    10|10000 characters needed characters exceeded