There is a handy tool developed to browse the dataflow in BW system easily and effectively using BW system scout. It is offered by Bluetelligence. Below is the link to get the trial version: With his help you can easily …
type of objects created in bw4hana difference between open ods view and composite provider SD and Billing tables in ECC if customer wants to build BW report from tcode in ECC, what are the steps for design document FM based extractor …
After completing this lesson, you will be able to: Understand difference between syntax of Open SQL and Native SQL write correct Native SQL statements Native SQL in a nutshell: Loosely integrated into ABAP, but allows access to all functions contained …
The aim of this lesson is: understand ADBC (ABAP Database Connectivity) use ADBC to execute native SQL statements ADBC is an object based API. ADBC allows native SQL access providing: Flexibility where used list error handling Main classes in ADBC …
The aim of this lesson is: Describe the use of native SQL in context of sap HANA SQL is a standard language for accessing relational databases. It can be divided into three areas: Data Manipulation Language (DML) statements for reading …
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) …
The goal of this lesson is to get to know the different ways to start and stop SAP HANA. As the administrator of SAP HANA database, you need to stop the system for maintenance purposes. SAP HANA Database could be …