SE16NBASIS

SAP SE16N — General Table Display

SE11 tells you what a table looks like. SE16N shows you what is in it. You give a table name, optionally some selection criteria, and get the rows back in an ALV grid.

It is the fastest way to answer a question that no standard report answers, and for that reason it is one of the most-used transactions among technical and functional consultants alike.

One warning worth stating plainly. SE16N historically contained a debug-driven route to editing table contents directly, bypassing all application logic. Doing so writes data without any of the checks, updates or audit trail that the real transaction would produce, and it is treated as a serious finding by auditors on almost every SAP system. Read with SE16N. Never write with it.

When you would actually use SE16N

What the screen looks like

General Table Display
SE16N

Table selection

TableBKPF
Number of entries500

Selection criteria

Company code (BUKRS)1000
Fiscal year (GJAHR)2026
Document type (BLART)KR
Posting date (BUDAT)01.07.2026 - 31.07.2026
Always set selection criteria. An unrestricted read of a document table can be millions of rows.
Client 100 | S/4HANA | Company Code 1000
Illustrative recreation.Selection fields are generated from the table's own structure — Drawn for training with invented data; not a capture of a real SAP system. Fields with a blue border are required. SAP is a trademark of SAP SE.
General Table Display: Result
SE16N
MANDTBUKRSBELNRGJAHRBLARTBUDATUSNAM
100100018000001232026KR13.06.2026DMANCUSO
100100018000001882026KR02.07.2026BATCHUSER
100100018000001902026KR02.07.2026BATCHUSER
3 entries found
Client 100 | S/4HANA | Company Code 1000
Illustrative recreation.Raw rows — no application formatting, no conversion exits — Drawn for training with invented data; not a capture of a real SAP system. Fields with a blue border are required. SAP is a trademark of SAP SE.

The fields, in plain English

Table

The technical table name. If you do not know it, click the field on the application screen and press F1 then technical information.

Number of entries

A cap on how many rows are read. It protects you from an accidental full-table scan and should be left at a sensible value.

Watch out: A capped result is not "all the data". If the count equals your cap exactly, assume there is more.

Selection criteria

Generated automatically from the table structure, so you can filter on any field. Multiple selection allows ranges, exclusions and patterns.

Watch out: Filter on key fields where you can. Filtering only on a non-key field forces the database to scan.

Output display

A standard ALV grid, so you can sort, filter, total and export to spreadsheet.

Watch out: Values are shown raw. A material number will carry its leading zeros and an amount will not be formatted the way an application screen would show it.

Step by step

  1. 1Find the table name — SE11, or F1 then technical information on the field.
  2. 2Enter it in SE16N and press Enter to generate the selection screen.
  3. 3Fill in selection criteria, favouring key fields.
  4. 4Set a sensible row cap.
  5. 5Execute and work with the result in the ALV grid.
  6. 6Export to spreadsheet if you need to analyse further.

Errors you will hit, and what they mean

No authorisation for table BKPF

Why: Table display is controlled by authorisation group. Financial and HR tables are commonly restricted.

Fix: Request access for the specific table group and say why. Blanket SE16N access to all tables is rightly hard to obtain.

Time limit exceeded

Why: Selection too broad, or filtering on non-key fields across a very large table.

Fix: Add key-field restrictions and a date range. Run in background for genuinely large extracts.

Values look wrong compared to the application screen

Why: SE16N shows stored values, not display-formatted ones — leading zeros, internal date formats, unconverted codes.

Fix: This is correct behaviour. Compare against the stored form, not the screen form.

Common questions

What is the difference between SE16 and SE16N?

SE16N is the newer general table display, with a more flexible selection screen and an ALV output. SE16 still exists and behaves similarly. Most people use SE16N where it is available.

Can I edit data in SE16N?

There have historically been debug-driven ways to do so, and you should not. Writing directly to tables bypasses application logic, updates and audit trail, and it is a standard audit finding. Change data through the transaction that owns it.

How do I find the table behind a field on a screen?

Click into the field, press F1, then the technical information button. It names the table and field.

Transactions that go with SE16N

SE11Understand the table structure firstSE38Write a program when a query gets complexAL11Look at files rather than tables

Reading about it only gets you so far

Practise SAP transactions in a safe simulated environment and keep what you learn.

See the SAP games →Study the full module

Practise SAP transactions hands-on

Interactive modules, games, and an AI tutor — free to start.

Get started free →