Reconciliation checks
| Check | A | B | Status |
|---|---|---|---|
| sales_fact net = P&L net sales | 240.7 | 240.7 | RECONCILED |
| CO-PA net = sales_fact net | 240.7 | 240.7 | RECONCILED |
| SKU (product,grams) uniqueness | 0 | 0 | RECONCILED |
| FI ledger balances (Dr−Cr=0) | 0.0 | 0 | RECONCILED |
Source systems
| Source | Tables | Freshness |
|---|---|---|
| SAP | 35 | live |
| DMS (API) | 10 | live |
| SAP MM | 5 | live |
| Semantic Layer | 4 | live |
| SAP/DMS | 3 | live |
| SAP PP | 3 | live |
| SAP FI | 3 | live |
| Azure OpenAI (gpt-4.1) | 3 | live |
| SAP/DWH | 2 | live |
| SAP SD | 2 | live |
| SAP IBP | 2 | live |
| MDM/Survivorship | 2 | live |
| SAP SD/BW | 1 | live |
| SAP BW | 1 | live |
| SAP + DMS | 1 | live |
| Data Warehouse | 1 | live |
| DMS (API-based) | 1 | live |
| Azure OpenAI | 1 | live |
| Analytics/BI | 1 | live |
Table catalogue & row counts
| Table | Stage | Module | Source | Rows |
|---|---|---|---|---|
| embedding | AI | - | Azure OpenAI | 127 |
| ai_insight | AI | - | Azure OpenAI (gpt-4.1) | 8 |
| entity_match | AI | - | Azure OpenAI (gpt-4.1) | 25 |
| nl_query_log | AI | - | Azure OpenAI (gpt-4.1) | 13 |
| inventory_snapshot | DELIVER | MM/WM | SAP MM | 96 |
| delivery | DELIVER (SD) | SD-LE | SAP | 156 |
| delivery_item | DELIVER (SD) | SD-LE | SAP | 468 |
| exec_kpi | ENTERPRISE | - | Analytics/BI | 12 |
| gl_account | FINANCE | FI/CO | SAP FI | 16 |
| pl_monthly | FINANCE | FI/CO | SAP FI | 12 |
| ar_snapshot | FINANCE | FI-AR | SAP FI | 72 |
| fi_document | FINANCE | FI | SAP | 396 |
| fi_line | FINANCE | FI | SAP | 1,380 |
| co_pa | FINANCE | CO-PA | SAP | 1,560 |
| ap_open_item | FINANCE | FI-AP | SAP | 20 |
| kg_node | KNOWLEDGE GRAPH | - | Semantic Layer | 419 |
| kg_edge | KNOWLEDGE GRAPH | - | Semantic Layer | 966 |
| production_order | MAKE | PP | SAP PP | 3,408 |
| plant_capacity | MAKE | PP | SAP PP | 48 |
| distributor | MASTER | SD/MM | SAP + DMS | 37 |
| customer | MASTER | SD | SAP | 19 |
| facility | MASTER | PP/MM | SAP | 5 |
| country | MASTER | SD | SAP | 28 |
| product/category/sku | MASTER | MM | SAP | — |
| business_partner | MASTER (BP) | MDG/BP | SAP | 64 |
| bp_role | MASTER (BP) | MDG/BP | SAP | 101 |
| bp_partner_function | MASTER (BP) | SD | SAP | 216 |
| salesman | MASTER (DMS) | - | DMS (API) | 66 |
| beat | MASTER (DMS) | - | DMS (API) | 80 |
| outlet | MASTER (DMS) | - | DMS (API) | 1,789 |
| golden_party | MASTER (MDM) | - | MDM/Survivorship | 54 |
| party_xref | MASTER (MDM) | - | MDM/Survivorship | 56 |
| company_code | MASTER (Org) | FI | SAP | 1 |
| credit_control_area | MASTER (Org) | FI-AR | SAP | 1 |
| sales_org | MASTER (Org) | SD | SAP | 2 |
| distribution_channel_sap | MASTER (Org) | SD | SAP | 5 |
| division | MASTER (Org) | SD | SAP | 5 |
| sales_area | MASTER (Org) | SD | SAP | 25 |
| purchasing_org | MASTER (Org) | MM | SAP | 1 |
| plant | MASTER (Org) | PP/MM | SAP | 5 |
| storage_location | MASTER (Org) | MM/WM | SAP | 13 |
| profit_center | MASTER (Org) | CO | SAP | 7 |
| cost_center | MASTER (Org) | CO | SAP | 6 |
| ontology_class | ONTOLOGY | - | Semantic Layer | 14 |
| ontology_relation | ONTOLOGY | - | Semantic Layer | 11 |
| demand_forecast | PLAN | IBP/APO | SAP IBP | 5,112 |
| supply_plan | PLAN | IBP/PP | SAP IBP | 3,408 |
| condition_type | PRICING | SD-Pricing | SAP | 6 |
| pricing_condition | PRICING | SD-Pricing | SAP | 1,356 |
| dim_date | Reference | - | Data Warehouse | 12 |
| dim_channel | Reference | SD | SAP/DWH | 6 |
| dim_region | Reference | SD | SAP/DWH | 6 |
| channel_level | Reference | SD | SAP/DMS | 7 |
| distribution_type | Reference | SD | SAP/DMS | 15 |
| customer_type | Reference | SD | SAP/DMS | 13 |
| sales_order | SELL | SD | SAP SD | 216 |
| sales_order_line | SELL | SD | SAP SD | 648 |
| sales_fact | SELL | SD | SAP SD/BW | 22,152 |
| region_channel_sales | SELL | SD | SAP BW | 312 |
| secondary_sales | SELL | - | DMS (API-based) | 336 |
| secondary_invoice | SELL (DMS) | - | DMS (API) | 3,711 |
| secondary_sales_line | SELL (DMS) | - | DMS (API) | 12,939 |
| distributor_stock | SELL (DMS) | - | DMS (API) | 336 |
| scheme | SELL (DMS) | - | DMS (API) | 10 |
| distributor_claim | SELL (DMS) | - | DMS (API) | 472 |
| sales_return | SELL (DMS) | - | DMS (API) | 185 |
| salesman_visit | SELL (DMS) | - | DMS (API) | 198 |
| billing_document | SELL (SD) | SD-Billing | SAP | 156 |
| billing_item | SELL (SD) | SD-Billing | SAP | 468 |
| document_flow | SELL (SD) | SD | SAP | 468 |
| vendor | SOURCE | MM | SAP MM | 10 |
| raw_material | SOURCE | MM | SAP MM | 10 |
| purchase_order | SOURCE | MM | SAP MM | 120 |
| po_line | SOURCE | MM | SAP MM | 120 |
| purchase_requisition | SOURCE | MM | SAP | 120 |
| goods_receipt | SOURCE | MM-IM | SAP | 120 |
| goods_receipt_item | SOURCE | MM-IM | SAP | 120 |
| vendor_invoice | SOURCE | MM-LIV | SAP | 120 |
| vendor_invoice_item | SOURCE | MM-LIV | SAP | 120 |
| three_way_match | SOURCE | MM-LIV | SAP | 120 |
| bom | SOURCE/MAKE | PP | SAP PP | 142 |