skilld
All skills
secondsky avatar

/sap-abap-cds

@620a19a
by Eddiesecondsky/sap-skills456 stars
120

Comprehensive SAP ABAP CDS (Core Data Services) reference for data modeling, view development, and semantic enrichment. Use when creating CDS views or view entities, defining data models with annotations, working with associations and cardinality, implementing input parameters, using built-in functions, writing CASE expressions, implementing access control with DCL, handling CURR/QUAN data types, troubleshooting CDS errors, querying CDS views from ABAP, or displaying data with SALV IDA. Covers ABAP 7.4+ through ABAP Cloud.

Ask your Agent

Use this Skill: https://skilld.dev/gh/secondsky/sap-skills/sap-abap-cds

This session only. Nothing lands on disk.

README.md

≈1.6k tokens on demand. Your agent reads this file only when SKILL.md points to it.

SAP ABAP CDS (Core Data Services) Skill

Comprehensive Claude Code skill for SAP ABAP CDS view development, annotations, expressions, and access control.

Capability Index

Capability Status
Commands 1: /abap-cds-model-check
Agents 0
Hooks No
MCP No
LSP No
Source Freshness last_verified: 2026-04-02; CDS activation and ATC behavior still require system verification.
Verification npm run validate; production ABAP system checks pending unless explicitly documented.

Overview

This skill provides complete reference material for developing CDS views in SAP ABAP, from basic view creation to advanced topics like associations, access control, and performance optimization.

When to Use This Skill

Use this skill when:

  • Creating CDS views or view entities in ABAP
  • Defining data models with annotations
  • Working with associations and cardinality
  • Implementing input parameters
  • Using built-in functions (string, numeric, date/time)
  • Writing CASE expressions and conditional logic
  • Implementing access control with DCL
  • Handling CURR/QUAN data types
  • Troubleshooting CDS errors (SD_CDS_ENTITY105)
  • Querying CDS views from ABAP
  • Displaying data with SALV IDA

Keywords

Core CDS Terms

  • ABAP CDS
  • Core Data Services
  • CDS view
  • CDS view entity
  • define view
  • define view entity
  • DDL (Data Definition Language)
  • DCL (Data Control Language)

Annotations

  • @AbapCatalog
  • @AbapCatalog.sqlViewName
  • @AbapCatalog.compiler.CompareFilter
  • @AccessControl
  • @AccessControl.authorizationCheck
  • @EndUserText
  • @EndUserText.label
  • @EndUserText.quickInfo
  • @Semantics
  • @Semantics.currencyCode
  • @Semantics.amount
  • @Semantics.unitOfMeasure
  • @Semantics.quantity
  • @UI
  • @UI.lineItem
  • @UI.identification
  • @UI.selectionField
  • @UI.hidden
  • @UI.facet
  • @UI.fieldGroup
  • @UI.dataPoint
  • @Consumption
  • @Consumption.valueHelpDefinition
  • @ObjectModel
  • @ObjectModel.text
  • @Metadata
  • @Metadata.allowExtensions
  • @Metadata.ignorePropagatedAnnotations
  • @Analytics
  • @Search

Associations

  • association
  • cardinality
  • TO ONE
  • TO MANY
  • path expressions
  • exposed association
  • join-on-demand
  • $projection

Parameters

  • input parameters
  • WITH PARAMETERS
  • $parameters
  • @Environment.systemField

Functions

  • built-in functions
  • string functions
  • concat
  • substring
  • upper
  • lower
  • length
  • replace
  • lpad
  • rpad
  • ltrim
  • rtrim
  • numeric functions
  • abs
  • ceil
  • floor
  • round
  • div
  • division
  • mod
  • date functions
  • dats_add_days
  • dats_add_months
  • dats_days_between
  • dats_is_valid
  • coalesce
  • CAST
  • aggregate functions
  • SUM
  • AVG
  • MIN
  • MAX
  • COUNT

Expressions

  • CASE expression
  • simple CASE
  • searched CASE
  • arithmetic operations
  • comparison operators
  • BETWEEN
  • LIKE
  • IS NULL
  • session variables
  • $session
  • $session.user
  • $session.system_language
  • $session.system_date

Joins

  • INNER JOIN
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN
  • CROSS JOIN

Access Control

  • DEFINE ROLE
  • DCL
  • pfcg_auth
  • authorization
  • MappingRole
  • aspect user
  • access control

Data Types

  • CURR
  • QUAN
  • currencyCode
  • unitOfMeasure
  • abap.dats
  • abap.tims
  • abap.char
  • abap.numc
  • abap.int4
  • abap.curr
  • abap.cuky
  • abap.quan
  • abap.unit

