BIS – Data Management: Architectures & Data Warehouses Session 5 29.11.2018
RECAP SAP Views on Data
Sample Processes in ERP-System
SAP System Data Types
Reprisé: ERP-Systems
→ Components & Features
▪ 1 cooperation-wide information system
▪ 1 cooperation-wide (distributed) data base
▪ 1 uniform user interface
→ IS-architecture with separation of the layers
▪ Data management (central/distributed data base)
▪ Application logic (central/distributed components) Organizational Data SAP Terminology
▪ Presentation
→ Major source for structured big data
1 | Seite
, BIS – Data Management: Architectures & Data Warehouses Session 5 29.11.2018
Master Data Creating Manageable Data Structures – Examples
→ Stored for a long time and seldom changed
→ Represent logical grouped data
▪ Customer Master
▪ Material Master
▪ Vendor Master
▪ General Ledger accounts
Transaction Data
→ System record of business event
→ Depending on business event, different master data and organizational data
will be referenced
→ Example: during business event the following data is stored:
▪ Organizational level: client, company code, sales organization
▪ Master data: customer, material, pricing (condition)
▪ Situational data: date, time, person, amount
Creating Manageable Data Structures
Understanding the Waves of Managing Data Creating Manageable Data Structures – Data Hierarchy
→ Wave born out of necessity to try and solve specific type of data management
problem; evolved due to cause and effect
[new technology solution launched required discovery of new approaches]
→ Wave 1: Creating manageable data structures
▪ when volume of data needed by organizations grew out of control
▪ Solution: Data warehouse [enables IT organization to select subset of data
being stored so that it would be easier for business to try to gain insights]
→ Wave 2: Web and content management
▪ Disconnected solutions became a more unified model that brought together
these elements into a platform that incorporated business process
management
→ Wave 3: Managing big data
▪ With big data: possibility to virtualize data so that it can be stored
efficiently & utilizing cloud-based storage; more cost effectively
2 | Seite
RECAP SAP Views on Data
Sample Processes in ERP-System
SAP System Data Types
Reprisé: ERP-Systems
→ Components & Features
▪ 1 cooperation-wide information system
▪ 1 cooperation-wide (distributed) data base
▪ 1 uniform user interface
→ IS-architecture with separation of the layers
▪ Data management (central/distributed data base)
▪ Application logic (central/distributed components) Organizational Data SAP Terminology
▪ Presentation
→ Major source for structured big data
1 | Seite
, BIS – Data Management: Architectures & Data Warehouses Session 5 29.11.2018
Master Data Creating Manageable Data Structures – Examples
→ Stored for a long time and seldom changed
→ Represent logical grouped data
▪ Customer Master
▪ Material Master
▪ Vendor Master
▪ General Ledger accounts
Transaction Data
→ System record of business event
→ Depending on business event, different master data and organizational data
will be referenced
→ Example: during business event the following data is stored:
▪ Organizational level: client, company code, sales organization
▪ Master data: customer, material, pricing (condition)
▪ Situational data: date, time, person, amount
Creating Manageable Data Structures
Understanding the Waves of Managing Data Creating Manageable Data Structures – Data Hierarchy
→ Wave born out of necessity to try and solve specific type of data management
problem; evolved due to cause and effect
[new technology solution launched required discovery of new approaches]
→ Wave 1: Creating manageable data structures
▪ when volume of data needed by organizations grew out of control
▪ Solution: Data warehouse [enables IT organization to select subset of data
being stored so that it would be easier for business to try to gain insights]
→ Wave 2: Web and content management
▪ Disconnected solutions became a more unified model that brought together
these elements into a platform that incorporated business process
management
→ Wave 3: Managing big data
▪ With big data: possibility to virtualize data so that it can be stored
efficiently & utilizing cloud-based storage; more cost effectively
2 | Seite
