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

Hi friends Ineed your help !

Hi I have created one report where for one sales order no I can have more than one line item values.

Now Under the

Partner type I am getting only one value e.g BP/SH.

I am supposed to get other values also i.e more than one values of the partner types e.g BP,SH,SP.

I am selecting fields from tpar-parvw.

How will I get others ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Jan 28, 2008 at 11:50 AM

    Hi,

    use VBPA table for ur requirement...

    select vbeln parvw from vbpa into itab where

    vbeln = <give sales ordernumber>.

    now u will get all the values.

    Regards,

    Nagaraj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 12:00 PM

    Hi,

    actually u need to change the table you r using

    you should select parvw from VBPA i'm sure u will get all the partners .

    plz reward if helpful

    keep rockin

    vivek

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 12:11 PM

    Hi,

    Are you looking for PARTNER functions at line item level ? If so, go to line item data from VBPA table and get the value of PARVW and KUNNR.

    Else explain a little about your requirement.

    Regards,

    Mayank

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 12:18 PM

    hmmm,

    i dont know how you found out table TPAR, but for SD partners it´s not the right table.

    the correct table would be VBPA.

    Read it with vbeln, and parvw, for headpartners,

    and read it with vbeln, posnr and parvw for position partners.

    since you want to obtain all partners, just read it with vbeln, or vbeln & posnr.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 12:28 PM

    Hi,

    U r selecting partner type from tpar table.

    Check your condition put on the select query of tpar table ...

    eg...

    select * from tpar into i_tpar where <condition>

    bcoz of this where condition partner type may be having only one or two values...

    thnks....

    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.