SAP S/4 HANA COURSE SYLLABUS
Module 1: Modeling in SAP HANA
- Create Attribute Views
- Design Analytical Views
- Create Calculation Views from multiple analytical Views
- Best Practices while Creating Information Models
- Performance Optimization techniques in SAP HANA
- Currency Conversion
- Variables in HANA
- Meta data import to SAP HANA Using SAP
- Export Models
- Import Models
- SQL Script
- CE Functions
- Procedures
- Hierarchies – Level Based Hierarchies and Parent Child Hierarchies
- Restricted Measures & Calculated Measures & Calculated Attributes
- Joins in SAP HANA : Referential Join, Text Join, Inner Join, Right Outer Join & cardinalities
- Auto Documentation of Information Models
Module 2: Data Reporting
- SAP BI BO 4.0 Reporting Tools connectivity with SAP HANA
- IMCE Clients – ODBO , ODBC, JDBC, BICS
- Microsoft Excel 2010 Connection to HDB
- Create Universe through Information Design Tool using JDBC Connections
- Web Intelligence Document on SAP HANA Universe
- Design studio
- Lumira
- BO Analysis for Office
- BO Analysis for OLAP
- BO Explorer
- Crystal Reports for enterprise
Module 3: Data Provisioning or Data Loading
- SAP DXC – Direct Extractor Connection
- Flat File Upload to SAP HANA
- SAP BODS : Overview Data Services Workbench and Designer
- Creating Data store for ECC and HANA
- Create Data Services Job and Load the data to
- SAP HANA DB
Module 4: Administration in SAP HANA
- Backup & recovery
- SAP HANA Studio Installation and configuration
- Clients Installation
- Create ODBC Connections
- Monitor HDB
- Multi Version Concurrency Control – MVCC
- IMDB Installation
- Distributed System Handling – Cold backup and Hot backup
- Persistency Layer
Module 5: User Management & Security
- Creating users
- Creating Roles
- Assign privileges to Users/ Roles
- Template Roles
- SQL statements for user management
- Analytical privileges, Package Privileges, System
- Privileges , SQL Privileges
Module 6: COPA Accelerator
- COPA Overview COPA Reporting in HANA
- Architecture for CO-PA Accelerator, Use Case Scenarios , Scope
- DBSL – Data Shared Library Connection for HANA as a secondary Database
- SLT Replication – SAP HANA Model
Module 7: SAP BW on HANA
- Overview of SAP BW
- SAP BW Powered By HANA as a database
- In Memory Optimized Info Cube
- In Memory Optimized DSO
- Bex Report on SAP HANA Transient Provider
- SAP BW Composite provider on HANA Model
Module 8: SAP S4 HANA
- S4HANA A New Product :
- The First Contact to S4HANA
- Impact on SAP HANA Business Processes
- SAP HANA Architecture and Technical Basic Concept
Excercise 2 : - First View in the SAP HANA Database
- SAP Simple Finance as an instance of a new Application
- Introduction into Simple Finance:
- Posting with SAP Fiori
- Ways to S/4 HANA
- Lesson Customer Code Migration from ERP Finance to SAP Simple Finance
- SAP Simple Finance as an instance of a new Application
- Introduction into SAP Fiori
- Fiori Launch Pad