topic Re: sap query in Application Development and Automation Discussions

sap query

Former Member — Tue, 15 Jan 2008 05:03:49 GMT

hi all

i want to display some fields to existing SAP query table joins. I am not able to see some fields in ‘Basic List’ like EKET-J_3ANETP but it exist in table. How to include this fields into ‘basic list’. Kindly help me

points will be rewarded

thanks in advance

anniyan

Re: sap query

Former Member — Tue, 15 Jan 2008 05:11:49 GMT

hi,

you have to modify the infoset behind the query. In the start screen of SQ01 you get the name of the infoset, which you can modify in SQ02 (excpet if it is standard)

hope this helps

thanks

swaroop

Re: sap query

Former Member — Tue, 15 Jan 2008 05:18:20 GMT

hi swaroop,

how to change the infoset means where actually i have to change

thanks

Re: sap query

Former Member — Tue, 15 Jan 2008 05:29:25 GMT

Hi,

Goto SQ02 and enter the infoset name.Click on change and then include the fields which you want in the field groups which have been craeted.

Thanks,

Sandeep.

Re: sap query

Former Member — Tue, 15 Jan 2008 05:36:33 GMT

what u have to do is go to change mode

check weather the field is present in the field groups present on the right side

if it is not present go to the data fields on the right side and check for your field name right click on it an add to the field group

save the chages

i think your problem will be solved

thanks

swaroop

Re: sap query

Former Member — Tue, 15 Jan 2008 05:37:54 GMT

In order to generate the query report, first construct the logical database and generation of query report is as follows.

The transaction codes used in Query reports are:

1. SQ01 – For creating Query.

2. SQ02 – For creating Infoset.

3. SQ03 – For creating User.

First u need to create the USER and generate the INFOSET, in turn can produce the Query report.

Infoset:

An SAP Infoset (formerly known as a Functional Area) is crucial for ABAP query usage (in SAP versions 4.6A - onward).

The reason for Info Sets being important is because many R/3 clients find themselves faced with how to develop useful reports from an application using 20k+ tables. In addition, many clients desire to use third-party reporting tools; i.e., Crystal Reports. In this article, we will look at what an R/3 Infoset and how they relate to Crystal Reports.

1. Knowledge learned in this article can be put to use when:

2. Users require an understanding of how InfoSets are used within SAP R/3

3. Users require an understanding of the various methods of developing

InfoSets

4. Users require an understanding of how InfoSets are used in concert with

Crystal Reports.

Report developers cannot be expected to cull through the thousands of tables and fields R/3 presents - even from a single logical database. Therefore, some form of technical shortcut is beneficial. InfoSets, when used with ABAP queries are an example of an available shortcut. At its simplest definition, an InfoSet determines which tables and/or fields within a table, queries may reference. To accomplish this, InfoSets are typically based upon table joins or logical databases (LDBs). Therefore, an Infoset is, for lack of a better term, a form of Ubber View (Super View).

Go to Transaction Code SQ01.

Now follow this path

Environment --> Usergroups

Give your Query name and Click on create button

Save or press Enter

Go back to User Group initial screen and then click on Assign users and InfoSets

Click on Assign users & InfoSets

Assign any user name and press enter

Now go back to your user screen from there follow this menu path

Environment --> InfoSets

Or go to Tcode SQ02

Give your InfoSet query name and press Create button

Give your InfoSet name

Select a logical data base by pressing F4

You can drag & drop your fields on to the screen save it and come back to main screen

Now in SQ03 assign your Infoset which u had created just above

Select your infoset query and then save it

Now to create Query goto USER screen and click on the

ENVIRONMENT --> QUERIES

and the Query name and click on the CREATE button. It will ask for infoset. Choose the corresponding Infoset.

Regards

Nanda