Skip to content

A resource library for supply chain analytics teams.

Tools, references, and frameworks built by practitioners. Free to use. Shaped by real enterprise consulting engagements.

A working entry, not a screenshot.

This is MARC (plant data for material), pulled straight from the SAP Reference Database. The same fields, S/4HANA status, and copy-ready SQL you’ll find on every entry inside. No signup on the other side of the link; the library is simply open.

  • 148tables with field-level detail
  • 82transaction codes mapped to their backing tables
  • 11modules, from MM to EWM

Explore the SAP Reference →

MARCPlant Data for MaterialMMmasterS/4HANA status: Active
Key fields of table MARC
FieldDescriptionTypeKey
MANDTClientCLNT (3)Key
MATNRMaterial NumberCHAR (18)Key
WERKSPlantCHAR (4)Key
DISMMMRP TypeCHAR (2)
DISPOMRP ControllerCHAR (3)
PLIFZPlanned Delivery Time in DaysDEC (3)
-- Material master joined to plant-level planning data
SELECT
  mara.MATNR  AS material,
  marc.WERKS  AS plant,
  marc.DISMM  AS mrp_type,
  marc.DISPO  AS mrp_controller,
  marc.PLIFZ  AS planned_delivery_days
FROM <catalog>.<schema>.MARA AS mara
JOIN <catalog>.<schema>.MARC AS marc
  ON marc.MATNR = mara.MATNR
WHERE marc.WERKS = '<WERKS>'

On the shelf today

Everything is free and ungated. The shelf grows as the practice turns engagement work into public references.

FlagshipTool

SAP Reference Database

Searchable reference for SAP tables, transaction codes, fields, and relationships across 11 modules — with S/4HANA simplification tracking and a 1-hop relationship graph on every table.

Module coverage

  • APO
  • CO
  • EWM
  • FI
  • LE
  • MM
  • ORG
  • PP
  • QM
  • SD
  • WM
Reference

Dashboard Layout Patterns

Six proven dashboard layout patterns with annotated wireframes.

ToolIn development

Architecture Builder

Interactive builder for medallion lakehouse architectures, with export to a shareable diagram.

Shaped by real work.

Analytics investments stick when the people building them understand the supply chain, not just the tools.

Nothing here started as content. Every reference in the library came out of enterprise consulting engagements — supply chains where exactly that gap was the problem, until someone got hands-on with both the business and the data.

The practice builds on Databricks and stays engaged through implementation, which is why the references read like working notes rather than vendor collateral. Consulting availability is selective; the library is how the work becomes public.

Industries
MedTech, consumer goods, footwear, manufacturing
Platform
Databricks — Unity Catalog, Delta Lake, AI/BI dashboards
Method
Medallion architecture into Kimball-style dimensional gold

Working on a supply chain analytics challenge?

Consulting availability is selective, but every inquiry is read and answered. Tell us what you’re working on.

Start a conversation →