ABAP Performance — ECC (Traditional DB)

What it does

Practical guidance and patterns to optimise ABAP code running on SAP ECC systems with traditional relational databases (non-HANA). Covers SELECT patterns, minimizing database round-trips, table buffering strategies, internal table type selection, loop and bulk operation patterns, string handling, authorization checks, UI/ALV performance tips, and parallel processing approaches. Concrete code examples illustrate good vs bad patterns.

When to use it

Use this skill when reviewing or writing ABAP for systems that are NOT on HANA (ECC or classic DB backends). It is intended for code reviews, performance tuning sessions, and developer guidance when you need to reduce DB load, eliminate costly loops, or choose the right internal table types. Not appropriate for S/4HANA/HANA-specific tuning.

What's included

• Scripts: none (has_scripts=false)
• References: none embedded (has_references=false)
• Instructions: step-by-step recommendations and code snippets for SELECT usage, FOR ALL ENTRIES, buffering types, index awareness, table type selection (HASHED, SORTED), loop optimisations, bulk operations, string concat best practices, and ECC anti-patterns to avoid.

Compatible agents

Best used by developer-focused assistants and code-auditing agents that can operate on ABAP repositories and present code suggestions (e.g., Copilot-style code agents, Codex-like tools, or specialised ABAP linting assistants).