Steps For Using Query SQ01,
SQ02, SQ03 - Part 1
ERP SAP Modules
==> ABAP
Step 1 : Create User Group – SQ03
Follow the menu path – SAP Menu -> Tools -> ABAP Workbench
-> Utilities -> SAP Query -> User Groups
a) In the User Group : Initial Screen -
- Enter User Group Code (self named)
- Click on “Create”
b) In the User Group (Code) : Create or Change pop-up
window -
- Enter the User Group Description
- Click on “Save”
c) In the Create Object Directory Entry pop-up window
-
- Click on “Local Object” button
- The User Group Created is Saved
Step 2 : Create User Group – SQ02
Follow the menu path – SAP Menu > Tools > ABAP Workbench
> Utilities > SAP Query > Infosets
a) In the Infoset : Initial screen -
- Enter Infoset Code (self named)
- Click on “Create” button
b) In the Infoset : Title & Database Screen -
- Enter Description of Infoset in the “Name” field
- In the Data Source selection : Select appropriate Data
Source by clicking the radio button
Source the data can either be multiple tables OR single
table. There are 4 options for the user to select from
- Click on “Continue” (Enter)
- Selected Table gets displayed in the Infoset : Initial
Screen
c) In the Infoset : Initial Screen -
- Click on “Insert Table” button
d) In the Add Table Screen -
- Enter the Table Name that is to be inserted
- Click “Continue” (Enter)
e) In the Infoset: Initial Screen -
- Click on “Back” button
f) In the Field Group Defaults pop-up Screen -
- Select Appropriate Field Group Option by clicking on
the radio button
There are 3 options to select from. User can select Empty
Field Group option and then select the data fields in the steps explained
further. Alternatively, User can select an option which clubs all
the data fields from all the tables selected.
- Click “Continue” (Enter)
g) In the Change Infoset Screen -
The left side lists the Tables that the user has selected
in step b, c & d
- In the right side, system creates field groups, one
for each table listed in the left part. Initially, the Field Groups are
empty.
- In the Left Side, Click on the arror next to the table
name and expand and display all the data fields in the table.
- Select a Data Field from the expanded Table view, which
is to be added to the Field Group on the right.
- Select a Field Group on the right side, in which Data
Field selected above has to be added.
- Right click on the Data Field selected and click on
“Add Field to Field Group”.
- The selected Data Field gets added to the selected
Field Group, which is indicated by an arrow next to the Field Group.
- Carry out the steps above to add the required Data
Fields to the respective Field Groups
- After transferring Data Fields to Field Groups click
on “Generate” button
h) In the Create Object Directory Entry Screen -
- Click on “Logical Object” button to generate the infoset
i) In the Change Infoset Screen -
- Click on the “Back” button
j) User is taken back to the “Infoset: Initial Screen”
which displays the created Infoset record.
Step 3 : Assigning User Group to Infoset – SQ03
Follow the menu path – SAP Menu -> Tools -> ABAP Workbench
-> Utilities -> SAP Query -> User Groups
a) In the User Groups : Initial screen -
- Enter the User Group for which Infoset is to be assigned
- Click on “Assign Users & Infosets” button
b) In the User Group: Assign Users Screen -
- Click on “Assign Infosets” button
c) In the next screen, select the Infoset, which needs
to be attached to the User Group selected
d) Click on the “Back” button
ABAP Query Part 2
Steps
For Using Query SQ01, SQ02, SQ03 - Part 2
Get help for your ABAP problems
Do you have
a ABAP Question?
ABAP Books
ABAP
Certification, BAPI, Java, Web Programming, Smart Forms, Sapscripts Reference
Books
More ABAP Tips
Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies. The site www.erpgreat.com is in no way affiliated with
SAP AG.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.
|