Skip to main content

YCLASSICAL_JOINING

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

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

Image
By

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

Post a Comment

Popular posts from this blog

ABAP Code Inspector Tool

By
ABAP Code Inspector Tool The Code Inspector is a tool for checking static ABAP coding and DDIC objects . It helps developers to adhere to programming standards and guidelines by creating messages on less-than-optimal coding. The Code Inspector offers various possibilities to define object sets and to combine multiple single checks in so-called "check variants". Single object checks from the Development Workbench You can check a single object with the Code Inspector from the ABAP Editor (transaction SE38), the Function Builder (transaction SE37), the Class Builder (transaction SE24), or the ABAP Data Dictionary (transaction SE11). To do this, choose <object> > Check > Code Inspector from the menu, where <object> can be a program, function module, class, or table. Checks on transport objects from the Transport Organizer You can invoke the Code Inspector from within the Transport Organizer (transaction SE09) to check objects in a transport reques...
Post a Comment
More

What is SAP HANA?

By
What is SAP HANA? The main features of SAP HANA are given below: SAP HANA is a combination of software and hardware innovation to process huge amount of real time data. Based on multi core architecture in distributed system environment. Based on row and column type of data-storage in database. Advantages of SAP HANA Used extensively in Memory Computing Engine to process and analyze massive amount of real time data. It reduces cost of ownership, increases application performance, enables new applications to run on real time environment that were not possible before. It is written in C , supports and runs on only one Operating System Suse Linux Enterprise Server 11 SP1/2. Today, most successful companies respond quickly to market changes and new opportunities. A key to this is the effective and efficient use of data and information by analyst and managers. HANA overcomes the limitations mentioned below: Due to increase in "Data Volume", it is a challenge f...
Post a Comment
More

SAP had released a two versions for BPC 10.1; they are BPC 10.1 Classic and BPC 10.1 Embedded

By
SAP had released a two versions for BPC 10.1; they are BPC 10.1 Classic and BPC 10.1 Embedded. The Classic version can be considered an extension of previous versions in the BPC family, and can be used to implement both planning and consolidations solutions. The Embedded version utilizes Integrated Planning and BPC features, and is designed for planning only. Integrated Planning (IP) is a planning tool introduced by SAP before BPC came into effect. Let’s look some of the differences between the Classic and Embedded versions from a configuration perspective: 1. Master and transactional data objects Classic Embedded This version utilizes BPC objects i.e., Dimensions for master data and Models for transactional data. When data is saved in BPC, it will be stored in the SAP BW system under the namespace /CPMB. This method is similar to that used in earlier versions of BPC. This version uses the SAP Business Warehouse (BW) system and its objects directly. Characteri...
Post a Comment
More