SAP Reference Data

Current reference data and Excel template used by SSP Enrichment.

Back to Enrichment

PIR

File: PIRexport.xlsx
Uploaded: 2026-09-15 13:33
Age: 32 day(s)
Status: Update recommended
Rows read: 481665
Clean helper rows: 13007
Duplicates collapsed: 450663
Skipped: 17995

Article/SOrg

File: Article_SOrg.xlsx
Uploaded: 2026-10-09 13:09
Age: 8 day(s)
Status: Update recommended
SAP articles: 16323
Substance crossrefs: Substance helper rows: 15834

Recipe Master

File: Recipes_v2_PRD.xlsx
Uploaded: 2026-10-09 13:09
Status: Current
Rows read: 22906
Recipes imported: 3607
Component rows: 14850
Skipped rows: 4449

Used for Underoppskrift rows with no SAP article number. Previous imports remain in history.

Enrichment Template

Current file: SAP Enrichment Template_RECIPE CREATION_v10_BLANK.xlsx
Uploaded: 2026-09-15 13:36
Version / label: v10
Status: Current
Header sheet: 1. Recipe Name Header
Item sheet: 2. Recipe Name Item Detail
Lookup sheet: Hierarchies and Lookup

The uploaded workbook must contain:

1. Recipe Name Header
2. Recipe Name Item Detail
Hierarchies and Lookup

A new valid upload becomes the current template. Previous templates are kept in history.

Matching rule: Recipe Leverandør + Varenummer must match PIR Supplier (2) + Supplier Art. No.. The resulting SAP Article must also exist in the current Article/SOrg data.