# Sap Abap Advanced > > - **Type:** Skill - **Install:** `agentstack add skill-efeumutaslan-sap-skills-sap-abap-advanced` - **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior - **Seller:** [efeumutaslan](https://agentstack.voostack.com/s/efeumutaslan) - **Installs:** 0 - **Category:** [Agent Skills](https://agentstack.voostack.com/c/agent-skills) - **Latest version:** 0.1.0 - **License:** MIT - **Upstream author:** [efeumutaslan](https://github.com/efeumutaslan) - **Source:** https://github.com/efeumutaslan/SAP-SKILLS/tree/main/skills/sap-abap-advanced ## Install ```sh agentstack add skill-efeumutaslan-sap-skills-sap-abap-advanced ``` Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent. ## About # Advanced ABAP — Cloud, HANA-Optimized & Modern Patterns ## Related Skills - `sap-abap` — Base ABAP skill (syntax, internal tables, OOP fundamentals) - `sap-rap-comprehensive` — RAP Business Objects built with ABAP Cloud - `sap-hana-cloud` — HANA database features consumed via AMDP - `sap-devops-cicd` — abapGit + gCTS pipeline integration - `sap-migration` — Classic → Cloud ABAP migration ## Quick Start **ABAP Cloud (Tier 1) vs Classic ABAP (Tier 2):** | Aspect | ABAP Cloud (Tier 1) | Classic ABAP (Tier 2) | |--------|---------------------|----------------------| | API Access | Released APIs only | All APIs (including internal) | | Where | BTP Steampunk, S/4HANA Cloud Public | S/4HANA Private, On-Premise | | Language version | `ABAP for Cloud Development` | `Standard ABAP` | | DB access | ABAP SQL only (no native SQL) | ABAP SQL + Native SQL + ADBC | | Extensibility | RAP, Released BAdIs only | All enhancement techniques | | Naming | Namespace `/.../ ` or `Z`/`Y` with prefix | `Z`/`Y` prefix | **Check if API is released:** ```abap " In ADT: Open element → Properties → API State " Or: ABAP Cloud: compilation error if not released " Or: Cloudification Repository (api.sap.com) ``` ## Core Concepts ### ABAP Cloud Restrictions What you **cannot** use in ABAP Cloud: - `SELECT ... FROM ` on non-released tables → Use released CDS views - `CALL FUNCTION` on non-released FMs → Use released APIs/classes - `WRITE` / `SUBMIT` / `CALL TRANSACTION` → Use RAP / HTTP services - `SY-SUBRC` after non-ABAP-SQL statements → Use exceptions - `INCLUDE`, `FORM/PERFORM` → Use classes/methods - Direct DB modifications (`INSERT/UPDATE/DELETE dbtab`) on non-owned tables ### ABAP Language Version (Since 2022) ```abap " Set in class/interface/program attributes: " Option 1: ABAP for Cloud Development (Tier 1 — released APIs only) " Option 2: Standard ABAP (Tier 2 — full access) " Option 3: ABAP for Key Users (limited, no-code) " Check programmatically: DATA(lv_version) = cl_abap_context_info=>get_abap_language_version( ). " Returns: 'CLOUD' | 'STANDARD' | 'KEYUSER' ``` ### Released API Categories | Category | Example | Check Method | |----------|---------|-------------| | Released CDS View | `I_BusinessPartner` | Prefix `I_` or `C_`, annotation `@ObjectModel.usageType` | | Released Class | `CL_BCS_MAIL_MESSAGE` | ADT: API State = Released | | Released Interface | `IF_HTTP_SERVICE_EXTENSION` | ADT: API State = Released | | Released BAdI | `BADI_IDENTITY_CHECK` | Enhancement Spot → Released flag | | Released RAP BO | `I_BankTP` | Behavior definition → Released | ## Common Patterns ### Pattern 1: AMDP — ABAP Managed Database Procedures ```abap CLASS zcl_amdp_examples DEFINITION PUBLIC. PUBLIC SECTION. INTERFACES if_amdp_marker_hdb. TYPES: BEGIN OF ty_sales_summary, customer_id TYPE vbak-kunnr, total_amount TYPE vbak-netwr, order_count TYPE i, avg_amount TYPE vbak-netwr, END OF ty_sales_summary, tt_sales_summary TYPE STANDARD TABLE OF ty_sales_summary WITH EMPTY KEY. " Table function (consumed in CDS) CLASS-METHODS get_sales_summary FOR TABLE FUNCTION z_tf_sales_summary. " Regular AMDP method CLASS-METHODS calculate_running_total IMPORTING VALUE(iv_customer) TYPE kunnr VALUE(iv_year) TYPE gjahr EXPORTING VALUE(et_result) TYPE tt_sales_summary RAISING cx_amdp_execution_error. ENDCLASS. CLASS zcl_amdp_examples IMPLEMENTATION. METHOD get_sales_summary BY DATABASE FUNCTION FOR HDB LANGUAGE SQLSCRIPT OPTIONS READ-ONLY USING vbak vbap. RETURN SELECT k.kunnr AS customer_id, SUM(p.netwr) AS total_amount, COUNT(DISTINCT k.vbeln) AS order_count, AVG(p.netwr) AS avg_amount FROM vbak AS k INNER JOIN vbap AS p ON k.vbeln = p.vbeln WHERE k.erdat >= :iv_date_from AND k.erdat get_method( ). WHEN 'GET'. handle_get( request = request response = response ). WHEN 'POST'. handle_post( request = request response = response ). WHEN OTHERS. response->set_status( 405 ). response->set_text( '{"error":"Method not allowed"}' ). ENDCASE. ENDMETHOD. METHOD handle_get. DATA(lv_id) = request->get_uri_query_parameter( 'id' ). TRY. SELECT SINGLE * FROM zi_myentity WHERE id = @lv_id INTO @DATA(ls_entity). IF sy-subrc <> 0. response->set_status( 404 ). response->set_text( '{"error":"Not found"}' ). RETURN. ENDIF. response->set_status( 200 ). response->set_header_field( i_name = 'Content-Type' i_value = 'application/json' ). response->set_text( /ui2/cl_json=>serialize( data = ls_entity ) ). CATCH cx_root INTO DATA(lx_error). response->set_status( 500 ). response->set_text( |{{"error":"{ lx_error->get_text( ) }"}}| ). ENDTRY. ENDMETHOD. ENDCLASS. ``` ### Pattern 3: abapGit Workflow ``` Development Workflow with abapGit: ┌─────────────┐ ┌──────────┐ ┌──────────┐ │ ABAP System │────►│ abapGit │────►│ GitHub │ │ (DEV) │◄────│ (tcode: │◄────│ Repo │ │ │ │ ZABAPGIT)│ │ │ └─────────────┘ └──────────┘ └──────────┘ ``` **Best practices:** 1. One Git repo per package (or package tree root) 2. Use `.abapgit.xml` for serialization settings 3. Never commit generated artifacts (proxies, number range objects) 4. Use transport-based deployment to QA/PRD (not abapGit pull) 5. Branch strategy: `main` (PRD state) + `dev` + feature branches ```xml E /src/ PREFIX /.gitignore /LICENSE /README.md /package.json /.travis.yml ``` ### Pattern 4: Released API Wrapper Pattern ```abap " When you need non-released functionality in ABAP Cloud, " create a Tier 2 wrapper and release it " Step 1: Tier 2 class (Standard ABAP) — wraps non-released API CLASS zcl_legacy_wrapper DEFINITION PUBLIC FINAL CREATE PUBLIC. PUBLIC SECTION. " Mark with C1 release contract INTERFACES if_released_for_cloud. METHODS get_customer_credit IMPORTING iv_customer TYPE kunnr RETURNING VALUE(rv_limit) TYPE knkk-klimk RAISING cx_sy_no_handler. ENDCLASS. CLASS zcl_legacy_wrapper IMPLEMENTATION. METHOD get_customer_credit. " This uses non-released table KNKK — allowed in Tier 2 SELECT SINGLE klimk FROM knkk WHERE kunnr = @iv_customer INTO @rv_limit. ENDMETHOD. ENDCLASS. " Step 2: Tier 1 consumer (ABAP Cloud) — uses released wrapper CLASS zcl_cloud_consumer DEFINITION PUBLIC FINAL CREATE PUBLIC. PUBLIC SECTION. METHODS check_credit_limit IMPORTING iv_customer TYPE kunnr iv_amount TYPE netwr RETURNING VALUE(rv_ok) TYPE abap_bool. ENDCLASS. CLASS zcl_cloud_consumer IMPLEMENTATION. METHOD check_credit_limit. DATA(lo_wrapper) = NEW zcl_legacy_wrapper( ). DATA(lv_limit) = lo_wrapper->get_customer_credit( iv_customer ). rv_ok = xsdbool( iv_amount component_table. " Build component list lt_components = VALUE #( ( name = 'ID' type = cl_abap_elemdescr=>get_string( ) ) ( name = 'NAME' type = cl_abap_elemdescr=>get_string( ) ) ( name = 'AMOUNT' type = cl_abap_elemdescr=>get_p( p_length = 8 p_decimals = 2 ) ) ). " Add dynamic fields from config LOOP AT it_custom_fields ASSIGNING FIELD-SYMBOL(). APPEND VALUE #( name = -fieldname type = SWITCH #( -datatype WHEN 'STRING' THEN cl_abap_elemdescr=>get_string( ) WHEN 'INT' THEN cl_abap_elemdescr=>get_i( ) WHEN 'DATE' THEN cl_abap_elemdescr=>get_d( ) ) ) TO lt_components. ENDLOOP. " Create types DATA(lo_struct) = cl_abap_structdescr=>create( lt_components ). DATA(lo_table) = cl_abap_tabledescr=>create( lo_struct ). " Create data references CREATE DATA rr_table TYPE HANDLE lo_table. ASSIGN rr_table->* TO FIELD-SYMBOL(). " Now use for dynamic SELECT SELECT (it_fieldlist) FROM (iv_tablename) INTO CORRESPONDING FIELDS OF TABLE @ UP TO iv_max_rows ROWS. ENDMETHOD. ``` ## Error Catalog | Error | Message | Root Cause | Fix | |-------|---------|------------|-----| | `Use of non-released API` | Not released for ABAP Cloud | Using Tier 2 API in Tier 1 | Find released alternative or create Tier 2 wrapper | | `AMDP: Syntax error` | SQLScript compilation failed | Invalid SQLScript in AMDP method | Check HANA SQL syntax; test in HANA SQL Console | | `CX_AMDP_EXECUTION_ERROR` | AMDP runtime failure | Data type mismatch or HANA error | Check parameter types match HANA equivalents | | `abapGit: Deserialization` | Object import failed | Conflicting object in target system | Check package assignment; resolve naming conflicts | | `abapGit: Auth error` | GitHub authentication failed | Token expired or wrong permissions | Regenerate personal access token with repo scope | | `ABAP SQL: Syntax not allowed` | Feature not available | SQL feature not supported in ABAP Cloud | Check ABAP release notes for SQL feature availability | | `Released API deprecated` | Successor API available | Using deprecated released API | Migrate to successor (check ADT deprecation info) | | `Tier mismatch` | Cannot use Tier 1 in Tier 2 context | Mixing language versions incorrectly | Keep clean tier separation; wrappers go Tier 2 → Tier 1 | ## Performance Tips 1. **Push down to HANA** — Use AMDP for complex calculations; avoid ABAP loops for aggregation 2. **ABAP SQL over Open SQL** — New ABAP SQL features (window functions, CTEs) execute on DB 3. **Avoid SELECT in loops** — Use JOINs or associations; even with buffered tables, loop SELECTs are anti-patterns 4. **Buffer wisely** — `cl_abap_context_info=>get_system_date()` is buffered; `sy-datum` triggers DB call per access in cloud 5. **AMDP table functions** — For CDS consumption, table functions outperform calculated fields for complex logic 6. **Parallel processing** — Use `CL_ABAP_PARALLEL` for cloud-compatible parallel RFC replacement 7. **String operations** — Use string templates `|{ }|` over `CONCATENATE`; they're optimized in cloud runtime ## Validation Workflow After writing or modifying ABAP Cloud code, run the compliance validator: ```bash bash scripts/validate-abap-cloud.sh ./src ``` **Plan → Validate → Fix → Validate again** — do not proceed until validation passes with 0 errors. ## Gotchas - **No SE80/SE38 in Cloud**: Use ADT (Eclipse) exclusively for ABAP Cloud development - **No transport in Steampunk**: BTP ABAP Environment uses software components + Git, not transport requests - **AMDP debugging**: Set breakpoints in ADT; SQLScript debugging requires HANA permissions - **abapGit and namespaces**: Namespace `/MYNAMESPACE/` objects need special serializer configuration - **Released API stability**: C1 (released) APIs have backward-compatible contract; C0 can change anytime - **Tier 2 is not "legacy"**: Tier 2 (Standard ABAP) is valid for S/4HANA Private/On-Premise — it's not deprecated ## MCP Server Integration For live ABAP system access, add to your `.mcp.json`: ```json { "mcpServers": { "vibing-steampunk": { "command": "npx", "args": ["-y", "vibing-steampunk"], "env": { "SAP_HOST": "https://your-system.abap.hana.ondemand.com", "SAP_USER": "YOUR_USER", "SAP_PASSWORD": "YOUR_PASSWORD" } }, "sap-docs": { "command": "npx", "args": ["-y", "mcp-sap-docs"] } } } ``` - **Vibing Steampunk** (41-68 tools): Full ADT bridge — read/write ABAP source, syntax check, ATC, debug - **SAP Docs**: Offline ABAP documentation with hybrid BM25+semantic search ## Source & license This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code. - **Author:** [efeumutaslan](https://github.com/efeumutaslan) - **Source:** [efeumutaslan/SAP-SKILLS](https://github.com/efeumutaslan/SAP-SKILLS) - **License:** MIT Install and usage instructions live in the source repository linked above. ## Pricing - **Free** — Free ## Security capabilities Automated source analysis of v0.1.0 — what this tool can access: - **Network access:** no - **Filesystem access:** no - **Shell / process execution:** no - **Environment & secrets:** no - **Dynamic code execution:** no *"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.* ## Versions - **0.1.0** — security scan: passed — Imported from the upstream source. ## Links - Listing page: https://agentstack.voostack.com/l/skill-efeumutaslan-sap-skills-sap-abap-advanced - Seller: https://agentstack.voostack.com/s/efeumutaslan - Browse the marketplace: https://agentstack.voostack.com/browse --- Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.