SAP Dictionary for VS Code

Instant SAP table and field descriptions in VS Code — hover over any SAP identifier to see what it means.

Works offline. No SAP connection required. Bundled with 674 standard tables and views (16,700+ fields) covering ABAP (FI/MM/SD/HR/Basis) and SAP HANA System/Monitoring Views.

Features

Hover Tooltips — hover over SAP table or field names in .abap, .sql, .hdbview, .hdbtable, .hdbprocedure, .hdbcalculationview files.

MATNR · MARA
Material Number

Type: `CHAR`  Length: 18
Data Element: `MATNR`

Sidebar Panel — browse and search all 674 tables and 16,700+ fields. Fuzzy search matches table names, field names, and descriptions (mar matches MARA, MARC, MARD…). Searching by field name surfaces matching fields directly in the results.

Import Your System's Metadata — import one or more JSON exports from your SAP system to add Z-tables and team-specific descriptions. Imported files are listed in the sidebar individually and can be removed one at a time. Your data takes priority over the bundled data.

Quick Start

1. Install the extension
2. Open any .abap or .sql file
3. Hover over an uppercase identifier like MARA, VBAK, or M_ACTIVE_STATEMENTS

Bundled Coverage

Import Your System's Metadata

Click Import System Metadata in the sidebar, or run SAP Dictionary: Import System Data (JSON) from the command palette, and select a JSON file.

You can import multiple files. Each appears as a separate entry in the sidebar — remove any one without affecting the others.

JSON Format

The top-level structure must have a tables object. Everything else is optional.

{
  "exported_at": "2026-05-11T00:00:00Z",
  "system": "PRD",
  "tables": {
    "ZTABLE_NAME": {
      "description": "Human-readable table description",
      "fields": {
        "FIELD_NAME": {
          "description": "Human-readable field description",
          "type": "CHAR",
          "length": 20,
          "is_key": true,
          "data_element": "ZFIELD_NAME_DE"
        }
      }
    }
  }
}

Top-level fields

Table definition

Field definition

Table and field names are case-insensitive on import (stored and matched in uppercase).

If you import a file that overlaps with a previously imported file, the later import wins on a per-field basis.

Minimal valid example

{
  "tables": {
    "ZORDERS": {
      "description": "Custom Sales Orders",
      "fields": {
        "ORDER_ID": { "description": "Order Number" },
        "STATUS":   { "description": "Order Status" }
      }
    }
  }
}

Export Methods

Option A — HANA SQL (for HANA-native tables):

SELECT table_name, column_name, data_type_name, length, comments
FROM sys.table_columns
WHERE schema_name = 'YOUR_SCHEMA'
ORDER BY table_name, position;

Option B — ABAP SQL Console / ADT (for ABAP Dictionary):

SELECT d~tabname, t~ddtext AS table_desc,
       d~fieldname, d~position, d~datatype, d~leng,
       COALESCE(f~ddtext, e~ddtext) AS field_desc
  FROM dd03l AS d
  LEFT JOIN dd02t AS t ON t~tabname = d~tabname AND t~ddlanguage = 'E'
  LEFT JOIN dd03t AS f ON f~tabname = d~tabname AND f~fieldname = d~fieldname AND f~ddlanguage = 'E'
  LEFT JOIN dd04t AS e ON e~rollname = d~rollname AND e~ddlanguage = 'E'
  WHERE d~tabname LIKE 'Z%'
    AND d~fieldname NOT LIKE '.%'
  ORDER BY d~tabname, d~position.

Convert the query output to the JSON format above and import via the sidebar button.

Commands

Supported File Types

.abap · .sql · .hdbview · .hdbcalculationview · .hdbtable · .hdbprocedure

Missing Descriptions?

If your Z-tables show "Not found in SAP Dictionary" or "No description available", import your system's metadata (see above).

Z-tables with no descriptions at all? Every SAP project has them — the 50-200 custom tables that only one person on the team truly understands. If that knowledge lives in someone's head instead of your codebase, you have a bigger problem than a missing tooltip.

→ Rosetta automatically builds a searchable knowledge base for your entire data stack — Z-tables, custom fields, business logic, dbt models. Early access is open.

Built by Rosetta — Knowledge Indexing for Data Teams

SAP, ABAP, and SAP HANA are trademarks of SAP SE. This extension is not affiliated with or endorsed by SAP SE.