Skip to main content

YCLASSICAL_JOINING

*&---------------------------------------------------------------------* *& Report  YCLASSICAL_JOINING *& *&---------------------------------------------------------------------* *& *& *&---------------------------------------------------------------------* REPORT   yclassical_joining  NO   STANDARD   PAGE  HEADING                               LINE - SIZE   110                               LINE - COUNT   255                               MESSAGE - ID  z...

How to Create SAP ABAP Query Using SQ01 Step by Step Guide

How to Create SAP ABAP Query Using SQ01 Step by Step.

You can create ABAP query objects ,if they are not exist in the SAP system. You can create SAP query without  ABAP programming knowledge. ABAP Query provides users with a variety of ways to define and create different types of reports, such as Basic ListsStats, and Sorted Lists.

ABAP query consists of four elements:

Queries
InfoSets
Groups
Translation query


Queries

The query component is used by end users for Queries. You can create queries, change and queries executed. Transaction SQ01.

Trnslation component / QUERY

Many texts to define queries, InfoSets and user groups are generated. These texts are displayed in the language we choose to access the SAP system. We can compare the text or languages ​​that use this component.

InfoSets

InfoSets are the views of the Special Data Sources. An InfoSet Describes the fields of a data source that can be reported in the query. An InfoSet can be assigned different roles or user groups.

By creating and scrolling to groups InfoSet or user, the system administrator determines whether responding services vary from applications or end users can generate from SAP Query.
End users can only work with info sets that fall into their specific domain, by the user group or role assigned to them.

Groups

The user group component is used to contain user groups .

Users who work on the Seme implementation are assigned to the Same user group. It does not matter who really determined a query in a user group. Each user assigned to the user group can perform the query.

Users of a user group must have the necessary privileges before modifying or redefining a query. Each user of a system can be assigned to different groups of users.

Processing the queries data

The data can be processed and presented in three ways: -

Statistics - Calculated Numbers displays statistics of master data.
Ranked Listed - A secret list is a specialization of statistics. 
General List - displayed in the order defined by the functional area (sum of and carriers).


A query can-a base list, up to nine statistics, and up to nine sorted lists.


Steps for Creating SAP Query

Go to SAP Easy Access Screen and Enter SQ01 transaction Code to Create Query.

 Give a name to the query and click on the Create button.
Select the Field Groups which you want to use
 Select the Field Groups which you want to use
Select the Fields to be displayed.
Choose one of the output types ( basic, statistics, ranked ).

You can find below output.

Now SAVE and execute the Query.


Comments

Popular posts from this blog

ALV Field Catalog in SAP ABAP

ALV Field Catalog in SAP ABAP Field Catalog Field catalog is an internal table which is used to pass a list of fields to display in ALV report, we can set different properties to fields that will be display in ALV output. Type Group It is a data dictionary object which contains all the reusable user-defined types. Example for a type group is SLIS, which contains all the user-defined types for developing ALV reports. TYPE-POOLS is a keyword which is used to assign the type-group to a ALV report . Syntax : TYPE-POOLS SLIS . DATA : <IT_FCAT> TYPE SLIS_T_FIELDCAT_ALV . "INTERNAL TABLE FOR FIELD CATALOG DATA : <WA_FCAT> TYPE SLIS_FIELDCAT_ALV . " WORK AREA FOR FIELD CATLOG Field catalog types Field catalog: Field catalog is a format description of the display area. There are three procedures to build a FIELD CATALOG. 1. Automatic field catalog. 2. Semi-automatic field catalog. 3. Manual field catalog. Automatic field catalog. If the list structure has ...

What is BAPI in SAP ABAP with Example

What is BAPI in SAP ABAP with Example What is BAPI? The Business Application Programming Interface (BAPI) is a standardized programming interface (method) that allows external applications to access enterprise processes and R / 3 system data. BAPIs are defined in the Business Object repository (BOR) as SAP Business Object-type methods that perform certain business functions. They are implemented as RFC-compatible functional modules and are created in the ABAP Workbench function generator. Some BAPIs and methods provide basic functionality and can be used in most SAP business objects. These are called BAPI NORMALIZED. BAPIs for Mass Processing -ChangeMultiple(), CreateMultiple(), DeleteMultiple(). BAPIs for Reading Data - GetList() , GetDetail() , GetStatus() , ExistenceCheck(). BAPIs for Creating or Changing Data- Create() ,Change(),Delete() and Undelete() . They provide stable and standardized methods for perfect integration between the R / 3 system and external appli...

All about Classes in ABAP Object Oriented Programming?

All about Classes in ABAP Object Oriented Programming? Class describes real world Object that may be car ,home and Animal .In ABAP Object Oriented (OO)Programming ,Class concept is first and Fore most Topic ,so through this post ,we will learn class in ABAP and Types of class and How to create classes and Methods in SAP ABAP. Class consists the Properties and Attributes. Properties are Methods or Functions or Procedures. Attributes are Variables . One class can have Any number of Objects that is Object is like a class but object can never be a Class. Example :Car is a class ,Here class contains some common Properties for its related Objects. Object may be different companies like Ford Maruthi etc. Objects are instances of a class ,so for one class ,we can create many objects Class Definition in SAP ABAP Class: we can build an Object properties using class. The attributes of objects are defined by the components of the class, which describe the state and behavior of O...