topic Re: SAP Query in Application Development and Automation Discussions

SAP Query

Former Member — Thu, 10 May 2007 07:35:24 GMT

Dear all,

Anyone has the user manual of how to create the SAP query? Pls advice.

Thanks,

Chris

Re: SAP Query

former_member196299 — Thu, 10 May 2007 07:40:26 GMT

hi Chris,

Please follow the link from which you can the process for creating SAP query !

http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Introduction.asp

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=how%20to%20create%20sap%20query&cat=sdn_all

Regards,

Ranjita

Re: SAP Query

Former Member — Thu, 10 May 2007 07:45:11 GMT

Hi chris

http://help.sap.com/saphelp_nw04/helpdata/en/d2/cb3efb455611d189710000e8322d00/content.htm

rewards if helpfull

regards

pavan

Re: SAP Query

Former Member — Thu, 10 May 2007 08:00:11 GMT

Hi,

check these links...

http://www.sap-basis-abap.com/sapquery.htm

http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Introduction.asp

http://help.sap.com/saphelp_nw04/helpdata/en/25/8f4dd72b0f9f4fa6712fcf2f65f505/frameset.htm

Regards

Nilesh

Re: SAP Query

Former Member — Thu, 10 May 2007 08:47:37 GMT

good

ADHOC QUERY

A query can be created to extract information from master records i.e Infotypes. For example, by creating a query , the data relating to an employee contained in various Infotypes can be extracted.

Proceedure :

Decide on the various Infotypes we want to make the query. Decide on the area where we want to query i.e Global area or Standard area. Standard area is client specific and globel area will include all clients.

Menu : HR – PM – Admn - Information System - Adhoc Query

Select area standard and select the user group already created

Creation of new query :

TC SQ03 - Select Environment – Select Standard Area - Enter -- If new user group is to be created, enter name of the user group, click on create and enter necessary information and exit after saving

TC SQ02 - Enter name of the Infoset – Create – enter name of Infoset - Data source -- > Table join by basis table – give name of table e.g pa0000 - Enter - Click on insert table if we want to include more tables – give name of table one by one and after finishing, place cursor on the joining lines and right click to delete unwanted relationships - check - and go back - field groups - include all table fields - click on generate button - go out

TC SQ03 - Select user group - eg. Payroll

Infoset - Enter name of newly created Infoset

Assign users and Infosets - Assign infosets - put tick on payroll - save and go back

TC PAAH - Expand the nodes and put tick on relevant fields depending upon necessity

Save the query by giving the same name as infoset for easyness..

thanks

mrutyun^