SAP QUERY

[Former Member]

Hi Experts:

My question is ....What are the steps for configuring an SAP Query?

Thanks

Veeru

[Former Member]

ANSWERED

[Former Member]

solved

[Former Member]

solved

[Former Member]

Hi

first go to Sq02

On the left hand side there is a field by the name of infoset.

Give any appropriate name. Then click on create button.

then a screen will appear , write the name. In data source field click on Logical Database . Here you have to select PNPCE, PAP, PNP according to your requirement.

If you want to create Query on anything related to applicant select PAP. If ur query is based on Master data select PNPCE.

After selecting click on tick mark (green in colour) which is given below. A screen with different folders of infotypes will appear. Select the required infotypes which you want accoridng to your requirement. Then click on tick mark again.

Then click on generate button (red & white in colour) (3rd button from the left). A screen will appear with the name

create object directory entry. Here you have to click on local object button.. you will now see that the system haas generated a Message saying "Infoset------- generated.

In sq02 there is a button with the name Role/User Group Assignment . Assign the user group out here.

Then go to SQ01, click on infoset query. Select ur user group. You can see the name of the query which you have created.

Regards

Harshvardhan

[Former Member]

please check this link

http://saptechnical.com/Tutorials/SAPQuery/Part2/Page1.htm

Best Regards

[Former Member]

Viru,

check these links

http://help.sap.com/saphelp_47x200/helpdata/en/b7/26ddebb1f311d295f40000e82de14a/frameset.htm

http://help.sap.com/saphelp_47x200/helpdata/en/24/fc9638f5f0283de10000009b38f8cf/frameset.htm

http://help.sap.com/saphelp_47x200/helpdata/en/9c/6b7538c9a8ee45e10000009b38f8cf/frameset.htm

Thanks

Bala Duvvuri

[Former Member]

I have created a query and have limited authorisation to few user, by checking the relevant users access to the users. The users were still unable to access the query.The error that the user gets while accessing sq01 is that he gets no authorisation.

So now have given the authorisation for the transaction sq01 and the user is able to access sq01 and also modify the prepared query.

how do we restrict the access of query only to display for the user?

Edited by: Sarvodya Team on Oct 10, 2008 4:12 PM

[Former Member]

Hi Veeru,

Firstly, create the user group from SQ03. There you're gonna determine who will be able to see the queries you're gonna develop.

Then goto SQ02, create infoset. It refers to the super set of tables (&fields) or infotypes (&fields) you are gonna use in the queries. The second case is when you use logical database (in personnel administration we use PNP LDB). Don't forget to assign infoset to the user group.

The last step is the creation of query in SQ01. There you need to first select the infoset to use.

Hope it helps,

Best regards,

Dilek