This step-by-step developer’s guide contains all you need to construct SAP HANA-optimized ABAP applications. Delve into the environment and tools at your disposal, and master the development techniques that dictate the code-to-data paradigm in SAP HANA. Then, dive into backend programming using ABAP Database Connectivity, SQLScript, ABAP-managed database procedures, core data services, and beyond. After coding your applications, ensure their maintenance with runtime statistics, traces, and code analysis. Build it your way!
- Understand How SAP HANA Changes ABAP Programming
- Access the Database with ABAP Database Connectivity, SQLScript, and ABAP-Managed Database Procedures
- Model Data Using Calculation Views and CDS Views
Start by familiarizing yourself with the architecture and features of SAP HANA, and setting up your development environments, including SAP HANA Studio and ABAP Development Tools. Grasp the code pushdown techniques essential for ABAP development on SAP HANA.
Creating Programming
Generate, execute, and oversee SAP HANA database procedures using native SQL, ABAP Database Connectivity, SQLScript, ABAP-managed database procedures, among others.
Modeling
Employ calculation views and CDS views for SAP HANA data modeling. Construct business objects with the Business Object Processing Framework (BOPF).
Optimizing Applications
Utilize runtime statistics, ABAP and SQL traces, ABAP code analysis, and system-wide analysis tools to ensure your ABAP applications run efficiently.
- SAP HANA
- ABAP Database Connectivity (ADBC)
- ABAP-Managed Database Procedures (AMDP)
- SQL and SQLScript
- Data Modeling
- Core Data Services (CDS)
- Native SQL and ABAP SQL
- Business Object Processing Framework (BOPF)
- ABAP Test Cockpit
- Runtime Statistics and Analysis
- SAP BTP, ABAP Environment
SAP HANA Overview
Features
- Main Memory and CPU Innovations
- Storage Innovations
- Data Compression
- Data Partitioning
Platform Capabilities
Use Cases
- Side-by-Side Scenario
- Fully Integrated Scenarios
- New Applications
What Is the Code-to-Data Paradigm?
Bottom-Up Approach
- Using Native SQL
- Using Proxy Objects
- Using Transparent Optimization
- Using ABAP SQL
- Using ABAP-Managed Database Procedures
- Using Core Data Services
Development Environments
Evolution of Programming Languages and Development Tools
SAP HANA Studio
- Compatibility Checks
- Download
- Installation
- Basic Navigation and Actions
- ABAP Perspective
- Modeler Perspective
- Administration
ABAP Development Tools
- Installation
- SAP Business Technology Platform, ABAP Environment
- Executing Native SQL Statements
- Literals and Host Variables
- Statement for Cursor Processing
- Database Procedure Calls
- Statements for Establishing Database Connections
- Data Type Compatibility
- Querying the Database
- DDL and DML Operations
- Secondary Connections
- Precautions While Using ABAP Database Connectivity
What Is SQLScript?
- SQL versus SQLScript
- Types of SQLScript Statements
- Prerequisites
Creating a Schema
Creating Tables
Stored Procedures
- Creating Procedures
- Deleting Procedures
- Joins and GROUP BY Clauses
- Subqueries
- Local Scalar Variables
- Local Table Variables
- Conditional Statements
- FOR Loops and WHILE Loops
- Operators
- Emptiness Check for Tables and Table Variables
- Getting the Number of Records for Tables and Table Variables
- Example Cursor
- Looping over Cursors
Dynamic SQL
Exception Handling
Arrays
- Creating an Array
- Accessing the Array
- Concatenating Arrays
- Converting a Table into an Array
- Unpacking an Array into a Table
- Deleting or Trimming an Array
- Cardinality in Arrays
Explicit Parallel Execution
System Variables
Debugging SQLScript
ABAP-Managed Database Procedures
Introduction
- ABAP-Managed Database Procedure Framework
- Development Environment for AMDP
- Prerequisites
- Implementing AMDP Methods
- Calling AMDP Methods in Applications
- Using Multiple Selection Criteria
- Feature Support Check Using Global Classes
- AMDP BAdI Overview
- AMDP BAdI Implementation
- AMDP BAdI Definition
- AMDP Calls
Debugging
- AMDP Debugging before SAP NetWeaver AS ABAP
- AMDP Debugging with SAP NetWeaver AS ABAP 7.5
- AMDP Dump Analysis Using Transaction ST22
- AMDP Dependencies for ABAP and SAP HANA
- AMDP Precondition Checks
- AMDP Consistency Check for AMDP Table Functions
- Delete Obsolete AMDPS
What Is Modeling for SAP HANA?
- Measures and Attributes
- Dimensions
- Fact Tables
- Star Schemas
- Hierarchies
- Semantics
- Joins
- Features
- View Types
- Creating Dimension Calculation Views
- Creating Calculated Attributes
- Time Dimension-Based Calculated Views
- Base Tables Aliases
- Hidden Columns
- Labels and Hidden Attributes
- Using Measures in Calculation Views
- Using a Hierarchy
- Restricted Columns
- Calculated Columns
- Filtering Data
- Using Variables and Input Parameters
- Currency Conversion
- Decision Tables
- Query a Modeled Hierarchy Using SQLScript
- Creating and Using Functions in Information Views
- Procedures in Calculation Views
- SAP HANA Live
- SAP S/4HANA Embedded Analytics and Core Data Services Views
- Tools to Check Model Performance
- Good Modeling Practices
Introduction
- Domain-Specific Languages
- Availability and Features
- Integration with ABAP
- Using Templates
- Structure Definition
- Creating CDS Views in ADT
- Syntax and Naming Guidelines
- Numeric Built-In Functions
- String Functions
- COALESCE Function
- Conversion Functions
- Date and Time Functions
- Scope of Annotations
- Types of Annotations
- Defining Associations
- Cardinality
- Types of Associations
- Using ABAP SQL
- Using SAP List Viewer with Integrated Data Access
- CDS View Extensions
- Limiting CDS View Extensibility
- Finding CDS Extensions to Enhance CDS Views
- Data Control Language Overview
- Data Control Language Syntax and Access Conditions
- Data Control Language Source Definition
- Data Control Language Source Annotations
- AMDP Functions
- Introduction to CDS Table Functions
- Defining CDS Table Functions
What Is Open SQL?
Features of Open SQL
ABAP SQL
- Code Pushdown in ABAP SQL
- Joins
- Major Syntax Changes in the SELECT Query
- Arithmetic Operations and String Operations
- Joins and Unions
- CDS Views
- ABAP-Managed Database Procedures
Introduction to Business Object Processing Framework
Elements of BOPF
- Nodes
- Attributes
- Alternate Keys
- Actions
- Determinations
- Associations
- Validations
- Queries
- BOPF Interface Objects
- Business Object Key
- BOPF Constants Interface
- Creating Business Object Instances
- Searching for Business Object Instances
- Updating and Deleting Business Object Instances
- Consistency Checks
- Triggering Actions
- Action Validations
- Transaction Management
- Enhancement Workbench
- Enhancing the Business Object Data Model
Runtime Statistics Records
Runtime and Statistical Analysis
- Transaction SAT
- ABAP Profiling Perspective
- SQL Performance Trace
- Single Transaction Analysis (Transaction ST12)
- Explain Plan
- SAP HANA Plan Visualizer
- SAP Global Check Variants
- Using the ABAP Test Cockpit
- ABAP Test Cockpit Administration
- Database Administrator Cockpit
- SQL Monitor
- Guided Performance Analysis
- SQL Performance Tuning Worklist
- Recommended Static Checks
Introduction to Application Development in the Cloud with SAP
ABAP Environment in the Cloud
- Architecture
- Creating an ABAP Trial Instance
- Connecting SAP HANA Studio to SAP BTP, Cloud Foundry Environment
- ABAP Restrictions in the Cloud
- Migrating ABAP Applications to the Cloud
- Creating ABAP Packages in the Cloud
- Creating ABAP Database Tables in the Cloud
- Creating ABAP Classes in the Cloud
- Creating ABAP CDS Views in the Cloud
| Author's Background
and Qualifications
Mohsin Ahmed is a senior technical consultant at CapGemini, boasting over 10 years of experience in the SAP domain. He possesses expertise in ABAP development, SAP HANA, OData, and holds a degree in computer science engineering from Jawaharlal Nehru Technological University in Hyderabad, India. Additionally, he has contributed to SAPYard. Sumit Naik is an ABAP and SAP HANA certified consultant with an impressive track record of over 15 years in technical consulting and management. He has implemented SAP ERP solutions across diverse industries such as retail, life science, energy and utilities, public sector, manufacturing, and IT. His extensive experience encompasses various implementation methodologies, approaches, and accelerators prevalent in the market. |
 |
