Skip to content
IT Canvass
Menu
ServiceNow
SailPoint
SAP
TutorialsContact
SAP best practices · Lesson

Performance

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.

Want to learn this properly?

Our live, instructor-led SAP Training covers this hands-on, with real projects and a certification path.

See the courseAsk a question

Check your understanding

  1. Which statement is true of Performance?

    • A. Applying these rules from the start, and measuring before tuning, keeps the system responsive as data and…
    • B. SD reporting provides visibility into the sales process, orders, deliveries, billing, and sales performance…
    • C. SAP Ariba is SAP’s cloud procurement suite and business network, connecting buyers and suppliers for…
    Show answer

    A. Applying these rules from the start, and measuring before tuning, keeps the system responsive as data and…

    Covered in the “Why it matters” section of this lesson.

  2. Which of these also applies to Performance?

    • A. Use sorted/hashed internal tables and field-symbols for large data.
    • B. Over-broad roles violating least privilege.
    • C. Treating HANA like a row-store legacy DB.
    Show answer

    A. Use sorted/hashed internal tables and field-symbols for large data.

    Covered in the “Key practices” section of this lesson.

  3. Which part of the Learn SAP curriculum covers Performance?

    • A. SAP HANA
    • B. SAP best practices
    • C. SAP MM
    Show answer

    B. SAP best practices

    This lesson sits in the SAP best practices section of the Learn SAP course.

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.
CallWhatsAppEnquire