Skip to Content
Author's profile photo K Jogeswara Rao

10 Useful Tips on Infoset Queries

Introduction

Often it is seen that. Infoset-query users, stop exploring  at the 1st hurdle and switch to ABAP report programs, for requirements a little bit beyond simple ones. But, it is the author’s experience, that we can use this tool (Infoset Query) given to Functional people by SAP,  to reach very close to the ABAP report programs, with features like those discussed in the other document and also some discussed here.

In this document the author tried to put together the pieces of his knowledge to present in the form of a document.

Tip1

To have a Tcode to your work in Infoset Query.

The following screen with report name appears..

Now you give this report name to your ABAPer and ask him to create a Tcode

OR

You do it yourself through SE93 Tcode, if you have access.

Steps for SE93

And Save. Thus your Infoset query will now be working with Tcode ZTCODE

(This applies also to Quick Viewer report SQVI)

Tip2

Calling Reports from Infoset Query reports.

The output of your query contains key fields like Notification no., Equipment No. etc.

It is natural that one wants to go to the Notification screen or the Equipment screen from the output.

Do this way.

In SQ01

We get this screen

Click here on  then on  then select

In the resulting pop-up, specify the Tcode you want to link with the Row in the SQ01 output.

Say IW23 and Save.

It is Done.

Now upon D’clicking anywhere on a particular line item in the query output, you are directed to IW23 screen of the notification of the line-item (row).

You can have many such report assignments.

Suppose you want to have IW22 also. Then repeat the same steps above to have IW22 Tcode.

Now when you D’click (anywhere) on one line-item (row) of the Query output, you will be presented a pop-up menu to select which one you want. i.e.,

Display Notification  or Change Notification. You are taken to the corresponding screen as per your choice.

Capture.JPG

Note:

1.If your Report Assignment option is found disabled, then the reason and setting to restore is here: How to make ‘report assignment’ available in ‘SQ01’

2.We always need to remember that, after Tcode assigning, the modifications done in SQ02 or SQ01 would be in effect to the Tcode, only after executing SQ01 once.

3.More Details on this subject here: Calling Reports from an Infoset Query

Tip3

Make your report colorful with giving different colors in order to group columns

In SQ01 Basic List Screen

Here just Drag & Drop the color from Right Tool-Box to the desired field in the Centre portion.

OR

Double click on a field in the Centre, to display field details and color options on the left. Now you select the color.

Example of such output.

Tip4

Always have Selection Fields from Infoset (SQ02).

What does this mean and Why?

This means

We have options for Selection Screen designing both in SQ02 and in SQ01.  It is advantageous if we declare selection options in Infoset (SQ02),

Here is how we do it. (In the Extras area), Go to Selections Tab, Click on Create icon, select Selection Criterion or Parameter like below.

Capture.JPG

And define the Selection field as under.

selcrit.JPG

Observe here the strings written in Extras field.

OBLIGATORY makes this field in the selection screen mandatory.

NO INTERVALS removes the selection range (Removes the To field of the selection criterion)

NO-EXTENSION removes the multiple selection push button

DEFAULT ‘M2’ provides the M2 value as default in the field.

Like-wise you can design a selection screen as shown below by defining fields one after another.

pastedImage_22.png

Note that, we can declare only Standard Selection Fields here. Additional Fields are to be taken into Selection Screen only from SQ01.

<img />

The disadvantage in having these standard fields into selection screen from SQ01 is, the previously used values reappear as defaults for new running of the report. We need to erase and type our values. Also there is no provision for making a field mandatory.

Tip5

This is to develop queries in Standard Area rather than in Global Area.

What is this?

See the option below in SQ02 while creating an Infoset Query.

What does this do?

With this code, the Infoset query does not bring any records where the ABC indicator field is blank.

Like-wise if you give a code like: check crhd-arbpl <> ‘xyz123’.

the output will ignore the records with maint. work center value ‘xyz123’.

(Note that these are permanent filters, For optional filters either the Selection Screen OR the Filter in the  ALV output display can be used.)

Tip7

F4 help related

F4 Help is not available in infoset query.

Tip8

How to create a radio button in SAP Query SQ01/SQ02.

Tip9

User defined fields

Tip10

We know that, the infoset reports work on Table joins in Infoset. In complex cases, where many tables are joined, the correctness of report depends upon the quality of joins we define. Though system suggests some joins, user can define more joins as per his table knowledge. This is what controls the multiplicity of identical rows appearing in the output sometimes.