Tools and Transactions

  • Eclipse ADT
  • ABAP Development Tools
  • SDDLAR
  • SALV IDA
  • cl_salv_gui_table_ida
  • cl_salv_table
  • CL_DD_DDL_ANNOTATION_SERVICE

Errors

  • SD_CDS_ENTITY105
  • missing reference information
  • cardinality mismatch

Related Technologies

  • Fiori Elements
  • OData
  • RAP
  • ABAP RESTful Application Programming Model
  • ABAP Cloud
  • S/4HANA
  • BTP ABAP Environment

Skill Structure

sap-abap-cds/
├── SKILL.md                          # Main skill file
├── README.md                         # This file
├── references/
│   ├── annotations-reference.md      # Complete annotation catalog
│   ├── functions-reference.md        # All built-in functions
│   ├── associations-reference.md     # Associations and cardinality
│   ├── access-control-reference.md   # DCL and authorization
│   ├── expressions-reference.md      # Expressions and operators
│   └── troubleshooting.md            # Common errors and solutions
└── templates/
    ├── basic-view.md                 # Standard CDS view template
    ├── parameterized-view.md         # View with parameters template
    └── dcl-template.md               # Access control template

Quick Examples

Basic CDS View

@AbapCatalog.sqlViewName: 'ZEXAMPLE_V'
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Example View'

define view Z_EXAMPLE as select from db_table
{
  key field1,
      field2
}

CDS View Entity (7.55+)

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Example View Entity'

define view entity Z_EXAMPLE_E as select from db_table
{
  key field1,
      field2
}

Association

association [0..1] to target as _Target
  on $projection.key_field = _Target.key_field

Access Control

@MappingRole: true
define role Z_EXAMPLE_DCL {
  grant select on Z_EXAMPLE
    where (bukrs) = aspect pfcg_auth(F_BKPF_BUK, BUKRS, ACTVT = '03');
}

Documentation Sources

Requirements

  • SAP NetWeaver 7.4 SP8+ for CDS Views
  • SAP NetWeaver 7.55+ for CDS View Entities
  • Eclipse with ABAP Development Tools (ADT)
  • SAP HANA database (recommended)

Version

  • Skill Version: 1.0.0
  • Last Verified: 2026-04-02
  • ABAP Release: 7.4 SP8+ / ABAP Cloud

License

GPL-3.0 License

Source: SKILL.md on GitHub

Third-party checks

1 warning15d4 checks · Risk SAFE
  • Gen Agent Trust Hub15d

    The skill provides comprehensive reference material, templates, and troubleshooting guides for SAP ABAP CDS development. It consists entirely of documentation and static templates without executable code. All external references point to official SAP resources and well-known community repositories.

  • Socket15d

    No alerts

  • Snyk15d

    Risk: LOW · No issues

  • Runlayer6mo

    5/12 files flagged

Provenance

Signed by skilld at 620a19a. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 2 weeks ago.

Activeupdated 2 months ago

Capability

Other metadata
metadata
{
  "maintainer": "Eduard Jiglau",
  "maintainer_email": "hello@sap-ai-skills.com",
  "website": "https://sap-ai-skills.com",
  "version": "2.4.1",
  "last_verified": "2026-04-02",
  "abap_release": "7.4 SP8+ / 7.50+ / ABAP Cloud",
  "sources": [
    "https://help.sap.com/doc/abapdocu_cp_index_htm/CLOUD/en-US/abencds.html",
    "https://github.com/SAP-samples/abap-cheat-sheets"
  ],
  "keywords": [
    "ABAP CDS",
    "Core Data Services",
    "CDS view",
    "CDS view entity",
    "define view",
    "DDL",
    "DCL",
    "annotations",
    "@AbapCatalog",
    "@AccessControl",
    "@EndUserText",
    "@Semantics",
    "@UI",
    "@Consumption",
    "@ObjectModel",
    "associations",
    "cardinality",
    "path expressions",
    "input parameters",
    "WITH PARAMETERS",
    "built-in functions",
    "CASE expression",
    "CAST",
    "session variables",
    "GROUP BY",
    "HAVING",
    "joins",
    "access control",
    "DEFINE ROLE",
    "pfcg_auth",
    "SALV IDA",
    "Eclipse ADT",
    "CDS annotations",
    "Fiori Elements",
    "OData",
    "RAP",
    "currencyCode",
    "unitOfMeasure",
    "SD_CDS_ENTITY105"
  ]
}

README badge

README badge for secondsky/sap-skills/sap-abap-cds