Release Notes

August 2026

We've updated the following quickstart data model packages to add DuckDB as a supported destination:

We've made the following changes in v0.8.0:

• Fixed 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.

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

• We've made 7 schema/data changes in v0.8.0 (4 possible breaking changes):

  --full-refresh is required after upgrading.

  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.

April 2026

v0.7.0

Schema/Data Change

2 total changes • 0 breaking changes

March 2026

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.

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

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

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

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.