Everest360
Persona SS CF BD My view →
Slicer

Data Health & Lineage

Freshness, reconciliation and coverage across the SAP + DMS model — the discipline behind every certified number.

86 tables · 65,483 rows

Reconciliation checks

CheckABStatus
sales_fact net = P&L net sales240.7240.7 RECONCILED
CO-PA net = sales_fact net240.7240.7 RECONCILED
SKU (product,grams) uniqueness00 RECONCILED
FI ledger balances (Dr−Cr=0)0.00 RECONCILED

Source systems

SourceTablesFreshness
SAP35live
DMS (API)10live
SAP MM5live
Semantic Layer4live
SAP/DMS3live
SAP PP3live
SAP FI3live
Azure OpenAI (gpt-4.1)3live
SAP/DWH2live
SAP SD2live
SAP IBP2live
MDM/Survivorship2live
SAP SD/BW1live
SAP BW1live
SAP + DMS1live
Data Warehouse1live
DMS (API-based)1live
Azure OpenAI1live
Analytics/BI1live

Table catalogue & row counts

TableStageModuleSourceRows
embeddingAI -Azure OpenAI 127
ai_insightAI -Azure OpenAI (gpt-4.1) 8
entity_matchAI -Azure OpenAI (gpt-4.1) 25
nl_query_logAI -Azure OpenAI (gpt-4.1) 13
inventory_snapshotDELIVER MM/WMSAP MM 96
deliveryDELIVER (SD) SD-LESAP 156
delivery_itemDELIVER (SD) SD-LESAP 468
exec_kpiENTERPRISE -Analytics/BI 12
gl_accountFINANCE FI/COSAP FI 16
pl_monthlyFINANCE FI/COSAP FI 12
ar_snapshotFINANCE FI-ARSAP FI 72
fi_documentFINANCE FISAP 396
fi_lineFINANCE FISAP 1,380
co_paFINANCE CO-PASAP 1,560
ap_open_itemFINANCE FI-APSAP 20
kg_nodeKNOWLEDGE GRAPH -Semantic Layer 419
kg_edgeKNOWLEDGE GRAPH -Semantic Layer 966
production_orderMAKE PPSAP PP 3,408
plant_capacityMAKE PPSAP PP 48
distributorMASTER SD/MMSAP + DMS 37
customerMASTER SDSAP 19
facilityMASTER PP/MMSAP 5
countryMASTER SDSAP 28
product/category/skuMASTER MMSAP
business_partnerMASTER (BP) MDG/BPSAP 64
bp_roleMASTER (BP) MDG/BPSAP 101
bp_partner_functionMASTER (BP) SDSAP 216
salesmanMASTER (DMS) -DMS (API) 66
beatMASTER (DMS) -DMS (API) 80
outletMASTER (DMS) -DMS (API) 1,789
golden_partyMASTER (MDM) -MDM/Survivorship 54
party_xrefMASTER (MDM) -MDM/Survivorship 56
company_codeMASTER (Org) FISAP 1
credit_control_areaMASTER (Org) FI-ARSAP 1
sales_orgMASTER (Org) SDSAP 2
distribution_channel_sapMASTER (Org) SDSAP 5
divisionMASTER (Org) SDSAP 5
sales_areaMASTER (Org) SDSAP 25
purchasing_orgMASTER (Org) MMSAP 1
plantMASTER (Org) PP/MMSAP 5
storage_locationMASTER (Org) MM/WMSAP 13
profit_centerMASTER (Org) COSAP 7
cost_centerMASTER (Org) COSAP 6
ontology_classONTOLOGY -Semantic Layer 14
ontology_relationONTOLOGY -Semantic Layer 11
demand_forecastPLAN IBP/APOSAP IBP 5,112
supply_planPLAN IBP/PPSAP IBP 3,408
condition_typePRICING SD-PricingSAP 6
pricing_conditionPRICING SD-PricingSAP 1,356
dim_dateReference -Data Warehouse 12
dim_channelReference SDSAP/DWH 6
dim_regionReference SDSAP/DWH 6
channel_levelReference SDSAP/DMS 7
distribution_typeReference SDSAP/DMS 15
customer_typeReference SDSAP/DMS 13
sales_orderSELL SDSAP SD 216
sales_order_lineSELL SDSAP SD 648
sales_factSELL SDSAP SD/BW 22,152
region_channel_salesSELL SDSAP BW 312
secondary_salesSELL -DMS (API-based) 336
secondary_invoiceSELL (DMS) -DMS (API) 3,711
secondary_sales_lineSELL (DMS) -DMS (API) 12,939
distributor_stockSELL (DMS) -DMS (API) 336
schemeSELL (DMS) -DMS (API) 10
distributor_claimSELL (DMS) -DMS (API) 472
sales_returnSELL (DMS) -DMS (API) 185
salesman_visitSELL (DMS) -DMS (API) 198
billing_documentSELL (SD) SD-BillingSAP 156
billing_itemSELL (SD) SD-BillingSAP 468
document_flowSELL (SD) SDSAP 468
vendorSOURCE MMSAP MM 10
raw_materialSOURCE MMSAP MM 10
purchase_orderSOURCE MMSAP MM 120
po_lineSOURCE MMSAP MM 120
purchase_requisitionSOURCE MMSAP 120
goods_receiptSOURCE MM-IMSAP 120
goods_receipt_itemSOURCE MM-IMSAP 120
vendor_invoiceSOURCE MM-LIVSAP 120
vendor_invoice_itemSOURCE MM-LIVSAP 120
three_way_matchSOURCE MM-LIVSAP 120
bomSOURCE/MAKE PPSAP PP 142