🗂️
SAP Table Field Lookup
UtilitiesNewLook up fields, data types, and descriptions for 28 of the most common SAP database tables: MARA, KNA1, VBAK, BKPF, EKKO, LFA1, MSEG, VBRK, ANLA, BUT000, and more. Offline reference.
Select a table to view its fields
Complete Table Reference
MARAGeneral Material Data · 12 fieldsMM
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑MATNR | MATNR | 18 | Material Number |
| ERSDA | DATUM | 8 | Created On |
| ERNAM | UNAME | 12 | Created By |
| MTART | MTART | 4 | Material Type |
| MBRSH | MBRSH | 1 | Industry Sector |
| MATKL | MATKL | 9 | Material Group |
| MEINS | MEINS | 3 | Base Unit of Measure |
| BRGEW | BRGEW | 13 | Gross Weight |
| NTGEW | NTGEW | 13 | Net Weight |
| GEWEI | GEWEI | 3 | Weight Unit |
| BISMT | BISMT | 18 | Old Material Number |
MARCPlant Data for Material · 8 fieldsMM
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑MATNR | MATNR | 18 | Material Number |
| 🔑WERKS | WERKS | 4 | Plant |
| EKGRP | EKGRP | 3 | Purchasing Group |
| DISGR | DISGR | 4 | MRP Group |
| DISPO | DISPO | 3 | MRP Controller |
| MINBE | MINBE | 13 | Reorder Point |
| EISBE | EISBE | 13 | Safety Stock |
KNA1General Data in Customer Master · 10 fieldsSD
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑KUNNR | KUNNR | 10 | Customer Number |
| NAME1 | NAME1 | 35 | Name 1 |
| NAME2 | NAME2 | 35 | Name 2 |
| LAND1 | LAND1 | 3 | Country Key |
| ORT01 | ORT01 | 35 | City |
| PSTLZ | PSTLZ | 10 | Postal Code |
| STRAS | STRAS | 35 | Street Address |
| TELF1 | TELF1 | 16 | Telephone 1 |
| KTOKD | KTOKD | 4 | Account Group |
LFA1Vendor Master (General Section) · 7 fieldsMM
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑LIFNR | LIFNR | 10 | Vendor Number |
| NAME1 | NAME1 | 35 | Name 1 |
| LAND1 | LAND1 | 3 | Country Key |
| ORT01 | ORT01 | 35 | City |
| STRAS | STRAS | 35 | Street Address |
| KTOKK | KTOKK | 4 | Vendor Account Group |
VBAKSales Document: Header Data · 11 fieldsSD
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑VBELN | VBELN | 10 | Sales Document Number |
| ERDAT | DATUM | 8 | Created On |
| ERZET | UZEIT | 6 | Created At |
| ERNAM | UNAME | 12 | Created By |
| AUART | AUART | 4 | Sales Document Type |
| KUNNR | KUNNR | 10 | Sold-to Party |
| NETWR | NETWR | 15 | Net Value |
| WAERK | WAERK | 5 | Currency |
| VKORG | VKORG | 4 | Sales Organization |
| VTWEG | VTWEG | 2 | Distribution Channel |
VBAPSales Document: Item Data · 9 fieldsSD
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑VBELN | VBELN | 10 | Sales Document Number |
| 🔑POSNR | POSNR | 6 | Item Number |
| MATNR | MATNR | 18 | Material Number |
| WERKS | WERKS | 4 | Plant |
| ARKTX | ARKTX | 40 | Short text |
| KWMENG | KWMENG | 13 | Order Quantity (Sales) |
| NETWR | NETWR | 15 | Net Value |
| PSTYV | PSTYV | 4 | Item Category |
BKPFAccounting Document Header · 10 fieldsFI
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑BUKRS | BUKRS | 4 | Company Code |
| 🔑BELNR | BELNR | 10 | Document Number |
| 🔑GJAHR | GJAHR | 4 | Fiscal Year |
| BLART | BLART | 2 | Document Type |
| BLDAT | DATUM | 8 | Document Date |
| BUDAT | DATUM | 8 | Posting Date |
| WAERS | WAERS | 5 | Currency Key |
| USNAM | UNAME | 12 | User Name |
| XBLNR | XBLNR | 16 | Reference Document Number |
BSEGAccounting Document Segment · 9 fieldsFI
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑BUKRS | BUKRS | 4 | Company Code |
| 🔑BELNR | BELNR | 10 | Document Number |
| 🔑GJAHR | GJAHR | 4 | Fiscal Year |
| 🔑BUZEI | BUZEI | 3 | Line Item Number |
| HKONT | HKONT | 10 | G/L Account |
| KOSTL | KOSTL | 10 | Cost Center |
| DMBTR | DMBTR | 15 | Amount in Local Currency |
| WRBTR | WRBTR | 15 | Amount in Document Currency |
EKKOPurchasing Document Header · 8 fieldsMM
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑EBELN | EBELN | 10 | Purchasing Document Number |
| BUKRS | BUKRS | 4 | Company Code |
| BSTYP | BSTYP | 1 | Purchasing Document Category |
| BSART | BSART | 4 | Purchasing Document Type |
| LIFNR | LIFNR | 10 | Vendor Number |
| BEDAT | DATUM | 8 | Purchase Order Date |
| EKGRP | EKGRP | 3 | Purchasing Group |
EKPOPurchasing Document Item · 8 fieldsMM
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑EBELN | EBELN | 10 | Purchasing Document Number |
| 🔑EBELP | EBELP | 5 | Item Number |
| MATNR | MATNR | 18 | Material Number |
| WERKS | WERKS | 4 | Plant |
| MENGE | MENGE | 13 | PO Quantity |
| MEINS | MEINS | 3 | Order Unit |
| NETPR | PREIS | 11 | Net Price |
PA0001HR Master Record: Org Assignment · 10 fieldsHR
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑PERNR | PERSNO | 8 | Personnel Number |
| 🔑INFTY | INFTY | 4 | Infotype |
| 🔑SUBTY | SUBTY | 4 | Subtype |
| 🔑BEGDA | DATUM | 8 | Start Date |
| 🔑ENDDA | DATUM | 8 | End Date |
| BUKRS | BUKRS | 4 | Company Code |
| WERKS | WERKS | 4 | Personnel Area |
| BTRTL | BTRTL | 4 | Personnel Subarea |
| PLANS | PLVAR | 8 | Position |
T001Company Codes · 8 fieldsFI
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑BUKRS | BUKRS | 4 | Company Code |
| BUTXT | TEXT25 | 25 | Company Code Name |
| ORT01 | ORT01 | 25 | City |
| LAND1 | LAND1 | 3 | Country |
| WAERS | WAERS | 5 | Currency Key |
| SPRAS | SPRAS | 1 | Language Key |
| KTOPL | KTOPL | 4 | Chart of Accounts |
MAKTMaterial Descriptions · 5 fieldsMM
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑MATNR | MATNR | 18 | Material Number |
| 🔑SPRAS | SPRAS | 1 | Language Key |
| MAKTX | MAKTX | 40 | Material Description |
| MAKTG | MAKTG | 40 | Material Description (Upper Case) |
MBEWMaterial Valuation · 8 fieldsMM
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑MATNR | MATNR | 18 | Material Number |
| 🔑BWKEY | BWKEY | 4 | Valuation Area |
| 🔑BWTAR | BWTAR | 10 | Valuation Type |
| VPRSV | VPRSV | 1 | Price Control Indicator (S/V) |
| STPRS | STPRS | 11 | Standard Price |
| VERPR | VERPR | 11 | Moving Average Price |
| PEINH | PEINH | 5 | Price Unit |
MSEGDocument Segment: Material · 9 fieldsMM
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑MBLNR | MBLNR | 10 | Material Document Number |
| 🔑MJAHR | MJAHR | 4 | Material Document Year |
| 🔑ZEILE | MBLPO | 4 | Item Number |
| BWART | BWART | 3 | Movement Type |
| MATNR | MATNR | 18 | Material Number |
| WERKS | WERKS | 4 | Plant |
| LGORT | LGORT | 4 | Storage Location |
| MENGE | MENGE | 13 | Quantity |
MKPFMaterial Document Header · 7 fieldsMM
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑MBLNR | MBLNR | 10 | Material Document Number |
| 🔑MJAHR | MJAHR | 4 | Material Document Year |
| BLDAT | DATUM | 8 | Document Date |
| BUDAT | DATUM | 8 | Posting Date |
| CPUDT | DATUM | 8 | Entry Date |
| USNAM | UNAME | 12 | User Name |
T001WPlants/Branches · 6 fieldsMM
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑WERKS | WERKS | 4 | Plant |
| NAME1 | NAME1 | 30 | Plant Name |
| LAND1 | LAND1 | 3 | Country |
| ORT01 | ORT01 | 25 | City |
| BWKEY | BWKEY | 4 | Valuation Area |
VBRKBilling Document: Header Data · 7 fieldsSD
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑VBELN | VBELN | 10 | Billing Document Number |
| FKART | FKART | 4 | Billing Type |
| FKDAT | DATUM | 8 | Billing Date |
| KUNAG | KUNNR | 10 | Sold-to Party |
| NETWR | NETWR | 15 | Net Value |
| WAERK | WAERK | 5 | Currency |
VBRPBilling Document: Item Data · 7 fieldsSD
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑VBELN | VBELN | 10 | Billing Document Number |
| 🔑POSNR | POSNR | 6 | Item Number |
| MATNR | MATNR | 18 | Material Number |
| FKIMG | FKIMG | 13 | Billed Quantity |
| NETWR | NETWR | 15 | Net Value |
| AUBEL | VBELN | 10 | Reference Sales Document |
LIKPDelivery Header Data · 6 fieldsSD
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑VBELN | VBELN | 10 | Delivery Number |
| LFART | LFART | 4 | Delivery Type |
| KUNNR | KUNNR | 10 | Ship-to Party |
| WADAT | DATUM | 8 | Goods Issue Date (Planned) |
| LFDAT | DATUM | 8 | Delivery Date |
LIPSDelivery: Item Data · 7 fieldsSD
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑VBELN | VBELN | 10 | Delivery Number |
| 🔑POSNR | POSNR | 6 | Item Number |
| MATNR | MATNR | 18 | Material Number |
| WERKS | WERKS | 4 | Plant |
| LFIMG | LFIMG | 13 | Delivery Quantity |
| VGBEL | VBELN | 10 | Reference Document (Sales Order) |
ANLAAsset Master Record Segment · 7 fieldsFI
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑BUKRS | BUKRS | 4 | Company Code |
| 🔑ANLN1 | ANLN1 | 12 | Asset Number (Main) |
| 🔑ANLN2 | ANLN2 | 4 | Asset Sub-number |
| ANLKL | ANLKL | 8 | Asset Class |
| AKTIV | DATUM | 8 | Capitalization Date |
| TXT50 | TXT50_ANLA | 50 | Asset Description |
SKA1G/L Account Master (Chart of Accounts) · 5 fieldsFI
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑KTOPL | KTOPL | 4 | Chart of Accounts |
| 🔑SAKNR | SAKNR | 10 | G/L Account Number |
| KTOKS | KTOKS | 4 | G/L Account Group |
| XBILK | XBILK | 1 | Balance Sheet Account Indicator |
SKB1G/L Account Master (Company Code) · 5 fieldsFI
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑BUKRS | BUKRS | 4 | Company Code |
| 🔑SAKNR | SAKNR | 10 | G/L Account Number |
| WAERS | WAERS | 5 | Account Currency |
| XSPEB | XSPEB | 1 | Blocked for Posting Indicator |
TCURRExchange Rates · 6 fieldsFI
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑KURST | KURST | 4 | Exchange Rate Type |
| 🔑FCURR | FCURR | 5 | From Currency |
| 🔑TCURR | TCURR | 5 | To Currency |
| 🔑GDATU | DATUM | 8 | Valid From Date |
| UKURS | UKURS_CURR | 9 | Exchange Rate |
T005Countries · 5 fieldsBasis
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑LAND1 | LAND1 | 3 | Country Key |
| LANDX | LANDX50 | 50 | Country Name |
| INTCA1 | INTCA1 | 3 | ISO Country Code |
| WAERS | WAERS | 5 | Local Currency |
BUT000Business Partner: General Data · 6 fieldsBasis
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑MANDT | CLNT | 3 | Client |
| 🔑PARTNER | BU_PARTNER | 10 | Business Partner Number |
| TYPE | BU_TYPE | 1 | Business Partner Category (1/2/3) |
| NAME_ORG1 | BU_NAME_ORG1 | 40 | Organization Name 1 |
| NAME_FIRST | BU_NAME_FIRST | 40 | First Name (Person) |
| NAME_LAST | BU_NAME_LAST | 40 | Last Name (Person) |
ADRCAddresses (Business Address Services) · 6 fieldsBasis
| Field | Type | Len | Description |
|---|---|---|---|
| 🔑CLIENT | MANDT | 3 | Client |
| 🔑ADDRNUMBER | AD_ADDRNUM | 10 | Address Number |
| NAME1 | AD_NAME1 | 40 | Name 1 |
| CITY1 | AD_CITY1 | 40 | City |
| POST_CODE1 | AD_PSTCD1 | 10 | Postal Code |
| COUNTRY | LAND1 | 3 | Country Key |
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 28 of the most commonly queried standard tables across MM, SD, FI, HR, and cross-application Business Partner data, 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
Related Topics
sap table fieldsmara fieldskna1 fieldsvbak fieldsbkpf fieldssap database tablesdd03lmseg fieldsbut000 fields
All Tools
🔍OData Filter Builder🗄️CDS View Generator📅SAP DATS / TIMS Converter🔄JSON to ABAP Structure🔐Base64 Encoder / Decoder{ }JSON Formatter & Validator🔔SAP Message Class Generator📊ABAP Data Type Reference🔭OData Metadata Viewer🗃️ABAP SELECT Statement Builder🗂️SAP Table Field Lookup⚠️ABAP Exception Handler Generator💰SAP BTP Service Price Calculator🔎SAP BAPI Explorer🎯Fiori Launchpad Tile Configurator✨ABAP Code Formatter🔒SAP Authorization Object Browser📄RFC Function Module Docs Generator📦SAP IDoc Segment Explorer📝CDS Annotation Reference🧪ABAP Unit Test Generator🌐S/4HANA API Browser🎨SAP Fiori Color Palette📋ABAP Report Template Generator🔤ABAP Regex Tester⚙️SAP CPI iFlow Template Generator🗺️CDS Domain Model Visualizer⚡ABAP Performance Analyzer📐Fiori Elements Feature Matrix📚SAP RAP Quick Reference