📚 ABAP SQL (Open SQL) – Top Student Notes
TERMINAL_INPUT >
Content Source: https://help.sap.com/
🔥 Core Concepts
Term Definition
ABAP SQL ABAP statements based on SQL, transformed by Database Interface
ABAP SQL Interface Transforms ABAP SQL to platform-specific SQL
Standard Connection Default connection to ABAP database schema
ABAP DB Schema The database schema of the standard AS ABAP database
⚡ Quick Overview
ABAP Program
│
▼
ABAP SQL Statement (e.g., SELECT, INSERT)
│
▼
┌────────────────────────────────────────────┐
│ ABAP SQL Interface │
│ – Client handling added automatically │
│ – CDS access control inserted │
│ – Platform-specific SQL generated │
└────────────────────────────────────────────┘
│
▼
Standard AS ABAP Database
📌 Must-Know Rules
1️⃣ Key Characteristics
Feature Description
Database Independence Works with any database platform
Automatic Client Handling Client conditions added automatically
CDS Access Control Respects CDS view access permissions
Standard Connection Always uses ABAP DB schema by default
2️⃣ ABAP SQL Components
Component Purpose
Overview Statement syntax and types
Operands Fields, expressions, subqueries
Reads SELECT statements
Writes INSERT, UPDATE, DELETE, MODIFY
Work Areas INTO/FROM clauses
Streaming/Locators Large object handling (BLOB, CLOB)
Database Hints Performance optimization
Exceptions Error handling
💡 ABAP SQL Statements
Read Operations
SELECT [fields] FROM [source] INTO [target] WHERE [condition].
Write Operations
INSERT / UPDATE / DELETE / MODIFY.
Transaction Control
COMMIT WORK ” Save changes
ROLLBACK WORK ” Undo changes
🔄 ABAP SQL vs Native SQL
Aspect ABAP SQL Native SQL
Database Portability ✅ Yes ❌ No (DB-specific)
Client Handling ✅ Automatic ❌ Manual
CDS Access Control ✅ Respected ❌ Bypassed
Syntax ABAP-native Standard SQL
TERMINAL_INPUT >
⚠️ Rule: Use ABAP SQL for database portability!
🎯 Exam Key Points
ABAP SQL is transformed by the ABAP SQL Interface before reaching the database
Standard connection always accesses ABAP database schema
Automatic insertions: client handling + CDS access control
ABAP SQL = portable, Native SQL = database-specific
COMMIT/ROLLBACK are part of ABAP SQL (LUW handling)
📝 Quick Reference
Task ABAP SQL Native SQL
Read data SELECT EXEC SQL
Insert INSERT EXEC SQL
Update UPDATE EXEC SQL
Delete DELETE EXEC SQL
Commit COMMIT WORK EXEC SQL COMMIT
⚠️ Important Notes
Obsolete Short Forms: Old ABAP SQL used implicit table work areas
Work Areas: Use explicit INTO/FROM clauses
Performance: Use database hints sparingly
Streaming: For large objects (BLOB, CLOB)
🧠 Memory Trick
TERMINAL_INPUT >
“ABAP SQL = ABAP’s SQL translator. It speaks ABAP, translates to DB SQL.”
⏭️ Related Topics
⬡ ABAP SQL – Reads (SELECT patterns)
⬡ ABAP SQL – Writes (DML operations)
⬡ ABAP SQL – Operands & Expressions
⬡ ABAP SQL – Performance Notes
If you have problem, please fell free to contact.Thanks.
About me:
This post is come from www.hot583.com, you can share/use it with the post original link for free.
But pay attention of any risk yourself.
If you like, Fell free to let your friends know this. Thanks.