Qualificationsof Employees.

[#1]

Hi

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

Regards,

Venkat.

[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