on 05-27-2008 3:33 PM
Hello!
Is it possible to create a report who gives a list of user according to the attribute filled on the selection screen?
Thanks for the help.
Hi. Yes. Most attributes are stored in table HRT1222. This is then linked to position or org unit in table HRP1222.
The main exception to HRT1222 are plants and storage locations. They are held in tables HRP5502 and HRT5502 and are linked to position and org unit the same as above.
HRP1001 then holds all the relationships from org unit to position, and position to user.
However, given the complexity of all the inheritance, I think you would be best off to select all users in and use function BBP_READ_ATTRIBUTES to read the attributes, then limit the list accordingly.
Regards,
Dave.
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.