04-02-2007 8:03 AM
Hi,
can any let me know the field for SALES PERSON, and in which table it will be available.
04-02-2007 10:12 AM
Hi,
First find the Partner Function(PARVW) for the SALES PERSON in VBPA or KNVP tables.
Every partner is assigned with a partner function.(sold to 'SP',Ship to "SH' or 'WE') so for a sales Document enter the doc no in VBPA table and PARVW = that partner function for Sales Person, you will get the Sales person number (KUNNR) from VBPA, pass that KUNNR to KNA1 table and fetch the name and address of him.
reward if useful
regards,
Anji