2 Replies Latest reply: Mar 20, 2009 7:43 PM by Tia Garrison RSS

JOINING KNA1 TO VBRK

Tia Garrison
Currently Being Moderated

Hi everyone,

 

I am SAP ECC 6.0 and I am trying to create a query with KNA1 and VBRK and VBPA . I join the tables together and proceed to test, when I click execute  immediately I receive a message "no data selected". I am trying to get invoiced sales by State, City and Ship-to . What could I be doing wrong?

  • Re: JOINING KNA1 TO VBRK
    Claudia Neudeck
    Currently Being Moderated

    Dear Tia,

     

    I think this not a IS-Media specific problem.

     

    Please ask your question in the relevant problem therefore.

     

    Thanks for your cooperation and regards

    Claudia

    • Re: JOINING KNA1 TO VBRK
      Tia Garrison
      Currently Being Moderated

      I am trying to use Quickviewer to create a report... total sales dollars for ship to addresses in a city,  I select the fields I need then generate the report, input the information into selection screen and click execute and immediately it returns "NO DATA SELECTED". The funny thing is before we upgraded to ECC 6.10, I did not have this problem. I know to join the tables, so that's not it. It seems as if the two tables do not work together what so ever.

       

      The tables are KNA1 and VBRK and VBPA..

       

      Edited by: Tia Garrison on Mar 20, 2009 7:43 PM

Actions