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 Lists, Stats, 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

BADI in SAP ABAP Step by Step

BADI in SAP ABAP Step by Step BAdI Acronym of Business Add Ins As a customer outsider, it helps BAdI to improve SAP functionality. Why is BADI? Unlike previous improvement methods, BADI continues the approach aimed at re-use objectives. BADI can be used in a number of times that these standard evaluation techniques can only be used once. For example, if you are upgrading a custom project, you can not map the extension on other custom projects. In order to overcome this disadvantage, SAP provided a new evaluation technique called BADI. Code of transaction for BADI definition: SE18 When you create a BAdI definition, you create a class interface automatically and you can define the methods in the interface. The application of the methods can be made in SE19 transactions. When created BAD, they are generated automatically: An interface with 'IF_EX_' is inserted between the first and second characters of the BAdi name Class classified as 'CL_EX_' inserted betwee...

BDC Recording in SAP ABAP

BDC Recording in SAP ABAP Here ,I explained The Steps to record any  Transaction (Example: VA01) to create BDC(Batch Data Communication) Program. Step 1  Execute transaction  SHDB  . Step 2  Enter  name  for recording  Step 3  Enter  transaction  to be executed Step 4  The transaction will now be executed, simply enter the values in the screen fields which you want to record.  Step 5  Once you have finished the recording and selected the  save  button or exit the transaction you  Creating an ABAP program Using a BDC recording   Go to SHDB Transaction Code and Click on New Recording. Give the Record name and Transaction code and click on Start New Recording Button. Now enter the Bank country and Key Now enter the Bank name ,City ,country and street.  Now Save the Recording . Now select the created record and click on Program. Now give the program title ...

ABAP Programming Types

ABAP Programming Types In SAP,each ABAP Program has the Type ,based on the Program Type ,we can understand what is that kind of program.There are 8 programming Types . When a program is created, the suitable statement is automatically generated by the ABAP Workbench and should be changed during editing in the additions only. In particular, the keywords FUNCTION-POOL, CLASS-POOL, INTERFACE-POOL, and TYPE-POOL should be created solely by the respective tools of the ABAP Workb ench and never be entered in the source text themselves in order to avoid unexpected system behavior. REPORT Report Type Program is Executable. Module Pool Module Type is a Executable PROGRAM FUNCTION-POOL The introductory statement FUNCTION-POOL declares a program in which you can define function modules. Class Pool The introductory program statements CLASS-POOL and INTERFACE-POOL are provided solely for class and interface definitions. Subroutine Pool This Statement used for creating subrout...