MicroLPS


A personal website

Search

Site friends

Investworkflow.com 茶马股道 
PMP exam guilde referece 
PMI  IBM SAP

Catalog categories

Functional Module [1]
MM PP FI CO HR etc
Developement Platform [4]
ABAP Java JCO .NET Connector ,Netweaver etc

Login form

Statistics


Total online: 1
Guests: 1
Users: 0

Our poll

Rate my site
Total of answers: 6
Thursday, 2024-11-14, 4:00 PM
Welcome Guest
Main | Registration | Login | RSS

Publisher

Main » Articles » SAP » Developement Platform

SAP Query


SAP Query

Step-by-step procedure in configuring SAP Query

SAP R/3 Query tools (SAP Query) are based on the following four main components:

  • Query Areas

  • Query Groups

  • InfoSets

  •  Administrative Decisions (Company-specific)

Configuration of the Query tools is done in the following manner:

  • Create Query Groups

  •  Assign Users to Query Groups

  • Create InfoSets

  •  Assign each InfoSet to a Query Group.

Create Query Groups

·        Go to Transaction SQ03.





SAP Query is a tool to generate quick reports without getting any ABAP coding done

Consists of three components:
User Groups
Functional Areas/Infosets
Query

Transaction Codes for creation of SAP Query
SQ03 : User Groups
SQ02 :Functional Area/Infoset
SQ01 :Query

Advantages of SAP Query
Designed for users having little or no knowledge of ABAP (SAP Programming Language).
No programming is required to generate the reports.
Different output options for the report like List display, ALV display, Graphical display etc. without doing any coding.
Options available to save output in Word or Excel format.
Options available to display output in different formats like Basic list, Statistics or Ranked List.

Disadvantages of SAP Query
Complex reports including complex data selection, complex conditions and formulas are not achievable by SAP Query.

User Groups : A collection of users that work with about the same data and carry out the similar tasks. The members of a user group can access any of the query made by any of the user in the group. Users are not allowed to modify queries from other user groups, although they may, under certain circumstances, copy and execute them.

Source:
Category: Developement Platform | Added by: microlps (2009-09-16)
Views: 1747 | Rating: 0.0/0 |
Total comments: 0

Only registered users can add comments.
[ Registration | Login ]