Overview
The SAP Skills Portal and SAP Specialist Cockpit is the central hub for all automated data generators and system administration tools built for the Fivetran SAP Specialist Team.
What Is This?
A suite of Java programs that generate realistic, end-to-end business process data across SAP S/4HANA 2023. Each skill covers a complete business workflow — from master data creation through document posting — and includes:
| Java programs | Standalone executables connecting to SAP via JCo RFC |
| Claude Code skills | AI-assisted operation via /skill-name commands |
| HTML documentation | Comprehensive docs hosted on the portal |
| GitHub repositories | Source code under the fivetran organization |
Portal Status
| URL | Live |
| Server | sapidesecc8 |
| Auto-restart | Enabled |
| Auth required | No (public) |
Quick Links
| Datalake Reader | datalake_reader/ |
| Management Cockpit | SAP Management Cockpit |
| Service Monitor | SAP Service Monitor |
| Fivetran Connector | To be available soon |
| HVR Channels | To be available soon |
Skills Catalog
Six business process skills covering the full SAP S/4HANA lifecycle.
Order to Cash (OTC)
Sales & Distribution
Customer master, sales order, delivery, picking, packing, goods issue (PGI), billing, and accounting entry.
Procure to Pay (P2P)
Materials Management
Vendor master, purchase requisition, purchase order, goods receipt (MIGO), invoice receipt (MIRO), and payment.
Plan to Produce (PP)
Production Planning
BOM, routing, production order, goods issue to production (261), confirmation, and goods receipt (101).
Material Requirements Planning
Supply Chain Planning
MRP run (MD01/MD02), planned order creation, conversion to production/purchase orders, stock/requirements analysis.
Housekeeping & Job Scheduler
System Administration
MM period opening, FI period monitoring, Material Ledger extension, number range tracking via XBP BAPIs.
CDS View Extraction
Metadata & SQL Translation
8-phase pipeline: dependency resolution, metadata extraction, SQL definitions, HANA-to-ANSI SQL translation.
GCS Parquet Explorer
Datalake Reader & Iceberg
Web app for browsing and querying SAP CDS Parquet data across GCS, Azure Data Lake, and AWS S3 with DuckDB SQL engine.
Skills Portal
Server & Documentation
Web server administration, backup & disaster recovery, SSL certificates, systemd resilience, and scheduled backups for the SAP Skills Portal.
Management Cockpit
System Landscape & Operations
Centralized dashboard for the full SAP landscape: servers, connections, databases, credentials, data generators, monitoring, and quick reference commands.
Skills Summary
| Skill | Process Area | Key SAP Transactions | GitHub |
|---|---|---|---|
| OTC | Sales & Distribution | VA01, VL01N, VL02N, VF01 | sap-otc-workflow |
| P2P | Materials Management | ME21N, MIGO, MIRO, F-53 | sap-ptp-generator |
| PP | Production Planning | CS01, CA01, CO01, CO11N | PlanToProduce |
| MRP | Supply Chain Planning | MD01, MD02, MD04, MD05 | MaterialRequirementsPlanning |
| Housekeeping | System Administration | MMPV, SM37, SNRO, CKMLCR | SAPHousekeeping |
| CDS | Metadata Extraction | SE11, DDIC, SE80 | CDS-metadata-retrieval |
| GCS Explorer | Datalake Reader | DuckDB, PyArrow, Polaris | gcs-parquet-explorer |
| Skills Portal | Server & Docs | systemd, cron, gsutil, ZeroSSL | SAPSkillsPortal |
| Cockpit | System Landscape | Servers, DBs, Credentials, Monitoring | — |
Architecture
How the portal and all business process skills connect to SAP S/4HANA.
Web Portal
SAP Skills Portal & Cockpit
sapidesecc8:443
sapidesecc8:443
GCS Parquet Explorer
sapidesecc8:443
sapidesecc8:443
↓
Local Mac (Java + JCo RFC)
OTC Generator
P2P Generator
PP Generator
MRP Generator
Housekeeping
↓ JCo RFC (port 3303)
SAP S/4HANA 2023
sapidess4
SYSNR 03 • Client 100
SYSNR 03 • Client 100
HANA DB (FIV)
Port 30015 via SSH tunnel
Port 30015 via SSH tunnel
Troubleshooting
Common issues and their fixes.
| Issue | Fix |
|---|---|
| Portal returns 404 | Check /sap_skills/ route exists in gcs_explorer_server.py _do_GET() |
| Server not running | ssh root@sapidesecc8 "systemctl restart gcs-explorer" |
| Doc page not loading | Verify file exists: ssh root@sapidesecc8 "ls /usr/sap/sap_skills/docs/" |
| After server.py update | Re-add /sap_skills/ route block to _do_GET() |
| SSL certificate warning | Expected — self-signed cert at /usr/sap/gcs_explorer_cert.pem |
| Changes not visible | Files served from disk — no cache, no restart needed. Hard-refresh browser. |
| Service won't start | Check syntax: python3 -c "compile(open('/usr/sap/gcs_explorer_server.py').read(), 's', 'exec')" |