Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?



Former Member


Only through SDK is this actually possible. All other suggestions or alternates that you may find in the Forums are not really going to do it.


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question