IT CanvassTalk to an advisor
SAP best practices · LessonBy , SAP Trainer, 13 yrs · Published · Updated · SAP S/4HANA 2023 · all levels

SAP Best Practice Performance

Performance best practice is mostly about efficient database access and code, plus proper sizing, applied consistently so the system stays fast at scale.

Quick answer

Most performance problems are preventable custom-code or database issues.

Key takeaways
  • No SELECTs in loops; read data once into internal tables.
  • Select only needed rows/columns; use indexed WHERE clauses.
  • Aggregate/join in the database (Open SQL, CDS), especially on HANA.
  • Watch out: a test against development data volumes proves nothing about production.

Key practices

  • No SELECTs in loops; read data once into internal tables.
  • Select only needed rows/columns; use indexed WHERE clauses.
  • Aggregate/join in the database (Open SQL, CDS), especially on HANA.
  • Use sorted/hashed internal tables and field-symbols for large data.
  • Size the database, buffers and work processes for the workload; measure with ST03/ST05.

Why it matters

Most performance problems are preventable custom-code or database issues. Applying these rules from the start, and measuring before tuning, keeps the system responsive as data and users grow, avoiding the slow programs that plague poorly-built systems.

Common pitfalls

  • Skipping the discipline under delivery pressure.
  • Not documenting decisions.
  • Ignoring the clean-core principle.

Practice challenge

+0 XPStreak ×0
Question 1 of 3
Which statement is true of Performance?
Already working on SAP and stuck on a live ticket?Get an expert SAP developer on screen-share to finish your daily tasks with you. Deliver on time, protect your reputation and your job. Monthly support only, no task-wise plans.Task assigned · no idea where to startStill stuck · your job on the lineExpert joins your screenDelivered on timeExplore On Job Support