Book Image

Mastering SAP ABAP

By : Paweł Grześkowiak, Wojciech Ciesielski, Wojciech Ćwik
Book Image

Mastering SAP ABAP

By: Paweł Grześkowiak, Wojciech Ciesielski, Wojciech Ćwik

Overview of this book

Advanced Business Application Programming (ABAP) is an established and complex programming language in the IT industry. This book is designed to help you use the latest ABAP techniques and apply legacy constructions using practical examples. You'll start with a quick refresher on language and database concepts, followed by agile techniques for adding custom code to a modern ABAP system. After this, you will get up to speed with the complete ABAP toolset for importing data to and from different environments. Next, you'll learn how to print forms and work with the different ABAP tools for Extensible Markup Language (XML) manipulation. While covering further chapters, you'll gain insights into building stunning UI5 interfaces, in addition to learning how to develop simple apps using the Business Object Processing Framework (BOPF). You will also pick up the technique of handling exceptions and performing testing in ABAP. In the concluding chapters, you can look forward to grasping various techniques for optimizing the performance of programs using a variety of performance analysis tools. By the end of this book, you will have the expertise you need to confidently build maintainable programs in Systems, Applications, and Products (SAP).

Related Content you might be interested in

Current Title:

Small book image
Mastering SAP ABAP
Paweł Grześkowiak | Wojciech Ciesielski | Wojciech Ćwik
May, 2019 | 548 pages
No titles found
Table of Contents (25 chapters)
Title Page
Title Page
Copyright and Credits
Copyright and Credits
Dedication
Dedication
About Packt
About Packt
Contributors
Contributors
Preface
Preface
Free Chapter
1
Creating Custom Code
Creating Custom Code
Technical requirements
Making changes
Design thinking
BDUF/LDUF
Designing for quality and use
Designing the UI
Designing services
Designing the business logic
Designing the database
Agile principles
DevOps
Continuous delivery
Summary
Questions
2
The Basic Structure of ABAP
The Basic Structure of ABAP
Technical requirements
The Data Dictionary
Databases
Data declaration
Summary
Questions 
3
Database Access in ABAP
Database Access in ABAP
Technical requirements
Starting with OpenSQL
How to see data selected from a database
More advanced possibilities in OpenSQL
Reading data from several tables
Identifying and saving the changes
The optimization of reading big datasets
The new SQL syntax
Using the SQL Trace tool for performance analysis
Summary
Questions
4
Import and Export to Document Formats
Import and Export to Document Formats
Technical requirements
Client-side file processing
Server-side file processing
Working with Microsoft Office files
Summary
Questions
Further reading
5
Exposing Data to Print Forms
Exposing Data to Print Forms
Technical requirements
Introduction to printouts in SAP
Adobe Forms
Summary
Questions
Further reading
6
ABAP and XML
ABAP and XML
Technical requirements
Using the CL_XML_DOCUMENT class for XML
Simple transformations in ABAP
sXML library for XML and JSON
Summary
Questions
Further reading
7
Building User Interfaces
Building User Interfaces
Technical requirements
Classic DynPro
ALV
Summary
Questions
8
Creating Stunning UI5 Interfaces
Creating Stunning UI5 Interfaces
Technical requirements
Development tools
Layouts and floorplans
The SAPUI5 library
Creating our first mobile app
Summary
Questions
Further reading
9
Business Object Processing Framework
Business Object Processing Framework
Technical requirements
An introduction to BOPF
First BOPF example 
Summary
Questions
Further reading
10
Modification and Customization Techniques
Modification and Customization Techniques
Technical requirements
Legacy ways of changing the standard
Enhancement framework and its components
Summary
Questions
Further reading
11
Handling Exceptions in ABAP
Handling Exceptions in ABAP
Technical requirements
Classic exception handling
Class-based exceptions
Assertions
Runtime errors
Summary
Questions
12
Testing ABAP programs
Testing ABAP programs
Technical requirements
Testing the quality of code
Testing and troubleshooting
Summary
Questions
Further reading
13
Advanced Techniques in ABAP Objects
Advanced Techniques in ABAP Objects
Technical requirements
Global versus local classes
The static method versus the instance method
Nested classes
The event concept
ABAP Objects design patterns
Summary
Questions
14
Integrating SAP with Third-Party Systems
Integrating SAP with Third-Party Systems
Technical requirements
IDoc 
BAPI
SAP Gateway
The OData protocol
Developing our first OData application
Summary
Questions
15
The Background Processing of ABAP Programs
The Background Processing of ABAP Programs
Technical requirements
Background processing in SAP
Recording batch input sessions
Summary
Questions
16
Performance and Optimization of ABAP Code
Performance and Optimization of ABAP Code
Technical requirements
Ways of measuring ABAP programs performance
ABAP runtime analysis
ABAP trace analysis
ABAP SAT transactions
Best practice techniques
Summary
Questions
Assessments
Assessments
Answers
Additional tutorials
Another Book You May Enjoy
Another Book You May Enjoy
Leave a review - let other readers know what you think
Index
Index

Reading data from several tables

We have several possibilities for reading data from several tables in SQL and merging that data in one internal table. I will present three possibilities for getting the data from several tables into one internal table. Here, we can use FOR ALL ENTRIES, SELECT...ENDSELECT, and JOIN. As the mechanism and principle of the FOR ALL ENTRIESoperation has been discussed previously, I have only shown how to get data from several tables.

We need to split a query into two SELECT statements. However, first of all, I will prepare the structure and table when we have fields from two tables—sflight and spfli:

TYPES:
BEGIN OF s_for_all_entries,
     mandt     TYPE mandt,
     carrid    TYPE s_carr_id,
     connid    TYPE s_conn_id,
     fldate    TYPE s_date,
     countryfr TYPE land1,
     cityfrom  TYPE s_from_cit,
     airpfrom  TYPE s_fromairp,
     countryto TYPE land1,
     cityto    TYPE s_to_city,
     airpto    TYPE s_toairp,
END OF s_for_all_entries.

DATA: gt_for_all_enties...
Previous Section
End of Section 6
Next Section