Skip to Content
author's profile photo Former Member
Former Member

Bill-to Party and KNVP

Hi Friends,

I want to display Bill-To party of a sales order that is displayed under Partners tab of VA03. The same Bill-To party I found in KNVP table - KUNN2 field. I am selecting KUNN2 field based on KUNNR, VKORG in sales order and PARVW = 'RE'. But for few sales orders, the KUNN2 field in KNVP and the Bill-To party appearing in Sales order (VA03) are different. Please let me know why there are different values at two places.

Thanks and Regards,

Netrey

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Sep 11, 2007 at 08:10 AM

    try using table vbpa..use parvw = 'RE'..

    SELECT posnr from vbpa into zposnr WHERE vbeln = zvbeln.

    select kunnr from vbpa into zkunnr where parvw = 'RE' and vbeln = zvbeln and posnr = zposnr.

    endselect.

    endselect.

    plz reward points if dis helps

    Message was edited by:

    abapuser

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2007 at 08:10 AM

    Hi,

    Take the info from VBPA table instead of KNVP.Its a sales doc partner function table.The partner can be changes at the document level. From the transactional data, VBPA table gets updated.

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2007 at 08:08 AM

    Netrey look in VBPA for your answers

    Partners are stored per sales order and per line item in VBPA

    for header parnters ponsr is '000000'.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.