SAP HCM Employee Education Detail Report

[Former Member]

Hi All,

I need the folowing output.

1. Emp Number.

2. Emp Name

3. Highest Qualification(Only One){Certificate Text}

When I am doing adhoc query for one payroll area the output is multiple records like..

1. abc(empname)

Xth

XII

B.Com

MBA

I only need MBA as outfield along with emp no and empname.

Any solutions?

Regards,

Param

[Former Member · Accepted solution]

Try the TCODE: S_PH9_46000224

You can also try Flexible Report using tcode: S_AHR_61016362 , and then select the fields you would like. As far as field in Ad-Hoc query is concerned, I don't think it can work out because Standard SAP do not have a sub type - Highest Qualification.

Unless there is Highest Qualification subtype for IT 0022, I am not sure how one can abstract only Highest Qualification. In real-time, for some employee Highest Qualification will be Degree, PG, Technical Certificate etc.

May be if you can add a subtype for IT 0022, it can work out.

Thanks

Yash

[Former Member]

Param,

We are glad that you could come up with a solution. However, Anirudha has a very valid point. May be next time you would like to implement the other SAP based solutions discussed here.

Thanks

Yash

[Former Member]

Hi,

Enhance the infotype PA0022, by adding year of passing.

Then it can be sorted on year of passing , you will get the highest certiifcate the employee has.

Pls reward suitable points.

Regards,

IFF

[Former Member]

Thanks to All,

I got the answer.

I transfered the data to excel and worked on some functions in excel and got the answer.

Regards,

Param

[Former Member]

hi,Param!

I would look at the excel download and functions developed in excel as an one-time solution. If the "identification" of highest qualification is required on an ongoing basis, I suggest that you use the "Branch of Study 2" ( you would need to configure a value for the dropdown ) field in infotype 22 to store the indicator of highest qualification. If the person entering the education data identifies the highest qualification and indicates it using branch of study 2, it would be easier to extract such information at a later stage.

regards,

Anirudha