Skip to Content

BMD Bronze Lakehouse

Version 1.1 by Dimitri Rupp on 2026/06/11 09:16
Warning
For security reasons, the document is displayed in restricted mode as it is not the current version. There may be differences and errors due to this.
On this page

BMD Bronze Lakehouse

Information

Source system: BMD ERP — Financial / Accounting Data Warehouse
Stage: Bronze (raw landing zone)
Owner: Fabric team (restricted access)

Overview

📋 WhatTables from the BMD Data Warehouse. Acts as the landing zone for all BMD-related data. No transformations are carried out here.
🔄 HowData is copied via Fabric Data Pipelines.
🔐 WhoAccess is restricted to the Fabric team.

Orchestration

PropertyValue
🛠️ ToolFabric Data Pipeline
🆔 Pipeline namegetBMDDWH
ℹ️ FunctionCopy data from BMD DWH to bmd_bronze_lh
⚡ Trigger0445_Daily_bmd pipeline
🕞 Time04:35 AM daily
flowchart LR
    BMD[(BMD DWH
Source database)] -->|getBMDDWH
Fabric Data Pipeline| LH[(bmd_bronze_lh
Bronze Lakehouse)]
    LH -->|consumed by| SIL[Silver Lakehouse]
    TRG[⚡ Trigger:
0445_Daily_bmd
04:35 AM daily] -.->|schedules| BMD

    classDef src fill:#e3f2fd,stroke:#1976d2,stroke-width:1px
    classDef brz fill:#f4a261,stroke:#b85c00,stroke-width:1px,color:#000
    classDef sil fill:#c0c0c0,stroke:#555,stroke-width:1px
    classDef trg fill:#fff3cd,stroke:#b85c00,stroke-width:1px

    class BMD src
    class LH brz
    class SIL sil
    class TRG trg

List of tables

The bmd_bronze_lh currently exposes the following tables. All tables sit in the dbo schema and follow the import_<area>_<...> naming convention.

NameSchema
import_bmb_bil_acz_anlagegutsackontozudbo
import_bmd_bil_act_anlagegutberech_tmpdbo
import_bmd_bil_agu_anlagegutdbo
import_bmd_bil_ajo_anbujournaldbo
import_bmd_bil_anz_anlagegutkostzudbo
import_bmd_fibu_buchungendbo
import_bmd_fibu_kontodbo
import_bmd_fibu_sak_kontodbo
import_bmd_kore_kdp_planwertedbo
import_bmd_kore_kee_erfasseingabedbo
import_bmd_kore_kek_erfasskopfdbo
import_bmd_kore_korestammdbo
import_bmd_wws_erfasskopfdbo
import_buero_adr_adressedbo
import_buero_kli_kunde_liefereantdbo
import_buero_per_persondbo
import_fibu_pek_personenkontodbo

Functional groups (orientation)

The naming convention encodes the BMD module each table comes from. Knowing the prefix helps locate the right table fast.

PrefixBMD moduleTypical content
import_bmd_bil_*BIL — Bilanzierung / AssetsAnlagegüter, Journal, Kostenzuordnungen
import_bmd_fibu_*FIBU — FinanzbuchhaltungBuchungen, Konten, Sachkonten
import_bmd_kore_*KORE — KostenrechnungPlanwerte, Erfassungen, Stammdaten
import_bmd_wws_*WWS — WarenwirtschaftErfassungskopfdaten
import_buero_*BÜRO — StammdatenAdressen, Kunden/Lieferanten, Personen
import_fibu_*FIBU — PersonenkontenPersonenkonto-Stammdaten
Warning

Naming-Convention-Hinweis: Einige Tabellen tragen abweichende Prefixe (z.B. import_bmb_* statt import_bmd_*, liefereant statt lieferant). Diese sind 1:1 wie in der Quelle uebernommen, damit die Pipeline nicht bricht. Korrektur erst nach Ruecksprache mit dem Fabric-Team.

Operational notes

  • Schedule: Die Pipeline 0445_Daily_bmd laeuft taeglich um 04:35 Uhr und liefert den vollen Datenstand des Vortages in das Bronze-Lakehouse.
  • No transformations: Bronze speichert die Tabellen so nah wie moeglich am Quellsystem. Jede Bereinigung oder Modellierung passiert erst in Silver/Gold.
  • Access: Lese- und Schreibrechte ausschliesslich fuer das Fabric-Team. Power-BI-Reports konsumieren nicht direkt aus Bronze.

Related pages

Information

Migration footer
Source: BMD Bronze Lakehouse (SharePoint)
Original author: Bukkerji Sreejith — Sreejith.Bukkerji@spl-tele.com
Original last-modified: 2025-10-15
Migration date: 2026-05-24
Migrated by: Dimitri Rupp via ClaudeAI
Notes: EN-Original preserved; 3-card-WHAT-HOW-WHO layout converted to summary table; Mermaid orchestration diagram added; tables grouped by BMD module for navigation; technical table names preserved 1:1 incl. spelling variants (import_bmb_..., liefereant).

Verwandte Themen

Kuratiert — kann direkt im Editor ergänzt werden://

Failed to execute the [velocity] macro. Cause: [The execution of the [velocity] script macro is not allowed in [xwiki:IT-Wiki.Makros.Verwandte-Themen.WebHome]. Check the rights of its last author or the parameters if it's rendered from another script.]. Click on this message for details.

Status: Migriert — Team-Review ausstehend · Owner: (festlegen) · Letzter Review: 2026-06-11