Release Notes

August 2026

v0.8.0

Schema/Data Change (--full-refresh required after upgrading)

7 total changes • 4 breaking changes

Data Model(s)	Change type	Old	New	Notes
Breaking: All `compatibility_views` models	Schema	`<target_schema>` `_sap_comp_views`	`<target_schema>` `_sap`	Any downstream queries, BI tools, or other dbt projects that reference these models by their old schema will grow stale until updated to point at the new schema.
Breaking: All `stg_sap__*` staging models	Schema	`<target_schema>` `_sap`	`<target_schema>` `_sap_source`	Same as above.
Breaking: All `stg_sap__*` staging models	Row filter	All rows included	Soft-deleted rows are excluded	Removes deleted rows in staging and downstream so aggregations (for example `mchb.clabs`) are calculated from active records only.
Breaking: All `stg_sap__*` staging models `sap__0material_attr` `sap__fact_sales_order` `int_sap__0fi_gl_10_sums`	Removed field	`_fivetran_deleted`		Removes column from every model's output. The delete filter above still runs internally against the source column, so the output column would only ever read `false`. Removing it avoids persisting a column that can no longer carry information.
`faglflext` `anep` `anlp`	New Compatibility Views			Adds three new compatibility views: General Ledger Totals (`faglflext`, needs `ACDOCA`, `FINSC_LD_CMP`, `FINSC_LEDGER_REP` tables to run), Asset Line Items (`anep`, needs `ACDOCA`, `FINSC_LD_CMP`, `FINSC_LEDGER_REP` tables to run), and Asset Periodic Values (`anlp`, needs `FAAT_PLAN_VALUES` table + optional `ANLA` table for fixed asset dimensions).
`stg_sap__anla` `stg_sap__faat_plan_values`	New Staging/Tmp Models			Adds two new staging models (with corresponding `_tmp` models) supporting the `anlp` compatibility view: Asset Master (`ANLA`) and Asset Accounting Planned Values (`FAAT_PLAN_VALUES`).
`stg_sap__acdoca`	New Columns		`afabe`, `anlgr`, `anlgr2`, `anln1`, `anln2`, `anbwa`, `awitgrp`, `awitem`, `bzdat`, `movcat`, `prec_awref`, `slalittype`, `subta`, `subta_rev`, `vorgn`, `xreversed`, `xreversing`, `xsettled`, `xsettling`	Adds 19 new asset-accounting columns used to build the `anep` and `faglflext` compatibility views.

Bug Fix

Fixes case-sensitive string comparisons in coss.sql (the field-name-to-column dispatch logic, and the set_to_zero/xcoss/mig_source/bstat/accasty filters) and faglflexa.sql (the bstat filter) that compared against lowercase literals while the underlying SAP data uses uppercase codes. This caused rows to be silently dropped or amount fields to incorrectly fall through to 0.

Documentation

Splits the staging and compatibility view YAML doc files into one file per model (previously grouped together), and simplifies the source YAML by removing redundant column-level documentation. Makes the docs easier to navigate for both humans and AI coding agents.

v0.8.1

Feature Updates

Adds DuckDB as a supported destination.

April 2026

v0.7.0

Schema/Data Change

2 total changes • 0 breaking changes

Data Model(s)	Change type	Old	New	Notes
`bsak`	New Compatibility View			Vendor Line Items Cleared/Archived - provides cleared and archived vendor payables, combining archived records from `BSAK_BCK` with cleared records derived from `BSEG`/`BKPF`
`stg_sap__bsak_bck`	New Staging Model			Vendor Line Items archived backup staging model with vendor-specific fields including purchase order references (`ebeln`, `ebelp`), customs (`zollt`, `zolld`), withholding tax detail (`qsshb`, `qbshb`, `qsznr`, `qsfbt`), and penalty fields (`penlc1-3`, `penfc`, `penrc`)

March 2026

v0.6.2

Documentation

Adds missing, removes stale, and corrects column-level descriptions for the following models:
- marc
- mchb
- mkpf
- mseg
- sap__0fi_gl_14
- sap__0material_attr
- stg_sap__bseg
- stg_sap__dd07l
- stg_sap__dd07t
- stg_sap__marc
- stg_sap__mchb
- stg_sap__mchp

v0.6.3

Bug Fix

Fixes a SQL compilation error on BigQuery in the bsid and bsad models to cast _dataaging to string to avoid datatype failures, ensuring consistent types regardless of how the source column is synced.

February 2026

v0.6.1

Bug Fix

Fixes potential SQL compilation errors in sap__fact_sales_order and sap__fact_purchasing_order models caused by trailing commas when certain source table variables are disabled. These models now use leading comma formatting for all conditional field selections, ensuring successful compilation regardless of which sap_using_* variables are enabled or disabled.

January 2026

v0.6.0

Schema/Data Change

15 total changes • 0 breaking changes

