Skip to Content

Wiki source code of BMD Bronze Lakehouse

Version 2.1 by Dimitri Rupp on 2026/06/11 09:16
Show last authors
1 {{box cssClass="floatinginfobox" title="**On this page**"}}
2 {{toc/}}
3 {{/box}}
4
5 = BMD Bronze Lakehouse =
6
7 {{info}}
8 **Source system:** BMD ERP — Financial / Accounting Data Warehouse
9 **Stage:** Bronze (raw landing zone)
10 **Owner:** Fabric team (restricted access)
11 {{/info}}
12
13 == Overview ==
14
15 |=(% style="width:80px" %)📋 **What**|Tables from the BMD Data Warehouse. Acts as the **landing zone** for all BMD-related data. No transformations are carried out here.
16 |=(% style="width:80px" %)🔄 **How**|Data is copied via **Fabric Data Pipelines**.
17 |=(% style="width:80px" %)🔐 **Who**|Access is **restricted to the Fabric team**.
18
19 == Orchestration ==
20
21 |=Property|=Value
22 |🛠️ Tool|Fabric Data Pipeline
23 |🆔 Pipeline name|(% style="font-family:monospace" %)getBMDDWH(%%)
24 |ℹ️ Function|Copy data from BMD DWH to (% style="font-family:monospace" %)bmd_bronze_lh(%%)
25 |⚡ Trigger|(% style="font-family:monospace" %)0445_Daily_bmd(%%) pipeline
26 |🕞 Time|04:35 AM daily
27
28 {{mermaid}}
29 flowchart LR
30 BMD[(BMD DWH<br/>Source database)] -->|getBMDDWH<br/>Fabric Data Pipeline| LH[(bmd_bronze_lh<br/>Bronze Lakehouse)]
31 LH -->|consumed by| SIL[Silver Lakehouse]
32 TRG[⚡ Trigger:<br/>0445_Daily_bmd<br/>04:35 AM daily] -.->|schedules| BMD
33
34 classDef src fill:#e3f2fd,stroke:#1976d2,stroke-width:1px
35 classDef brz fill:#f4a261,stroke:#b85c00,stroke-width:1px,color:#000
36 classDef sil fill:#c0c0c0,stroke:#555,stroke-width:1px
37 classDef trg fill:#fff3cd,stroke:#b85c00,stroke-width:1px
38
39 class BMD src
40 class LH brz
41 class SIL sil
42 class TRG trg
43 {{/mermaid}}
44
45 == List of tables ==
46
47 The (% style="font-family:monospace" %)bmd_bronze_lh(%%) currently exposes the following tables. All tables sit in the **(% style="font-family:monospace" %)dbo(%%)** schema and follow the (% style="font-family:monospace" %)import_<area>_<...>(%%) naming convention.
48
49 |=Name|=Schema
50 |(% style="font-family:monospace" %)import_bmb_bil_acz_anlagegutsackontozu(%%)|dbo
51 |(% style="font-family:monospace" %)import_bmd_bil_act_anlagegutberech_tmp(%%)|dbo
52 |(% style="font-family:monospace" %)import_bmd_bil_agu_anlagegut(%%)|dbo
53 |(% style="font-family:monospace" %)import_bmd_bil_ajo_anbujournal(%%)|dbo
54 |(% style="font-family:monospace" %)import_bmd_bil_anz_anlagegutkostzu(%%)|dbo
55 |(% style="font-family:monospace" %)import_bmd_fibu_buchungen(%%)|dbo
56 |(% style="font-family:monospace" %)import_bmd_fibu_konto(%%)|dbo
57 |(% style="font-family:monospace" %)import_bmd_fibu_sak_konto(%%)|dbo
58 |(% style="font-family:monospace" %)import_bmd_kore_kdp_planwerte(%%)|dbo
59 |(% style="font-family:monospace" %)import_bmd_kore_kee_erfasseingabe(%%)|dbo
60 |(% style="font-family:monospace" %)import_bmd_kore_kek_erfasskopf(%%)|dbo
61 |(% style="font-family:monospace" %)import_bmd_kore_korestamm(%%)|dbo
62 |(% style="font-family:monospace" %)import_bmd_wws_erfasskopf(%%)|dbo
63 |(% style="font-family:monospace" %)import_buero_adr_adresse(%%)|dbo
64 |(% style="font-family:monospace" %)import_buero_kli_kunde_liefereant(%%)|dbo
65 |(% style="font-family:monospace" %)import_buero_per_person(%%)|dbo
66 |(% style="font-family:monospace" %)import_fibu_pek_personenkonto(%%)|dbo
67
68 == Functional groups (orientation) ==
69
70 The naming convention encodes the BMD module each table comes from. Knowing the prefix helps locate the right table fast.
71
72 |=Prefix|=BMD module|=Typical content
73 |(% style="font-family:monospace" %)import_bmd_bil_*(%%)|**BIL** — Bilanzierung / Assets|Anlagegüter, Journal, Kostenzuordnungen
74 |(% style="font-family:monospace" %)import_bmd_fibu_*(%%)|**FIBU** — Finanzbuchhaltung|Buchungen, Konten, Sachkonten
75 |(% style="font-family:monospace" %)import_bmd_kore_*(%%)|**KORE** — Kostenrechnung|Planwerte, Erfassungen, Stammdaten
76 |(% style="font-family:monospace" %)import_bmd_wws_*(%%)|**WWS** — Warenwirtschaft|Erfassungskopfdaten
77 |(% style="font-family:monospace" %)import_buero_*(%%)|**BÜRO** — Stammdaten|Adressen, Kunden/Lieferanten, Personen
78 |(% style="font-family:monospace" %)import_fibu_*(%%)|FIBU — Personenkonten|Personenkonto-Stammdaten
79
80 {{warning}}
81 **Naming-Convention-Hinweis:** Einige Tabellen tragen abweichende Prefixe (z.B. (% style="font-family:monospace" %)import_bmb_*(%%) statt (% style="font-family:monospace" %)import_bmd_*(%%), (% style="font-family:monospace" %)liefereant(%%) statt (% style="font-family:monospace" %)lieferant(%%)). Diese sind **1:1 wie in der Quelle** uebernommen, damit die Pipeline nicht bricht. Korrektur erst nach Ruecksprache mit dem Fabric-Team.
82 {{/warning}}
83
84 == Operational notes ==
85
86 * **Schedule:** Die Pipeline (% style="font-family:monospace" %)0445_Daily_bmd(%%) laeuft taeglich um 04:35 Uhr und liefert den **vollen Datenstand des Vortages** in das Bronze-Lakehouse.
87 * **No transformations:** Bronze speichert die Tabellen so nah wie moeglich am Quellsystem. Jede Bereinigung oder Modellierung passiert erst in Silver/Gold.
88 * **Access:** Lese- und Schreibrechte ausschliesslich fuer das Fabric-Team. Power-BI-Reports konsumieren nicht direkt aus Bronze.
89
90 == Related pages ==
91
92 * [[Bronze Lakehouse (Hub)>>doc:IT-Wiki.01-Data.Ingestion.Bronze-Lakehouse.WebHome]]
93 * [[Fabric Lakehouse Hub>>doc:IT-Wiki.01-Data.Processing.Lakehouse.WebHome]]
94 * [[Microsoft Fabric Datenarchitektur im SPL>>doc:IT-Wiki.01-Data.Microsoft-Fabric-Datenarchitektur-im-SPL.WebHome]]
95 * [[Silver Lakehouse>>doc:IT-Wiki.01-Data.Processing.Lakehouse.Fabric-Silver-Lakehouse.WebHome]]
96 * [[Gold Lakehouse>>doc:IT-Wiki.01-Data.Processing.Lakehouse.Fabric-Gold-Lakehouse.WebHome]]
97
98 ----
99
100 {{info}}
101 **Migration footer**
102 **Source:** [[BMD Bronze Lakehouse (SharePoint)>>url:https://spltele.sharepoint.com/sites/WikiPowerBI/SitePages/BMD-Bronze-Lakehouse.aspx]]
103 **Original author:** Bukkerji Sreejith — Sreejith.Bukkerji@spl-tele.com
104 **Original last-modified:** 2025-10-15
105 **Migration date:** 2026-05-24
106 **Migrated by:** Dimitri Rupp via ClaudeAI
107 **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).
108 {{/info}}
109
110
111 ----
112
113 == Verwandte Themen ==
114
115 //Kuratiert — kann direkt im Editor ergänzt werden://
116
117 * [[Board Bronze Lakehouse>>doc:IT-Wiki.01-Data.Ingestion.Bronze-Lakehouse.Board-Bronze-Lakehouse.WebHome]]
118 * [[H3A Bronze Lakehouse>>doc:IT-Wiki.01-Data.Ingestion.Bronze-Lakehouse.H3A-Bronze-Lakehouse.WebHome]]
119 * [[Rimo Lakehouse>>doc:IT-Wiki.01-Data.Ingestion.Bronze-Lakehouse.Rimo-Lakehouse.WebHome]]
120
121 {{include reference="IT-Wiki.Makros.Verwandte-Themen.WebHome"/}}
122
123 ----
124 **Status:** Migriert — Team-Review ausstehend · **Owner:** //(festlegen)// · **Letzter Review:** 2026-06-11