getting partner number and name of a partner function in sales order
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 ?
Sandip Kamdar replied
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.