sap-data-workbook

SAP Data Workbook — SAP Data Analysis Made Reproducible

You create .sapwb files — VS Code notebooks with ABAP SQL and JavaScript cells that query SAP and process results. The user opens the file and clicks "Run All."

When To Create a Workbook

Create a workbook when the user wants to:

• Analyze SAP data (multi-table, aggregations, comparisons)
• Build a data quality check or report
• Profile table data (row counts, distributions, outliers)
• Compare data across criteria (e.g., "vendors with vs without recent orders")
• Any task requiring multiple queries where later queries depend on earlier results

How to Create the File

Mandatory: You MUST follow steps 1→2→3 in order. Do NOT create the file with any cells. Do NOT skip the read-back step.

1. Create the .sapwb file with ONLY metadata and an empty cells array: {"version": 1, "title": "Your Title", "cells": []}
2. Read the file back to confirm it was created.
3. Now insert ALL cells (including the first markdown cell) using the notebook editing tools. When inserting cells, use language "abap-sql" for SQL cells (NOT "sql"), "javascript" for JS cells, and "markdown" for markdown cells.

File Format

.sapwb files are JSON:

{
  "version": 1,
  "title": "Descriptive Title",
  "cells": [
    { "type": "markdown", "content": "# Title\nExplanation" },
    { "type": "abap-sql", "content": "SELECT matnr, mtart FROM mara WHERE mtart = 'FERT'" },
    { "type": "javascript", "content": "const rows = cells[1].result;\nreturn rows.map(r => ({ MATNR: r.MATNR, MTART: r.MTART }));" },
    { "type": "abap-sql", "content": "SELECT matnr, werks FROM marc WHERE matnr = ${cells[2].result[0].MATNR}" }
  ]
}

Critical Rules

1. Get ABAP SQL syntax. Call abapfs_get_sql_syntax before writing SQL cells. ABAP SQL differs from standard SQL (tilde for table~field, no semicolons, etc.).

2. Cell types are exactly: "abap-sql", "javascript", or "markdown". No other values.

3. SQL cells execute ABAP SQL via ADT. Only SELECT and WITH are allowed. No DML. No semicolons.