cancel
Showing results for 
Search instead for 
Did you mean: 

ESS and MSS role assigned to position

Former Member
0 Kudos

Hi,

I have to find out that wheter the ESS Role is assigned to a position .I have to display (Y/N) (Details 'Y' if ESS Role Assigned, 'N' if no ESS role is assigned) To have a 'Y' it must be an active role

Is MSS Role assigned to a position .I have to display (Y/N) (Details 'Y' if MSS Role Assigned, 'N' if no MSS role is assigned) To have a 'Y' it must be an active role.

Kindly let me know how to do it.I am a abap developer and new to HR module.

Thanks !

Sachin Sharma

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks for the reply.

Please let me know how to find that role is active or not and not delimited.?Because i have to display only active roles.

0 Kudos

As you're only interested in positions / roles, just query against table HRP1001 for active positions (OTYPE = 'S', ENDDA >= current date, PLVAR = '01') which have roles assigned to (RSIGN = 'B', RELAT = '007', SCLAS = 'AG'). Loop through this for each position to see if ESS / MSS roles exist and set flag accordingly (SOBID = ess_role / mss_role) .

former_member206403
Active Contributor
0 Kudos

hi

you can check the user id assigned to the position ,

the correct procedure would be to use Logical database and HR function modules to retrive the poistion code and user id

position code can be taken from infotype 1 and user id can be taken from infotype 105 , once u get the user id , then you can check the roles that are there , in your case it might be custom roles , you can hard code the role name for that matter to query the same.

Hope this gives you a clear idea.

Regards

sameer