Qualificationsof Employees.

[Former Member]

Hi

I can get a Report which shows the Qualifications(Degrees) of all the Employees.Can I get the solution.

Regards,

Venkat.

[Former Member]

In addition, you can always use the "qualifications overview" report (transaction s_ph9_46000016)

Regs

Rodrigo

[Former Member]

Hi Venkat,

Adding to the valuable information posted by Michael, let me say the following: if in your organisation you are using infotype 0024 in an integrated fashion -meaning that qualifications are Q objects assigned to employees- then you will not be able to pull out the qualifications using logic database PNP, since they are technically not saved in PA infotypes, but the assignment is rather done by creating relationship A/B032 between objects Q and P. In order to be able to retrieve this data you will have to choose logical database PCH (for PD data) for your query and read the aforementioned relationship between your employees ("P" objects that will be part of your selection set) and the Q objects, in a certain period of time.

Regards,

Rodrigo

[Former Member]

Hi Venkat,

I’ve tried to use Adhoc query and SAP Query for same kind of request in our company, but were not successful to satisfy the needs of business units. Then created one excellent custom report and every one is happy now. I can share the ABAP code with you. I think if you can just upload the program in you QAS system and show the client, they may like it.

Please confirm if you need the ABAP code

Thanks

[Former Member]

Hi

But, my client insists on only Adhoc qurey. They don't want a zee report. can u guide me if possible lastly, can u pass me the code and guide me how could i insert the code as i have no clue about abap and plz, do help me.

Regards,

Venkat.

[kvenkatesh-in]

Hi Venky,

You can pull the qualification details using SAP quick viewer (Tcode SQVI) and using logical database PNP

-> Go to Tcode SQVI

-> give Query name and Create

-> In the data source field, select Logical database

-> In logical database give PNP or PNPCE

-> Then in basis mode u can find IT 0024 in Planning data header

-> and then select the list fields u need and the additional selection cretaria also

-> Then excute the query.

With smile,

Venkatesh kumar

[McF]

Hello Venkat,

if you want to use Ad Hoc Query (or InfoSet Query as it is called outside HR) you have to first define an InfoSet.

Use Transaction SQ02 to create one that contains the desired infotypes (like 0000, 0001, 0024,...)

Then you should assign this InfoSet to a user group. The user group can be created with transaction SQ03.

Last but not least the users must be assigned to this user group also possible in SQ03.

Now you can run an Ad Hoc Query. E.g. start transaction SQ01 choose the right Usergroup and press the button InfoSet Query.

If there should be a link in the Easy access menu you can use one of the reports with a variant:

SAP_QUERY_AD_HOC

SAP_QUERY_AD_HOC_ROLE

SAP_QUERY_DEVELOPMENT

SAP_QUERY_DEVELOPMENT_ROLE

More Information you can find using transaction SQ01 and then the application help.

I would not use the Quick Viewer because then you miss the special HR function of the object selection.

Best regards,

Michael

[suresh_datti]

Hi Venkat,

Why do you need a report?You can query it off Infotype 0022 (Education).

Regards,

Suresh Datti

[Former Member]

Hi Suresh.

There is no data maintained in the I.T-0022 but, the qualifications are maintained in the I.T-24. So, my requirement is that I need all the active employees with there Qualifications in an adhoc query.I need a Report format and the client is not accepting me to do a z-report. I have no clue how to create an adhoc query can u plz, help me with this situation. How should I create an adhoc Query.

Regards,

Venkat.