The aim of this assignment is: to analyze ABAP program with SQL trace (ST05) and to detect repeated SELECTs to decrease the database runtime by buffering data in internal tables to check how much improvement in ABAP trace (SAT) Task …
After completing this exercise, you would be able to: Analyze program with code inspector (SCI) to detect performance issues. Decrease the database read time by using joins instead of nested SELECT statements measure the improvement in program with ABAP trace …
After completing this exercise, you will be able to:• Analyze a program with ABAP Trace (SAT) to locate performance leaks• Decrease the runtime for database selects by using field lists instead of SELECT *• Quantify the improvement with ABAP Trace …
Business Scenario: The functions of classic Runtime Analysis (SE30) and new ABAP trace (SAT) can be completely used in HANA context. The new ABAP trace replaces the classical runtime analysis. Both tools measure runtime of processing blocks (methods, functions, subroutines) …
Type pools (or type group) *Define* type-pool hktst. TYPES: BEGIN of hktst_typ1, col1(10) TYPE c, col2 TYPE i, END OF hktst_typ1. TYPES hktst_typ2 TYPE p DECIMALS 2. CONSTANTS hktst_eleven TYPE i VALUE 11. *Use Type pool definition* TYPE-POOLS hktst. …
Determining the Attributes of Internal Tables To find the attributes of internal table at runtime that are not available statically, use the statement DESCRIBE DESCRIBE TABLE <itab> [LINES<L>] [OCCURS <n>] [KIND <k>]. If you use the LINES parameter, the number …
Scenario: The source data is coming in the form of ytd numbers. Below is an example of year to date (YTD) numbers: The user wants to see the monthly values instead of the YTD values, below is the data which …
Scenario: There is a requirement to load data with a filter on a certain infoObject. This filter is a parent node of a hierarchy. The data in the source is having rows with leaf nodes only for this infoObject. See …
In this post, I will detail on how to write an ABAP program which checks for a specific file in the application server and triggers a process chain. If no file is found, it just displays a message and does …
In some scenarios, it may happen that business has loaded multiple files in a period for sales for example. All these files should be merged into one consolidation file and loaded once to target instead of loading each file separately. …