on 08-24-2009 12:31 PM
Hi,
I have created a sample entry type MX_TEST, which has an attribute MX_TEST_PERSONREFERENCE that links the entry type to an MX_PERSON object. When I enter an MX_TEST object, I can browser through all the person objects and select one.
However, I would like to limit the amount of person objects being displayed by defining a SQL statement in the attribute definition of MX_TEST_PERSONREFERENCE. Does anybody have a sample SQL statement that would return some MX_PERSON references? I have not found any information what that SQL statement needs to return and returng only the MSKEY doesn't seem to work.
In a next step I would like the SQL statement to be dependent on the current user. Is there a way to make the SQL statement user dependent e.g. by using a %MSKEY% variable in the SQL statement?
Thanks for you help in advance!
Best regards
Holger
Holger,
Is this limit in SQL in general or in the NW IDM Interface?
You can use the built in value %ADMINMSKEY% which holds the MSKEY of the logged in user.
The following links might help as well:
http://help.sap.com/saphelp_nwidmic71/en/using_functions/internal_functions/dse_ugetapprovers.htm
/people/community.user/blog/2008/08/18/dynamic-resolution-of-approver-and-approvee-in-workflows
Cheers,
Matt
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Matt,
thanks a lot, that was a very useful link and answered the second part of my question.
So I'm still looking for a sample SQL statement for a custom attribute, that shows how I can retrieve entry references?
To give an example: my MX_TEST entry type might have a cost location associated. When assigning a MX_PERSON object to MX_TEST, I want the dialog box to show only persons that have the same cost location as the MX_TEST object.
Best regards
Holger
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.