What is SAP S/4 HANA Really Flashcards
Basic tables
VBAK, VBAP etc. pulling tables by their main criteria i.e. orders
Index tables
Backend table that has order of column entries for fast retrevial
VAPMA retrieves information via numbering for fast retrevial
Aggregate tables
store aggregation data (e.g. sum, average, etc.) of tables with detailed/item data. In ECC, those were necessary for performance issues when accessing the aggregation values.
Index tables, LIS tables etc
OLAP system
OnLine Analytical Processing etc. Datawarehouse
Extract, transform, and load data into a different system
Delayed access, not real-time
Based on predicted number of variables
OLTP system
OnLine Transaction Processing etc. ERP
Source of truth
Cube
Data in n number of dimensions
Digital boardroom
A room with key people from business asking questions
Column Oriented Database
Uses data dictionaries(columns) and arrays to access data randomly
Data dictionary
All the unique values in a column
Benefits of HANA
No need for indices
Reduction in data size
HANA
Fast DB
Allows random access
In-memory
The entire DB resides in memory instead on the hard disk which makes processing of data faster
Single source of truth
Doing everything that is done in the OLAP system in the OLTP system
Multi-tenant
In the same DB instance you can have any number of tenants i.e. ERP, APO, GTS etc all in one system
Digital Core
Core set of systems built on HANA that are updated by satellite systems on a real time
