Limiting BP list visible to salespeople
Just wondering if anyone has come up with a good way of limiting the BPs that a salesperson has access to.
A salesperson's login is linked to the Employee master data (OHEM) and this is linked to the salesperson code (OSLP) which is assigned to each customer and lead in the OCRD table.
The idea is that one salesperson can only see the BPs that have their own salesperson code assigned - not anybody elses.
I think a formatted search on all the BP Code fields of the sales marketing documents and BP Master data form would do the trick but I'm not a SQL guru and I would need to put in exceptions for the sales manager and non-sales admin people (to see all customers and leads).
Anyone got a good sql script that they wouldn't mind sharing?