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

Tables hub

Quick answer

Understanding tables lets you report, write CDS/SQL, and debug ("which table holds this field?

Key takeaways

  • Each table page gives what it stores, key fields, keys/relationships, and related tables, the reference practitioners look up…
  • SE11: view a table’s structure, fields, keys, indexes.
  • SE16N: browse table contents (with authorization).
  • Watch out: Reading raw tables where a CDS view/report is better.

Why tables matter

Understanding tables lets you report, write CDS/SQL, and debug ("which table holds this field?"). SAP tables follow patterns, master data (MARA material, KNA1 customer, LFA1 vendor) and documents in header/item pairs (VBAK/VBAP sales, EKKO/EKPO purchasing, BKPF/BSEG finance). Table references are among the most-searched SAP topics.

Exploring tables

  • SE11: view a table’s structure, fields, keys, indexes.
  • SE16N: browse table contents (with authorization).
  • Header/item patterns link related tables via a key (e.g. VBELN).
  • CDS views increasingly provide a modeled layer over raw tables.

Using this module

Each table page gives what it stores, key fields, keys/relationships, and related tables, the reference practitioners look up constantly. In S/4HANA, note that some classic tables are now CDS views/compatibility views over a simplified model (e.g. finance in ACDOCA).

Common pitfalls

  • Reading raw tables where a CDS view/report is better.
  • Ignoring header/item relationships.
  • Querying big tables without indexed selection.

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 Tables hub?

    • A. NetWeaver release notes cover the classic application-server platform underpinning many SAP products (ECC…
    • B. SAP exposes its data and logic through several API technologies, from the modern OData/REST interfaces used…
    • C. ").
    Show answer

    C. ").

    Covered in the “Why tables matter” section of this lesson.

  2. Which of these also applies to Tables hub?

    • A. Expecting Fiori to replace all GUI, config and long-tail transactions remain in GUI.
    • B. Unbalanced postings, documents must balance.
    • C. SAP tables follow patterns, master data (MARA material, KNA1 customer, LFA1 vendor) and documents in…
    Show answer

    C. SAP tables follow patterns, master data (MARA material, KNA1 customer, LFA1 vendor) and documents in…

    Covered in the “Why tables matter” section of this lesson.

  3. Which part of the Learn SAP curriculum covers Tables hub?

    • A. SAP ABAP development
    • B. SAP tables
    • C. SAP APIs
    Show answer

    B. SAP tables

    This lesson sits in the SAP tables section of the Learn SAP course.

Frequently asked questions

What does the term Tables hub refer to in SAP?

SAP stores all its data in database tables, and knowing the key ones, their fields and relationships, is essential for reporting, development and troubleshooting. This hub lists the most important tables; each page details structure, fields, keys and related tables.

What is another point to note about Tables hub?

Understanding tables lets you report, write CDS/SQL, and debug ("which table holds this field?

What else is worth knowing about Tables hub?

Each table page gives what it stores, key fields, keys/relationships, and related tables, the reference practitioners look up constantly.

What tends to go wrong with Tables hub?

Reading raw tables where a CDS view/report is better. Ignoring header/item relationships. Querying big tables without indexed selection.
CallWhatsAppEnquire