ABAP Query

[Former Member]

Hi,

Is it necessary for functional consultants to know about abap query.

Could anyone explain me the process for the same.

I also heard that we can join two or three tables to get a single report.

Could anyone explain the above procedure also.

Thanks

MMVD

[Former Member · Accepted solution]

Hi MM VD,

Its through SQ03, SQ02, SQ01 we create the query.

Many of our friends had given you in detail how it works and how to generate reports with it.

While generating the reports using two tables, when once we go for the selection, we had the option of selecting two tables.

When once we select that, the system asks /prompts you to enter the table name with which you want to join.

Reply if you want any information.

Award points if it adds information.

Thanks

Mohan

[Former Member]

Hi Buddies,

Thanks for the immediate replies.

I had awarded to all for sharing your time and knowledge.

Mohan, could you please be a bit elaborate on joining of tables.

Thanks

MM VD

[Manoj_Mahajan78]

Hi..

Visit

Regds

MM

[Former Member]

Hi MM VD

ABAP/4 Query is a powerful tool to generate simple reports without any coding. ABAP/4 Query can generate the following 3 simple reports: Basic List: It is the simple reports. Statistics: Reports with statistical functions like Average, Percentages. Ranked Lists: For analytical reports. - For creating a ABAP/4 Query, programmer has to create user group and a functional group. Functional group can be created using with or without logical database table. Finally, assign user group to functional group. Finally, create a query on the functional group generated.

Use transactions codes SQ02 and SQ03 & SQ01 to create ABAP Query

First create Infoset via T-code : SQ02.

Goto SQ03 and assign user group that infoset.

After creating the infoset got ot SQ01 and select the infoset and create a Query.

Reward if useful to u

[Former Member]

Hi

Its required now a days for Up gardition or enhancement or support projects

ABAP query it is a tool to access the sap database table.

it is used to provide the list to the system users

it is used for testing while in implementation.

he purpose of the SAP Query are for users with no programming knowledge. It is also used by abapers to create simple reports for the users.

You can easily create three types of query reports :

1. Basic lists (details list)

2. Statistics (counting etc.)

3. Ranked lists

When you start using version 4.6x, you can see a Quick Viewer button in the Query Main screen. It is suppose to be much simplier that the original Query but it is up to you to decide whether is it true.

To create a report with the QuickViewer, all you need to to do is enter texts such as titles, and select the fields and options that define the structure of the report. You can assign a specific sequence to the fields by numbering them.

If necessary, you can edit the lists either through drag and drop in WYSIWYG mode, or by using the functions in the available tool bars. Data can also be send to external programs such as MS Excel or MS Word for further processing.

The only problem with QuickViewer is that it cannot read cluster table.

<a href="http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Create_The_Query.asp">SAP ABAP Queries</a><a href="http://www.sap-basis-abap.com/sapquery.htm">ABAP/4 Query</a>

Message was edited by:

SHESAGIRI.G

[Former Member]

Refer below Links :

1. First create a User Group T-Code SQ03 - Enter the relevent name in User Group field and click on Create button, Enter the Description of the User Group in Pop-Up window and save. During saving the system ask for object, save as local object, if you dont want to create a transport request.

2. Now use T-Code SQ02 to create infoset, Enter the relevent infoset name in InfoSet field and press Create button. One Pop-Up window appear, just enter the name description of the infoset in Name field, check the "Table join using basis table" and enter the table name you want to join. Example VBAK. Now another screen appear with VBAK table. If you want to join another table, click on inseart table button, enter the another table in Table field, Example VBEP. Now save and go back, you can see the both table name in left side, expand it. Now whatever field you want in your querry, just drag it and put it in the right side directory written as 01 sales document header data or 02 sales document Schedule Line data. Last you assign the Use Group to this infoset, click on Role/User Group Assignment button search for your user group you created in first step and mark it flag (tick). save and go back.

3. Again go to T-Code SQ03 and created User Group and click on Assign users and InfoSets.another screen will appear, here if you want to restrict the user, then just enter the SAP login name. If you keep it blank then querries is open for all SAP users. Save it.

4. Now enter the T-Code SQ01, select the Query or InfoSet from list you created and click on Infoset Query, another window appear, here you can see the tables and fields you selected earler. Mark the Selection field as user have to enter in selection screen and Mark the Output field user would like to see the Output on screen. Now you save and execute the Querry, enter the relevent data in selection screen and again click on execute button.