Reference library

The same library, entered from the question instead of the system. Every entry here has a full page of its own, and the numbered sections below index them by kind. Reference builds are working implementations of those definitions over simulated data — not client work, and no client named.

Table-level references for each ERP — fields, keys, relationships, and copyable SQL for every object.

Verified is the month a reference’s claims were last re-checked against vendor documentation — a different mark from the update dates above, and the two move independently.

Start from the business question, not the table — six guides that hold across every source system, then four written against SAP tables: the table set, the joins and their traps, the grain decision, extraction into Databricks, and working SQL. G, K and D are library numbers — a SAP modeling guide, a metric, a dashboard pattern — each kind indexed in order in this section and the two below.

Supply chain metrics defined as the decisions they actually are. Each entry makes every decision switch explicit and maps the source tables across the ERP references.

Built on the dictionary

How a dashboard is composed before anything is plotted on it — the six generic layouts, what each one is for, and the research each cites.

Layout reference