on 09-15-2015 2:58 PM
Hello Experts,
I need help in order to ensure that sales employees have access to only Business Partners that contain their SlpCode. What I would like is the following:
User Opens Sales Order form
User clicks into CardCode textbox and hits tab
SAP displays only BP's for whom the assigned sales employee is the user logged in (instead of displayting list of all BP's)
Is there a way to permanently 'hardcode' a filter on the list of BP's to show only the current user's Business Partners?
Hi,
Run below query and assign it to sales order customer code field. If your sales employee code equal to BP sales employee code, then this query will retrieve BP code and BP name.
SELECT T0.[CardCode], T0.[CardName] FROM OCRD T0 WHERE T0.[SlpCode] = $[ORDR.slpcode]
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dennis
Try the below way
1. In BP Selection screen Click Form Settings
2. In List of Settings - Select Sales Employee Code in First Row.
3. Click OK then reopen again now Sales Employee will come first
With Regards
Balaji Sampath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
11 | |
11 | |
6 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.