is ther e a table or relation in which i can find who the salesperson is for a given customer?
*This post is locked for comments
is ther e a table or relation in which i can find who the salesperson is for a given customer?
*This post is locked for comments
Hi,
If you don't need the physical table, you can add the column to the default 'Customers' SmartList object.
If you are trying to find the Salesperson ID associated with the actual SOP document, look at the SLPRSNID in the SOP30200 for history docs and SOP10100 for work docs.
Be careful of the built in sales reports. Often, they are pulling the Salesperson from the customer and not from the actual document.
Kind regards,
Leslie
You can find the Salesperson ID for the particular Customer from the Customer Master Table(RM00101).
SELECT SLPRSNID,* FROM RM00101 WHERE CUSTNMBR='ENTER YOUR CUSTOMER ID'
Hope this helps!!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156