It is seen that in situations where the user is unable to control the duplicate (or multiple) identical rows , the CHECK statement used in Tip6 works conditionally. In other cases this multiplicity becomes one of  the points where one is forced to go for an ABAP report.

The author has been working in this area since few years. This is an effort to share his knowledge about some very common requirements in this area with the forum. Hope member friends especially those who love Infoset queries, find this useful.

Thank you

KJogeswaraRao


PS: This post and all further posts in the area of Infosets have been compiled to this blog Infoset Queries: Collection of important posts

Assigned tags

      88 Comments
      Comments are closed.
      Author's profile photo Kalyan Chakravarthi
      Kalyan Chakravarthi

      Very useful information...Thanks.

      Author's profile photo Katigiri Linganna
      Katigiri Linganna

      Nice document.. liked it ..

      Author's profile photo Srinu S
      Srinu S

      Useful document. thanks for sharing 🙂

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Srinu, Kalyan and Katigiri

      Author's profile photo Former Member
      Former Member

      Hi Jogeswara,

      Good Day!

      Very nicely documented. I appreciate all your time, effort and support.

      Keep up the good work! Keep sharing and motivating us forever!

      Have a nice day! 🙂

      Regards,

      Hari Suseelan

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Am glad to know that my work motivates Hari. In fact I am motivated by nice comments like yours.

      Thank you very much.

      Best Wishes

      Jogeswara Rao K

      Author's profile photo SAP QM PP
      SAP QM PP

      Very useful document thanks....:-)

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you SAP QM, Glad you've found it useful.

      Author's profile photo Mayur Priyan
      Mayur Priyan

      Hi,

      First I would like to appreciate your work. I would also like to add a point regarding creating T-code to the query report, as stated.

      It is seen that the Query report name usually changes between systems i.e. Development, Quality and Production.

      Hence while creating T-code it is advisable to assign the T-code based on the User Group and Query name instead of the Query report name generated.

      Please find the procedures to do the same.

      1. Make a transaction with parameters transaction from se93 .

      2. Put START_REPORT in the transaction

      3. Check the skip intial screen checkbox

      4. in the table control in the end of screen put these values

      D_SREPOVARI-REPORTTYPE = AQ <<<----- ABAP Query

      D_SREPOVARI-REPORT = <USER GROUP in WHICH THE QUERY IS CREATED> G

      (G stands for GLOBAL AREA:)(Entered after a space)(G should come after 9

      chanracters(8 char for user group,one space and then G)

      D_SREPOVARI-EXTDREPORT = <QUERY NAME> <<<<<----

      Note: Though you have mentioned to use the query report name as in the PRD system, the method which I have stated is usually recommended.

      Regards,

      Mayur Priyan

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Mayur, This really adds value.

      Regards

      Jogeswara Rao K

      Author's profile photo Ramesh Babu Srikakollu
      Ramesh Babu Srikakollu

      Nice and informative blog on the Infoset queries

      Thanks,

      Ramesh

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Ramesh Babu !

      Regards

      Jogeswara Rao K

      Author's profile photo Shakeeluddin Khaja
      Shakeeluddin Khaja

      Useful information. Thanks Jogeshwara Rao.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Shakeeluddin !

      Author's profile photo Former Member
      Former Member

      Hi,

      useful and very nice documentation.

      Is possible insert authority check into INFOSET for example about plant?

      And if is possible where i put this check?

      Cheers

      Ivan

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Ivan,

      This should be possible by assigning infoset to User Groups (SQ03).

      Please see this

      I need to yet explore this area.

      Regards

      Jogeswara Rao K

      Author's profile photo Former Member
      Former Member

      Good Job. It was so precise.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank You Satya. May like to rate the document.

      Author's profile photo Shiva Vasireddy
      Shiva Vasireddy

      Thanks for sharing the Fine Documentation.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Siva,

      Also you may like to go through this blog if not already done.

      Author's profile photo Former Member
      Former Member

      Thank you for sharing very good documentation

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Balaji

      Author's profile photo Former Member
      Former Member

      Useful Information

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Raghu.

      Author's profile photo abilash n
      abilash n

      Nicely Done Jogeswara sir....

      Author's profile photo CH Raman
      CH Raman

      Thanks for your efforts and presentation. Very nicely written doc.

      Really useful information about info set querys.

      Thanks

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Raman,

      Glad it's useful to you.

      Jogeswara Rao K

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Really very good one.  Thanks for sharing.

      Regards,

      Krishna Chaitanya.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Chaitanya

      Regards

      Jogeswara Rao K

      Author's profile photo Former Member
      Former Member

      Very good

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice help 🙂

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Satendra and Arshiyan !

      Author's profile photo John Harrison
      John Harrison

      Very nice - good to expose some useful but not well know functions 🙂

      Author's profile photo Former Member
      Former Member

      Hi Jogeswara Rao Kavala ,

      Nice documentation it very helpful....... 🙂

      Regards

      Sada Bandla

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Sada

      Author's profile photo Former Member
      Former Member

      Hope To See some more, you must have gained more experience and knowledge since you posted this document.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Hi Anwer,

      My very Recent Documents in this area are:

      Infoset Query: Display message in Status bar

      Alias Tables in Infosets and QuikViews

      Hope you'll find these too useful to you.

      I try to post the knowledge I have in this area promptly, from time to time.

      Thanks for your appreciations thru' various Likes and Stars.


      Thank you Anwer.


      Author's profile photo Dimas Luis de Faria
      Dimas Luis de Faria

      Useful document. thanks for sharing

      Dimas Faria

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Dimas Luis de Faria !

      Author's profile photo Former Member
      Former Member

      Another Masterpiece from Mr Rao, really appreciable effort indeed 🙂

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Hi Srinivas,

      Really Documents like the present one involve efforts and their objective is fulfilled when few members learn from them and these efforts are rewarded when experts like you recognise.

      Thanks again 🙂

      Author's profile photo Former Member
      Former Member

      Excellent, most helpful and useful posting - Thanks!

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Gary! 🙂

      Author's profile photo Former Member
      Former Member

      An excellent document in itself and a valuable contribution of Mayun to help run the Tcode and Query in all Servers (Development/Quality/Production).

      Unfortunately TIP 2 works only for some transactions like Notifications/Equipment/Batch/Stock etc. But it is failing to Run MM03 and other kinds of report. Is there any way we can set the parameter id of the double clicked row?

      Sorry I am asking question here but sadly 🙁 because of this only requirement I have to change a perfect working SQL Query created report to ABAP.

      Keep it up !!!!!

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Hi Imran,

      Thank you for your excellent review.

      The issue raised by you has already been taken care of in a separate document. Please refer to the same here. Calling Reports from an Infoset Query.

      Also for the convenience of needing members, I have compiled all these infoset related posts into a single document. Please refer: Infoset Queries: Collection of important posts

      Regards

      Jogeswara Rao K

      Author's profile photo Erwin Leitner
      Erwin Leitner

      Hello,

      Jogeswara Rao Kavala

      thank you very much for sharing knowledge.

      all the best Erwin

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Hi Erwin,

      Feel encouraged and motivated to post further on receiving such reviews.

      Regards

      Jogeswara Rao K

      Author's profile photo Former Member
      Former Member

      Exatly what I'm looking for...
      Thanks very much...

      Regards

      -dd

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Glad to know this work is of use to you Deniz !

      Author's profile photo Former Member
      Former Member

      Nice Post~

      Do you have any tips to use Internal Tables in infoset?

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      That's really a difficult question for me Frank. I consider this is a limitation in query area and at such requirements, I switch to full pledged ABAP report programs. Due to scarcity of related knowledge around, this topic is still in 'yet to learn' list of mine.

      Regards

      Jogeswara Rao K

      Author's profile photo Former Member
      Former Member

      Thank you Jogeswara Rao for sharing this, its really helpful for those using infoset query and avail the different functionalities of it.

      Regards,

      Jaydip

      Author's profile photo Suhaib Bin Aziz
      Suhaib Bin Aziz

      Amazing blend of content!

      Thanks for posting this sir! 🙂

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Suhaib ! 🙂

      Author's profile photo Rupesh Dhiwar
      Rupesh Dhiwar

      Thanks its very useful information for all users to make query at own.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Glad Rupesh 🙂 you've found it useful.

      Author's profile photo rajesh bethamcharla
      rajesh bethamcharla

      Very helpful if you add how to assign TR for generated report.

      Thanks for sharing.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Hi Rajesh,

      This has already been detailed. Do you want some more info?

      Thanks for the review.

      Author's profile photo Nishan Dev S
      Nishan Dev S

      Good Work Jogeswara !

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Nishan ! 🙂

      Author's profile photo Former Member
      Former Member

      Jogeswara Rao garu,

      your work is really adorable and gratifying thanks a lot for documenting, your efforts are really appreciable.. lot many are getting educated with your stuff.  great work, keep posting.  All the best.

      Ram kumar

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Ram Kumar garu. Really appreciate  it. 🙂

      Author's profile photo Former Member
      Former Member

      Exceptionally useful quick tips for making your SAP query reports stand out.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Syed Faisal Hasan,

      That's a great review and comments. Very happy to know these tips help members.

      Best Regards

      KJogeswaraRao

      Author's profile photo Former Member
      Former Member

      Thanks for sharing .

      Best regards,

      Nitin

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      My pleasure Nitin ! 🙂

      Author's profile photo Mohammad Mousavi
      Mohammad Mousavi

      It was really helpful , thanx a lottt 😀

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      My pleasure Mohammad ! 🙂

      Author's profile photo B V Yadav
      B V Yadav

      Hi Jogeswara rao sir,

      I have created one quick viewer Report through SQVI transaction code and I have created on Tcode assigned with programe as you said in TIP:1, when I run this Tcode I am getting run time error. Please give some suggestion

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      The reasons may be very local, I doubt you haven't got the output through SQVI direct execute also.

      Author's profile photo B V Yadav
      B V Yadav

      yes, I got the output SQVI by direct execution. when i run through Tcode it showing run time error. what could be reason, how to solve it?

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      1. Check for proper copying of the program name

      2. Run the program through SE38 and see.

      3. If problem persists contact your ABAPer for debugging to locate the fault

      4. Also take help of BASIS

      Author's profile photo Former Member
      Former Member

      Indeed a very detailed and informative article. Has cleared most of the doubts and has been really helpful. Please do post more of such articles.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Saurabh 🙂

      Author's profile photo Shiva Vasireddy
      Shiva Vasireddy

      Hi,

      you always make the Blog Alive and Alert with your tremendous contributions.

      Thank you for sharing

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Siva,

      That's a great compliment.

      Regards

      KJogeswaraRao

      Author's profile photo Nicolas Giuffrida
      Nicolas Giuffrida

      Mr. Kavala,

      I found your post super interesting.

      Can you please help me out with this issue?

      I add a check box in the  Query Selection Screen as you indicated, but it appearing in a "General data selections" frame, I see that the check box recently added as not checked the Standard Selection check box, I cannot check it due it's an output only box.

      How can I take my checkbox out of the "General data selections" frame?

      /wp-content/uploads/2014/10/checkbox_555128.png

      Thanks,

      Nico.-

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      The checkbox will be in General data selections block only, because we are creating it in Infoset (SQ02). I'm afraid there is no other alternative to this.

      I could not follow these lines.

      I see that the check box recently added as not checked the Standard Selection check box, I cannot check it due it's an output only box.


      You should be able to Tick the checkbox with mouse click.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      If you want to give a default tick then create this way.

      Author's profile photo Nicolas Giuffrida
      Nicolas Giuffrida

      Sorry, let me rephrase

      How can I get this option checked so I can see Checkbox parameter out of the frame?



      /wp-content/uploads/2014/10/check_555174.png

      Do I have to set something in SQ01? Can you please help me here?

      Thank you very much.

      Nico.-

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Hello Nicolas,

      This checkboxes are ticked for the Standard Selection fields provided by the system in Infosets where Logical Databases are used. These are provided by the LDBs. I do not think we can define our own selection fields a Standard. I never tried to tick these checkboxes neither any such requirement arose. Both checkboxes next to Standard are ticked automatically when we use 'Obligatory' word in the Extras field. Standard checkbox setting is not in our control. These things we can not control from SQ01.

      KJogeswaraRao

      Author's profile photo Nicolas Giuffrida
      Nicolas Giuffrida

      Thanks for your answers, I finally managed to take the checkbox out of the frame.
      You just need to declare the checkbox parameter in the Data read. prog secction.

      I hope this help someone else.


      /wp-content/uploads/2014/10/check_556760.png

      Regards,

      Nico.-

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Nicolas,

      This adds value to this place.

      Author's profile photo Former Member
      Former Member

      Thank you for sharing the experiences

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      🙂

      Author's profile photo Former Member
      Former Member

      Thank you for good information

      Author's profile photo RAJESH KUMAR SONI
      RAJESH KUMAR SONI

      Hi Jogeshwar Rao,

      Can you guide me

      1. how to use BSIS and BSAS or BSIK and BSAK both in same query

      2. How could I link between RSEG and BKPF table were in BKPF-XBLR = BELEN + GJHAR

      you can also reply me on my mail - rajeshsoni12@gmail.com

      Regards,

      Rajesh

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Hello Rajesh,


      These are queries on specific tables which I feel, do not fit in this thread. There will be multiple advantages if you start a new thread either in ABAP space or Finance and Accounting space. (Also I do not have exposure to Accounting tables)

      Best of luck

      KJogeswaraRao

      Comments are closed.