abap-sql-amdp

Write modern ABAP SQL and AMDP procedures for ABAP Cloud and standard ABAP.

49|15|Updated Jan 16, 2026

Search Tags:#database #sql #cds #window-functions #abap #sqlscript #amdp

Ready to run

npx skills add https://github.com/likweitan/abap-skills --skill abap-sql-amdp

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: abap-sql-amdp
Source: https://github.com/likweitan/abap-skills/tree/main/skills/abap-sql-amdp
Command: npx skills add https://github.com/likweitan/abap-skills --skill abap-sql-amdp

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Helps ABAP developers write modern SQL statements and manage database logic with ABAP Managed Database Procedures (AMDP) across ABAP Cloud and standard ABAP, enabling advanced features and better performance.

Core Features & Use Cases

Modern ABAP SQL syntax support: inline declarations, window functions, GROUP BY, HAVING, CTEs, and privileged access.
AMDP development guidance: define AMDP classes and procedures, including AMDP table functions and CDS table function usage.
CDS and data access optimization: implement CDS table functions via AMDP for efficient server-side processing.
Practical usage: appropriate for ABAP Cloud vs standard ABAP contexts, with patterns for mass data processing and complex queries.

Quick Start

Create a basic AMDP procedure by following the class/method skeleton shown in this skill to return a sample dataset.

Frequently Asked Questions about abap-sql-amdp

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I write ABAP SQL queries with window functions and CTEs?▼

To write modern ABAP SQL with window functions and CTEs, apply inline declarations and clauses like GROUP BY and HAVING. This enables complex data aggregation directly within your ABAP Cloud or standard ABAP environment.

What is an AMDP table function and when should I use it?▼

An AMDP table function is an ABAP Managed Database Procedure used for database-side processing. Use it to implement CDS table functions, enabling efficient server-side mass data handling for complex queries.

Can I use AMDP procedures in ABAP Cloud environments?▼

Yes, AMDP procedures work in ABAP Cloud environments. The Skill provides guidance on defining AMDP classes and procedures appropriately for both ABAP Cloud and standard ABAP contexts.

What's the best way to implement server-side data processing in ABAP?▼

The best way to implement server-side data processing in ABAP is using AMDP procedures and SQLScript. This pushes complex logic, aggregates, and window functions to the database layer for better performance.

How does CDS SESSION CLIENT DEPENDENT work with ABAP SQL?▼

CDS SESSION CLIENT DEPENDENT manages client-specific data access within ABAP SQL queries. It is applied alongside features like PRIVILEGED ACCESS to handle complex data views securely and efficiently.