SAP addresses performance issues with cluster table BSEG

Many times we have seen many threads related to performance issues on BSEG table. It takes quite a lot of time when fetching data directly from BSEG if we do not have proper key fields. Here is the solution for this.

performance

Since it is not possible to create the secondary INDEX for cluster tables, SAP came up with new concept called INDEX tables.

Continue Reading…

Complete Reference to ABAP Basics

The following ebook is for the ABAP beginners giving an overview of basic topics in ABAP.

This reference guide focuses on following topics:

  • ENTERPRISE RESOURCE PLANNING (ERP)
  • SAP ADVANTAGES
  • Role of ABAPer
  • R/3 ARCHITECTURE COMPONENTS
  • WHAT IS CLIENT IN SAP
  • Developemt Obects -  REPOSITORY OBJECTS and  DATA DICTIONARY OBJECTS
  • ABAP GUI
  • DATA DICTIONARY
  • INTERNAL TABLES
  • SUBROUTINES
  • Reports
  • MODULE POOL PROGRAMMING
  • Menu Painter
  • BATCH DATA COMMUNICATION
  • LSMW ( Legacy System Migration Workbench)
  • SAPSCRIPTS
  • SMARTFORMS

  Continue Reading…

Unlocking SAP Query

There are instances where SAP Query is protected by a user/creator. The following steps will help you unlock the locked Query.

 

 

Continue Reading…

SAP Statistical Query

Many times a need arises for SAP Users and Functional Consultants to generate quick reports without getting any ABAP coding done – time taken to complete the coding in development, transport and test it in QA system and then transport to production – is sometimes too long. In such cases, ABAP/4 query is a tool provided by SAP for generating these kind of reports.

SAP query provides the following type of reports:

  • Basic List        Simple report  
  • Statistics          Report containing statistical functions like Average &Percentage  
  • Ranked List     Report written for analytical purpose

Continue Reading…

Restricting SAP Queries from execution

You can restrict users from executing your queries, by assigning  Authorization Group to Query Infoset. Now,  users having the authorization to the Authorization Group can execute the Query.

Continue Reading…

Page 1 of 212