SAP best practices · LessonBy Anitha M, SAP Trainer, 13 yrs · Published · SAP S/4HANA 2023 · all levels
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: Skipping the discipline under delivery pressure.
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?
Frequently asked questions
What does Performance mean in SAP best practice?
Performance best practice is mostly about efficient database access and code, plus proper sizing, applied consistently so the system stays fast at scale.
Which transaction codes come up with Performance in SAP best practice?
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.
What is the practical takeaway on Performance for SAP best practice?
Most performance problems are preventable custom-code or database issues.
What tends to go wrong with Performance in SAP best practice?
Skipping the discipline under delivery pressure. Not documenting decisions. Ignoring the clean-core principle.