*&---------------------------------------------------------------------* *& Report YCLASSICAL_JOINING *& *&---------------------------------------------------------------------* *& *& *&---------------------------------------------------------------------* REPORT yclassical_joining NO STANDARD PAGE HEADING LINE - SIZE 110 LINE - COUNT 255 MESSAGE - ID zsan. ** T Y P E D E C L A R A T I O N ** TYPES : BEGIN OF ty_mara, matnr TYPE matnr, ernam TYPE ernam, pstat TYPE pstat_d, END OF ty_mara, BEGIN OF ty_makt, matnr TYPE matnr, spras TYPE spras, maktx TYPE maktx, END OF ty_makt, BEGIN OF ty_final, matnr TYPE matnr, ernam TYPE ernam, pstat TYPE pstat_d, maktx TY
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.
You can find below output.
Now SAVE and execute the Query.
Choose one of the output types ( basic, statistics, ranked ).
Now SAVE and execute the Query.
Comments
Post a Comment