← Back to Projects
Project 01 · SAP Migration
BW to Datasphere
Migration Tool
A full-stack SAP migration accelerator built for the 0IC_C03 inventory reporting landscape — converting BEx queries, ABAP transformation routines, and legacy extractors into live SAP Datasphere models and a five-page SAC dashboard. Everything automated with Claude Code prompts.
SAP Datasphere
SAP BW
SAC
HANA SQL
ABAP
SLT Replication
MM · WM · PP
Claude Code
The Problem
SAP BW migrations are slow, expensive, and under-documented.
Most companies spend weeks just analysing what they have — mapping BEx queries to InfoObjects, decoding ABAP transformation routines, tracing extractor dependencies — before a single object is built in Datasphere. When that analysis happens in slide decks and spreadsheets, it gets stale, incomplete, and impossible to reuse.
This tool changes that. Using Claude Code as the engine, I built a structured prompt library that walks the full migration lifecycle end-to-end — from BW object analysis through Datasphere modelling to SAC story design — producing ready-to-use SQL views, JSON replication configs, and test cases as output.
Scope
Full 0IC_C03 inventory landscape, migrated completely.
The tool covers SAP's standard inventory management content — the Inventory Management InfoCube (0IC_C03) with its full MM, WM, and PP extensions.
◈
BW Analysis
35 InfoObjects catalogued. 3 extractors (2LIS_03_BX/BF/UM) documented. ABAP routines decoded — stock expansion, sign-flip, fiscal period derivation.
◈
Data Replication
SLT replication config for 10 MM source tables (MARA, MSEG, MARD, MKPF, MBEW, MARC…). Partitioning strategy for 50M+ row MSEG table.
◈
Datasphere Models
SP_INVENTORY space with local tables, dimension views, two fact views, and three analytical models — Inventory, Warehouse, and Production Orders.
◈
ABAP Conversion
Start routines and end routines converted to HANA SQL. CMOD variable exits migrated to Datasphere input variables and JS-based date filters.
◈
SAC Story
Five-page Inventory Analytics Dashboard: Stock Overview, Goods Movements, Valuation, Warehouse Stock, and Production KPIs. 7 calculated measures, 10 restricted KFs.
◈
Testing & Validation
SQL validation queries, data quality monitors, routine validation tests, and a conversion completion checklist — all generated as reusable artefacts.
How It Was Built
22 structured Claude Code prompts, one complete migration.
Each prompt in the library maps to a real project phase. Running them in sequence produces a migration package — not a plan, but actual deliverables: SQL files, JSON configs, markdown docs, test cases, and a go-to-market deck.
01
BW Object Analysis
InfoCube structure, InfoObject catalogue, calculated and restricted KFs, BEx query variables, extractor documentation.
Prompts 1–5
02
Datasphere Space & Replication Setup
Space configuration checklist, SLT replication config JSON files for MM/WM/PP tables, delta and initial load strategy.
Prompts 6–8
03
Datasphere Modelling
Dimension views, fact views, analytical models for Inventory, Warehouse Stock, and Production Orders. Task chain configuration.
Prompts 9–13
04
ABAP CMOD Conversion
Audit of all ABAP routines. Conversion of start/end routines, expert routines, variable exits, and custom extractor fields to HANA SQL and Datasphere-native constructs.
Prompts 14–18
05
SAC Story, Testing & Documentation
Five-page SAC dashboard design, calculated measures, input controls, validation test cases, data quality SQL, and full migration completion report.
Prompts 19–22
Output Artefacts
Real files, not slides.
Every prompt produces files you can use directly — no copy-pasting from a PDF into a tool. The full output package includes:
SQL views and start-routine conversions · SLT replication JSON configs · Datasphere analytical model specs · SAC story design and calculated measures · ABAP audit and CMOD variable catalogue · Validation test cases and data quality queries · Dummy data CSVs for testing · Migration completion report · Go-to-market plan
Get in Touch
Using this for a client migration? Let's talk.
This accelerator was built from a real consulting engagement. If you're facing a BW-to-Datasphere migration and want to use this as a starting point — or hire me to run it for your landscape — reach out.