Data Model(s)	Change type	New	Notes
`bsad`	New Compatibility View		Customer Line Items Cleared/Archived - provides cleared and archived customer receivables
`bsid`	New Compatibility View		Customer Line Items - provides open customer receivables and line item data
`coep`	New Compatibility View		Controlling Object Line Items - provides detailed line item data for controlling documents
`cosp`	New Compatibility View		Cost Object Line Items Summary - provides period-wise cost and quantity data for cost objects
`stg_sap__t006`	New Staging Model		Unit of Measure staging model with 26 fields for currency and unit conversions
`stg_sap__cosp_bak`	New Staging Model		Cost Object Line Items archive staging model with 154+ fields including period-based amounts
`stg_sap__bsad_bck`	New Staging Model		Customer Line Items archived backup staging model
`stg_sap__coep`	New Staging Model		Controlling Object Line Items staging model
`stg_sap__prps`	New Staging Model		Project System data staging model
`stg_sap__bseg`	New Columns	Tax & Localization: `tax_country`, `tax_country1`, `tax_country2`, `tax_country3`, `hist_tax_factor`, `hist_tax_factor1`, `hist_tax_factor2`, `hist_tax_factor3`, `txdat_from`, `txdat_from1`, `txdat_from2`, `txdat_from3` Accounts & Budgeting: `gkont`, `gkart`, `bdgt_account`, `ghkon` Payments & Currency: `payt_rsn`, `rfccur`, `fcsl`, `lwsts` Document & Processing Attributes: `_dataaging`, `buzei_sender`, `h_bstat`	Added 23 new columns for enhanced tax handling, budget accounting, and payment processing
`stg_sap__acdoca`	New Columns	Assignments & References: `accas`, `paccas`, `co_accasty_n1`, `co_accasty_n2`, `co_accasty_n3`, `aworg`, `awref`, `co_refbz`, `co_refbz1`, `co_refbz2`, `co_refbz5`, `co_refbz6`, `co_refbz7`, `co_zlenr`, `logsysp`, `scope`, `pscope` Orders, Projects & Objects: `aufnr`, `autyp`, `paufnr`, `pautyp`, `objnr_hk`, `paobjnr`, `ppaobjnr`, `xpaobjnr_co_rel`, `ps_posid`, `ps_pspid`, `pps_posid`, `pps_pspid`, `qmnum` Commercial Documents: `ebeln`, `ebelp`, `zekkn`, `kdauf`, `kdpos`, `pkdauf`, `pkdpos` Materials, Plants & Resources: `matnr`, `werks`, `lstar`, `plstar`, `pernr` Quantities & Currencies: `quant1`, `quant2`, `quant3`, `qunit1`, `qunit2`, `qunit3`, `rbcur`, `rccur`, `rdcur`, `recur`, `rgcur` Additional Attributes: `bwstrat`, `dabrz`, `erkrs`, `erlkz`, `gkoar`, `gkont`, `pbukrs`, `prodper`, `rbest`, `sgtxt`, `xsplitmod`	Added 64 new columns for controlling area assignments, cost objects, purchasing documents, and project system integration
`stg_sap__bkpf`	New Columns	`belnr_sender`, `bukrs_sender`, `gjahr_sender`, `logsystem_sender`	Added 4 new sender-related columns for document traceability
`stg_sap__finsc_cmp_versnd`	New Columns	`field_name_refbz`	Added reference number field handling
`stg_sap__tj01`	New Columns	`wtkat`	Added value category for enhanced system status classification
`stg_sap__tka01`	New Columns	`xwbuk`	Added cross-company code posting indicator

Documentation

Updates README with standardized Fivetran formatting.

Under the Hood

Creates the following compatibility view intermediate models to handle complex transformations:
- COEP: int_coep__acdoca_base, int_coep__acdoca_calculated, int_coep__acdoca_aggregated, int_coep__acdoca_final, int_coep__original
- COSP: int_cosp__acdoca_base, int_cosp__acdoca_amounts, int_cosp__acdoca_timestamp, int_cosp__coep_derived, int_cosp__acdoca_derived
Adds new enable/disable variables for all new staging tables: sap_using_t006, sap_using_cosp_bak, sap_using_bsad_bck, sap_using_coep, sap_using_prps
Enhances remove_slashes_from_col_names macro to support database reserved words handling by adding reserved_word_list parameter, ensuring proper quoting for columns that are reserved keywords

December 2025

v0.5.0

Features

Increases the required dbt version upper limit to v3.0.0

v0.5.1

Under the Hood

Removes redundant sales_and_procurement_mandt_var filter from sales and procurement intermediate models, as the SAP client filtering is already applied at the Fivetran connector level during data extraction. See the "Configure Fivetran in SAP" section of the Fivetran SAP ERP on HANA Setup Guide instructions for more details.
Removes sales_and_procurement_mandt_var variable documentation from README.

September 2025

v0.4.0

Feature and Schema/Data Changes

