Home / likweitan / abap-skills · GitHub

abap-sql-amdp SKILL.md skillA

abap-sql-amdp from likweitan/abap-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned

mdr add likweitan/abap-skills/abap-sql-amdp@git:20260916.c1b7d5e

Pins git:20260916.c1b7d5e in mdr.lock. Pin the fingerprint instead.

Audit grade: A, 17 of 17 checks passed
Kind: SKILL.md skill
Repository: likweitan/abap-skills
Path: skills/abap-sql-amdp/SKILL.md
Versions recorded: 3
Latest version: git:20260916.c1b7d5e, committed Sep 16, 2026
First version recorded: Apr 17, 2026
Size: 12,551 bytes
Repository stars: 72
License: MIT

Help with modern ABAP SQL features and AMDP (ABAP Managed Database Procedures) including inline declarations, window functions, GROUP BY, HAVING, PRIVILEGED ACCESS, string functions, aggregate expressions, common table expressions (CTE), AMDP classes, AMDP procedures, AMDP table functions, CDS table functions, and AMDP scalar functions. Use when users ask about ABAP SQL, modern SQL, SELECT, window functions, CTE, common table expression, AMDP, SQLScript, AMDP table function, CDS table…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# ABAP SQL & AMDP

Guide for writing modern ABAP SQL statements and ABAP Managed Database Procedures (AMDP) in ABAP Cloud and Standard ABAP.

> **Clean core context**: `SELECT` from a released CDS view is **Level A**. Direct **read** access to an SAP database table is **Level C** (ATC priority 2); direct **write** access is **Level D** (ATC priority 1). `EXEC SQL` (native SQL) is a **critical statement → Level D**. `SYCM_USAGE_OF_APIS` reports SQL statements on SAP database tables and views. See the `abap-cloud` skill for level details.

## Workflow

1. **Determine the user's goal**:
   - Writing or optimizing ABAP SQL queries
   - Using advanced SQL features (window functions, CTEs, aggregates)
   - Creating AMDP procedures or functions
   - Implementing CDS table functions via AMDP
   - Understanding PRIVILEGED ACCESS for authorization bypass

2. **Identify the context**:
   - ABAP for Cloud Development vs. Standard ABAP (affects available syntax)
   - Performance optimization needs
   - Whether AMDP is justified (prefer ABAP SQL when possible)

3. **Guide implementation** using modern ABAP SQL syntax

## Modern ABAP SQL Quick Reference

### Basic SELECT with Inline Declaration
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint

mdr add likweitan/abap-skills/abap-sql-amdp@sha256:22fa7d51044272f4

The line at the top of this page pins the label git:20260916.c1b7d5e, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

[![mdr](https://markdownregistry.com/badge/art_ntfz2wam6a4hh25n.svg)](https://markdownregistry.com/a/art_ntfz2wam6a4hh25n)

1 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 3 versions of this file, between Apr 17, 2026 and Sep 16, 2026, about one every 76 days.

version	committed	commit	size	audit
git:20260916.c1b7d5e latest	2026-09-16	c1b7d5e	12,551 B	A	view · diff
git:20260417.b473266	2026-04-17	b473266	9,966 B	A	view · diff
git:20260417.5860c24	2026-04-17	5860c24	9,763 B	A	view

Audit of the latest version

A 17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.

pass: Frontmatter block present
pass: Frontmatter declares a name
pass: Frontmatter declares a description
pass: Size between 200 bytes and 200 KB (12551 bytes)
pass: No zero-width or bidi control characters
pass: No instruction hidden inside an HTML comment
pass: No link to an exfiltration or paste host
pass: No credential-shaped string
pass: No instruction to send local credentials anywhere
pass: No text hidden with inline styles
pass: No prompt-injection phrasing
pass: No curl or wget piped into a shell
pass: No recursive delete of root, home or parent
pass: No instruction to read or print local credentials
pass: No base64 blob over 200 characters
pass: No link to a raw IP address
pass: No script tag

Source

GitHub

likweitan/abap-skills · 72 stars · license MIT · pushed 2026-11-03 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_ntfz2wam6a4hh25n
GET https://markdownregistry.com/api/v1/resolve?ref=likweitan/abap-skills/abap-sql-amdp
GET https://markdownregistry.com/api/v1/blob/22fa7d51044272f4122d9df9d7f003e73b9c225f12526648acdf9949c022af9a

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from likweitan/abap-skills

abap-cloud-migration SKILL.md skill

likweitan/abap-skills · skills/abap-cloud-migration/SKILL.md · Help with migrating classic ABAP custom code toward higher clean core levels (Level A/B/C/D) including custom code…