Hi friends Ineed your help !

[Former Member]

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 ?

[former_member404244]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

Thanks to all

[Former Member]

Hi,

If the above mentioned posts have helped you, provide suitable reward points and close the thread.

Regards,

Mayank

[Former Member]

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....