SAP Table Field Lookup
UtilitiesNewLook up fields, data types, and descriptions for the most common SAP database tables: MARA, KNA1, VBAK, BKPF, EKKO, LFA1, and 50+ more. Offline reference.
Select a table to view its fields
Advertisement
About SAP Table Field Lookup
Remembering which field holds what on MARA, KNA1, VBAK, BKPF, or EKKO — without SE11 access or while working offline — is a daily annoyance for anyone writing SELECTs against standard SAP tables. This reference covers 50+ of the most commonly queried standard tables with field names, data types, and short descriptions, searchable without needing a live SAP connection.
How to use this tool
- Search for a table by its technical name (e.g. MARA, VBAK, BKPF).
- Browse the field list with data element, data type, and description for each column.
- Use the search box to find a specific field name across all listed tables.
- Reference the field list while writing SELECT statements or CDS view field lists offline.
All processing happens locally in your browser. No data is sent to any server. Your SAP code and business data remain private at all times.
Frequently Asked Questions
Where can I find all fields of an SAP table?
In a live SAP system, use transaction SE11 (ABAP Dictionary) or SE16 to see table fields. The table DD03L stores all field metadata. This tool provides an offline reference for the most commonly used tables.
What does the key icon mean in the field list?
A key icon indicates that the field is part of the table's primary key. In SAP, primary key fields uniquely identify a record and are always defined first in the table structure.
What is the MANDT field?
MANDT (Mandant = Client) is the first key field of most SAP application tables. SAP is a multi-client system; each client is an independent business environment. MANDT has type CLNT (length 3).
Advertisement