Understanding the SAP S/4HANA Data Model
SAP S/4HANA consolidates data into a simplified structure. Learn how its core tables, universal journal, and CDS Views form a coherent data model.
The Simplified Data Model
One of the biggest changes from SAP ECC to S/4HANA is the simplified data model. SAP eliminated many aggregate and index tables, consolidating data into fewer, larger tables optimized for the SAP HANA in-memory database.
Key Tables
The most important tables in S/4HANA include:
- ACDOCA — Universal Journal: Combines FI, CO, ML, and AA postings into a single table. Replaces BSEG, COEP, MLCD, ANEK, and others.
- MATDOC — Material Document (replaces MSEG): All goods movements in a single table
- BKPF — Accounting Document Header (still exists in S/4HANA)
- VBAK / VBAP — Sales Order Header / Item
- EKKO / EKPO — Purchase Order Header / Item
The Role of CDS Views
While the table structure is simplified, CDS Views provide the application-level data model. The Virtual Data Model sits on top of these core tables and provides:
- Business-friendly field names (e.g.,
CompanyCodeinstead ofBUKRS) - Cross-module joins (e.g., combining sales data with finance data)
- Analytical views for embedded analytics
- Stable APIs through release contracts
Compatibility Views
SAP provides compatibility views that emulate legacy ECC tables (like BSEG) by reading from the new tables (like ACDOCA). This ensures that existing custom code continues to work, though with reduced performance.