what is adhoc query?

[Former Member]

hi experts,

what is adhoc query? what are the features and what is the navigation path to see.

regards,

narmada.

[former_member214675]

Hi,

Ahoc Query is used to get information from infotables. The transaction we use are SQ01,SQ02,SQ03

SQO1 for creating ADHoc query

SQ02-> Infoset

SQ03-> Info groups

Personal data list for employees in a particular organizational unit

Addres of the Emplyoee

Birthday list, marital status list, nationality list, etc.

Attendance/Absence list for employees in a particular employee subgroup

To get basic salary of the emplyoee

Address list for employees in a particular personnel area/subarea

Regards,

Prince Elvis

[Former Member]

Hi,

As others have already described enough, would just add here that for creating query, you need to use SQ03 then SQ02 then SQ01 in sequence...

Best wishes.

[Former Member]

hi prince,

thanks for ur valuable reply...can u please tell me what should we maintain in SQ01,SQ02,SQ03...clearly

regards,

narmada.

[shafiq_rehman3]

I have an advanced blog on SQ01 SQ02 and SQ03 capabilities, here

It is a step-by-step guide. I have discussed the basics first, which you are talking about. You can ignore second half of the blog which is creating custom fields and some other advanced topis.

And yes, you need to do SQ03 first, then SQ02 and then SQ01.

[Former Member]

Hi,

Adhoc query is an easy-to-use reporting tool that uses the fields in the infosets. Infosets refer to sets of fields in HR infotypes. You can create your own infoset thru SQ02 and use in with the adhoc query tool.

Also, pls check the thread:

regards,

Dilek

Edited by: Dilek Ersoz on Sep 16, 2008 7:19 AM

[Former Member]

hi,

Ad-hoc query is a reporting tool.

SAP gives some standard reports for each module. if the existing reports donot meet your requirements, you can create your own report using ad-hoc qurey. you do not need programming knowledge to develop an adhoc qurey. you will find the adhoc qurey under reproting tools in infosystems.

the path is given below.

sap menuinformation systems-human resourcesreporting toolsadhoc qurey.

thanks

Prasanna b