Introduced 6 new compatibility view models that replicate the structure and data of native SAP tables, enabling seamless migration and integration for existing SAP-based processes and reports. Additionally, added support for new upstream staging models used to support the compatibility view end models.

38 total changes • 0 possible breaking changes

Data Model(s)	Change type	Notes
`coss`	New model	Cost Object Summary (COSS) compatibility view - Provides period-wise cost and quantity data for cost objects from controlling documents.
`faglflexa`	New model	Financial General Ledger Line Items (FAGLFLEXA) compatibility view - Provides detailed line item data from financial accounting documents.
`marc`	New model	Material Master Plant Data (MARC) compatibility view - Contains plant-specific material master data including MRP, procurement, and stock information.
`mchb`	New model	Batch Stocks (MCHB) compatibility view - Contains batch-specific stock quantities and valuations for each material and storage location.
`mkpf`	New model	Material Document Header (MKPF) compatibility view - Contains header-level information for material documents from goods movements.
`mseg`	New model	Material Document Line Items (MSEG) compatibility view - Contains detailed line item information for all material movement transactions.
`stg_sap__acdoca`	New model	Staging model for universal journal entries (`acdoca`).
`stg_sap__finsc_cmp_versnd`	New model	Staging model for financial component version send (`finsc_cmp_versnd`).
`stg_sap__finsc_ld_cmp`	New model	Staging model for financial ledger component (`finsc_ld_cmp`).
`stg_sap__finsc_ledger_rep`	New model	Staging model for financial ledger reports (`finsc_ledger_rep`).
`stg_sap__marc`	New model	Staging model for material master plant data (`marc`).
`stg_sap__matdoc`	New model	Staging model for material documents (`matdoc`).
`stg_sap__matdoc_extract`	New model	Staging model for material document extracts (`matdoc_extract`).
`stg_sap__mchb`	New model	Staging model for batch stocks (`mchb`).
`stg_sap__mchp`	New model	Staging model for batch period stocks (`mchp`).
`stg_sap__sapsll_clsnr`	New model	Staging model for SAP special ledger country codes (`sapsll_clsnr`).
`stg_sap__sapsll_maritc`	New model	Staging model for SAP special ledger material codes (`sapsll_maritc`).
`stg_sap__sapsll_nosca`	New model	Staging model for SAP special ledger scale categories (`sapsll_nosca`).
`stg_sap__sapsll_tunos`	New model	Staging model for SAP special ledger scale numbers (`sapsll_tunos`).
`stg_sap__t000`	New model	Staging model for clients (`t000`).
`stg_sap__tj01`	New model	Staging model for system statuses (`tj01`).
`stg_sap__tka01`	New model	Staging model for controlling areas (`tka01`).
`stg_sap__acdoca_tmp`	New model	Temporary staging model for universal journal entries (`acdoca`).
`stg_sap__finsc_cmp_versnd_tmp`	New model	Temporary staging model for financial component version send (`finsc_cmp_versnd`).
`stg_sap__finsc_ld_cmp_tmp`	New model	Temporary staging model for financial ledger component (`finsc_ld_cmp`).
`stg_sap__finsc_ledger_rep_tmp`	New model	Temporary staging model for financial ledger reports (`finsc_ledger_rep`).
`stg_sap__marc_tmp`	New model	Temporary staging model for material master plant data (`marc`).
`stg_sap__matdoc_tmp`	New model	Temporary staging model for material documents (`matdoc`).
`stg_sap__matdoc_extract_tmp`	New model	Temporary staging model for material document extracts (`matdoc_extract`).
`stg_sap__mchb_tmp`	New model	Temporary staging model for batch stocks (`mchb`).
`stg_sap__mchp_tmp`	New model	Temporary staging model for batch period stocks (`mchp`).
`stg_sap__sapsll_clsnr_tmp`	New model	Temporary staging model for SAP special ledger country codes (`sapsll_clsnr`).
`stg_sap__sapsll_maritc_tmp`	New model	Temporary staging model for SAP special ledger material codes (`sapsll_maritc`).
`stg_sap__sapsll_nosca_tmp`	New model	Temporary staging model for SAP special ledger scale categories (`sapsll_nosca`).
`stg_sap__sapsll_tunos_tmp`	New model	Temporary staging model for SAP special ledger scale numbers (`sapsll_tunos`).
`stg_sap__t000_tmp`	New model	Temporary staging model for clients (`t000`).
`stg_sap__tj01_tmp`	New model	Temporary staging model for system statuses (`tj01`).
`stg_sap__tka01_tmp`	New model	Temporary staging model for controlling areas (`tka01`).

Under the Hood

Updated quickstart.yml to include all new staging model variables with proper uppercase source table names.
Added all compatibility view models to the public_models configuration in quickstart.yml.
Updated README documentation with new "Compatibility Views" section detailing all compatibility view models.
Added 16 new get_*_columns macro files to support the new staging models.
Created integration test seed files for all new staging models.
Enhanced src_sap.yml and stg_sap.yml with documentation for new source tables and staging models.