Master · governed
Product / Article Master
88
Current Variant Articles
IsCurrent=1
29
Generic Articles
brand × flavour
352
Article-UOM Rows
EA·PK1·PK2·PLT
108
Total Rows (incl. history)
20 SCD2-versioned
Generic → Variant → UOM → Barcode (SAP retail article)
Merchandise Hierarchy → Generic Article → Variant Article (SAPArticleNumber) → Article-UOM (EA/PK1/PK2/PLT) → Barcode (EAN-13 / GTIN-14 / SSCC)
Sample of current variant articles
| SAP # | Variant Article | Brand | Flavour | Sugar |
|---|---|---|---|---|
| 100000001 | Coca-Cola Original 330ml Can | Coca-Cola | Cola | Regular |
| 100000002 | Coca-Cola Original 500ml PET | Coca-Cola | Cola | Regular |
| 100000004 | Coca-Cola Original 2L PET | Coca-Cola | Cola | Regular |
| 100000006 | Sprite Original 1L PET | Sprite | Lemon Lime | Regular |
| 100000008 | Stoney Ginger Beer 1L PET | Stoney | Ginger Beer | Regular |
| 100000011 | Powerade Berry Ice 500ml PET | Powerade | Berry Ice | Regular |
| 100000012 | Costa Coffee Latte 250ml Can | Costa | Latte | Regular |
Master · governed
Brands & Merchandise Hierarchy
14
Brands
cleaned from 39 spellings
6
Product Categories
CSD·Water·Juice·…
14
Merch Hierarchy Nodes
5-level SAP
4
Package Types
CAN·PET·GLASS·TETRA
5-level merchandise hierarchy
Division BEV — Beverages
↳ Department SOFT — Soft Drinks
↳ Category CSD — Carbonated Drinks
↳ SubCategory COLA — Cola
↳ Segment COCA — Coca-Cola
↳ Department SOFT — Soft Drinks
↳ Category CSD — Carbonated Drinks
↳ SubCategory COLA — Cola
↳ Segment COCA — Coca-Cola
Each generic article hangs off one hierarchy node; the hierarchy drives merchandising, range & planogram reporting.
Brand portfolio
| Brand | Owner | Type |
|---|---|---|
| Coca-Cola | TCCC | Carbonated |
| Sprite | TCCC | Carbonated |
| Fanta | TCCC | Carbonated |
| Stoney | TCCC | Carbonated |
| Schweppes | TCCC | Carbonated |
| Bonaqua / Valpre | TCCC | Water |
| Powerade | TCCC | Sports |
| Powerplay / Monster | TCCC / Monster | Energy |
| Minute Maid / Cappy | TCCC | Juice |
Master · governed
Units of Measure & Packaging
Bulk-selling rule — PenBev does not sell loose units
The consumer EA (each) exists only so a single bottle can be scanned at retail — it is
IsSellable=1, IsOrderable=0. Trade orders are placed in cases (PK2) and pallets (PLT). Every sales/inventory fact is therefore in a bulk UoM, and EA appears only on the shelf-edge barcode.| UoM | Description | Conv → EA | Sellable | Orderable | Warehouse |
|---|---|---|---|---|---|
| EA | Each sellable unit (scan only) | 1 | YES | no | no |
| PK1 | Inner pack / shrink pack | 6 | no | YES | YES |
| PK2 | Outer case (primary order unit) | 24 | no | YES | YES |
| PLT | Pallet | 1,440 | no | YES | YES |
Conversions vary by pack size (e.g. a 2L case = 6 EA, a 330ml case = 24 EA). Each UoM row carries gross/net weight, volume in litres and physical dimensions (H×W×D cm) for load planning.
Master · governed
Barcodes & GS1
352
Barcodes
one per article-UOM
88
EAN-13
consumer EA
176
GTIN-14
PK1 / PK2 cases
88
SSCC
pallets
GS1 structure
| Type | GTIN | Prefix |
|---|---|---|
| EAN-13 | 6001000000018 | 6001000 |
| GTIN-14 | 16001000000015 | 6001000 |
| GTIN-14 | 26001000000012 | 6001000 |
| SSCC | 36001000000019 | 6001000 |
Packaging indicator (1=inner, 2=case, 3=pallet) prefixes the company GTIN; check digit is mod-10.
Integrity (resolved in pipeline)
Collisions live in the dirty source; the governed master stays clean. Detection recall vs injected truth = 100%. See the Health dashboard → Barcodes.
Master · governed
Customers
1,206
Current Customers
Western Cape trade
60
SCD2-Versioned
credit / channel moves
4
Channels
MT·Conv·WS·Informal
~7%
Inactive Flagged
IsActive=0
Customers by channel
By customer type
Each customer carries credit limit, geo-coordinates and an active flag; changes are tracked as SCD2 history.
Master · governed
Distribution Network
4
Sites
DC · plant · cross-dock · depot
6
Routes
Western Cape regions
7
Trucks
rigid · artic · urban
Sites
| Site | Type | City | Pallets |
|---|---|---|---|
| Parow Distribution Centre | DC | Parow | 18,000 |
| Athlone Production Plant | Plant | Cape Town | 12,000 |
| Epping Cross Dock | Cross Dock | Epping | 6,000 |
| George Depot | Depot | George | 3,000 |
Routes
| Route | Region | km | Hrs |
|---|---|---|---|
| Parow → Northern Suburbs | Northern Sub. | 45.5 | 3.2 |
| Parow → Cape Town CBD | CBD | 32.0 | 2.8 |
| Parow → Southern Suburbs | Southern Sub. | 58.7 | 4.1 |
| Epping → West Coast | West Coast | 88.0 | 5.0 |
| George Garden Route | Garden Route | 110.0 | 5.5 |
Master · governed
Pricing (with history)
528
Price Rows
per orderable UOM
2
Price Epochs
2025 → 2026 list
+8.7%
List Increase
2025 → 2026
National list price — sample (ZAR ex-VAT, 2026)
| Variant Article | UoM | Cost | Wholesale | RRP |
|---|---|---|---|---|
| Coca-Cola Original 330ml Can | PK2 | 43.56 | 57.02 | 79.12 |
| Coca-Cola Original 330ml Can | PLT | 4,356.00 | 5,702.40 | 7,912.08 |
| Coca-Cola Original 500ml PET | PK2 | 66.00 | 86.40 | 119.88 |
| Coca-Cola Original 1L PET | PK2 | 66.00 | 86.40 | 119.88 |
Pricing is held at orderable-UoM level with
EffectiveFromDate / EffectiveToDate — the 2025 list is expired and the 2026 list is current, so historical orders re-price correctly.Master · governed
SCD Type-2 History
20
Versioned Variants
pack / shelf-edge change
60
Versioned Customers
credit / channel change
2
Price Epochs
list-price history
Variant article version history (example)
| Variant Code | Shelf-Edge Label | Effective From | Effective To | Version | Current |
|---|---|---|---|---|---|
| VA-COCA-ZERO-1L-PET | 1 litre PET | 2022-01-01 | 2025-06-30 | 1 | no |
| VA-COCA-ZERO-1L-PET | 1 litre PET (NEW) | 2025-07-01 | — | 2 | YES |
| VA-MONSTER-ORG-500-CAN | 500ml Can | 2022-01-01 | 2025-06-30 | 1 | no |
| VA-MONSTER-ORG-500-CAN | 500ml Can (NEW) | 2025-07-01 | — | 2 | YES |
A change expires the current row (
EffectiveTo, IsCurrent=0) and inserts a new version with a fresh surrogate key. Facts join on the surrogate key, so a 2024 sale reflects the attributes as they were then.Transactional · high-volume
Sales
2.31M
Clean Sales Lines
of 2.52M raw
R28.4b
Revenue ex-VAT
2024–2026 demo span
R17.4b
Cases (PK2)
~61% of revenue
R11.0b
Pallets (PLT)
~39% of revenue
Revenue by channel (R bn)
Revenue by brand (R bn)
Revenue by category (R bn)
Transactional · high-volume
Inventory
48,640
Snapshot Rows
site × SKU × day
4
Sites Tracked
DC·plant·xdock·depot
3-day
Snapshot Cadence
2024–2026
opening+recv−sold−damaged
Closing Identity
balance check
Inventory model
Each snapshot carries opening, received, sold and damaged quantities in cases (PK2), with a derived closing balance, its EA equivalent (via
ConversionToEA) and an ex-VAT stock value from the current price. Negative or imbalanced closings are flagged in the quality layer.Transactional · high-volume
Logistics / Delivery
59,681
Delivery Lines
2024–2026
14.9%
Late Deliveries
LateDeliveryFlag=1
50%
Delivered In Full
vs partial / failed
~60
Cases / Pallet
load conversion
Delivery status mix
Each line links customer · site · route · truck, with start/end timestamps and fuel cost — feeding on-time-in-full (OTIF) and cost-to-serve.
Transactional · high-volume
Production
2,744
Production Batches
Athlone plant
R47.4m
Total Cost of Production
material+labour+OH
R17.5k
Avg Batch Cost
blended
EA out
Batch Yield
→ stock receipts
Cost build-up (R m)
Each batch consumes ingredients per its bill of materials and absorbs labour + plant overhead, giving a fully-costed cost-per-litre that links manufacturing to the BOM and expense layers.
Transactional · high-volume
Ingredients / Bill of Materials
21,952
BOM Lines
batch × ingredient
8
Ingredients
sugar → preservative
R36.0m
Ingredient Spend
material cost
Ingredient spend (R m)
Transactional · high-volume
Operating Expenses
1,152
Expense Postings
cost centre × period
R19.7m
Total Opex
demo period
9
Cost Centres
fleet → lab