getting partner number and name of a partner function in sales order

[Former Member]

there's a sales order created and i want to display the partner # and the name of the partner function 'Sold-to party' . has someone done or have any idea, in which tables r these values stored ?

Thanks..

[Former Member]

CHECK TABLE vbpa-PARVW(Partner function)

[former_member188685]

Hi,

check the table VBPA , and you need to provide PRAtenr function(PARVW) to get the partner data.

Regards

vijay

[former_member188685]

Hi,

for sold-to party <b>parvw</b> is 'AG'.

check in VBPA table

Regards

vijay

[vinod_gunaware2]

<b>SD_PARTNER_READ</b>

regards

vinod

[Former Member]

VBPA is the table and partner type (PARVW) is 'AG' for Sold-To-Party.

Take KUNNR from VBPA by comparing VBELN = VBAK-VBELN (Sales Order Number).

Then Go to KNA1 and take NAME1 by comparing KUNNR = VBPA-KUNNR. This will give you Sold-To-Name.

Keep one thing in mind.. if you try to run through SE16, you have to pass 'SP' as PARVW in VBPA and while displaying it will display 'AG' for SOld-To-Party.

Thanks

Sandip

[Former Member]

Hi,

The name and the partner function will be available in KNVP Table.

Regards,

VM

[Former Member]

Hi,

Partner details for a given sales order you can get from VBPA table.here PARVW is the partner function field will have values like AG(Ship to party) etc..

if you want description of these partner types, you have to go to the table TPAR & give this PARVW value & you will get its description in VTEXT field.

regards

srikanth