Skip to Content
avatar image
Former Member

Issue while writing a Query

Hi All,

I am writing a Query using SQVI. I required Sold to party , Sold to description, Partner function, End Customer , End customer description, Sales Qty and Netvalue.

I am using table Joins

I have used the tables VBRK,VBRP,VBPA and KNA1

But the report displays only for sold to customer description. I am not able to get it display for End customer description..

Kindly help how to join the tables to get it populated description of End customer..

Thanks in advance..

Regards,

SK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 14, 2010 at 10:39 AM

    Hi Mastan Shaik,

    You can include the partner table. you should add KNVP table to your query infoset .

    I think it will meet your requirement about this issue.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Casba,

      Thank you so much for your inputs and explanation. I got the address of VBPA-KUNNR also. Thanks once again.

      Regards,

      SK

      Edited by: Mastan Shaik on Sep 15, 2010 10:00 AM

  • avatar image
    Former Member
    Sep 14, 2010 at 10:41 AM

    hello, friend.

    remove table VBRP and try again. this should work.

    if you really need the partner per item, you might need to delete table VBRK and use VBRP. however, not all partner functions may be available at item level.

    the partners available at header are PY, BP and SP. at item level, they are SH and possibly whatever partner you may define (e.g. salesman, end customer, etc.).

    regards.

    Add comment
    10|10000 characters needed characters exceeded