SAP Technical
SAP S4HANA 1709 ABAP Training | SAP ABAP 7.5 Online Training
1) Introduction to SAP HANA & S/4HANA
2) Overview
- Traditional Software System
- Path to In-memory Database System
- Transactional Processing and Analytical Processing: OLTP and OLAP
3) HANA Overview and Features
- Row Store and Column Store
- Compression
- Partitioning
- No Aggregate Tables
- Insert only on Delta
4) Development tools for HANA Development
- HANA Studio
- Web IDE – Web Integrated Development Environment
- Eclipse Editor
5) Installing required Components in HANA Studio for HANA Developments
6) Perspectives Overview
7) HANA Admin Console Perspective
- Adding HANA systems to the HANA Studio
- Catalog Folder - Schema
- Content Folder- Package
8) HANA Modeling Perspective
9) ABAP Perspective
10) HANA Development Perspective
11) SQL Basics and Script Programming
12) SQL Commands
- DDL – Data Definition Language Statements
- CREATE Statement
- ALTER Statement
- DROP Statement
- RENAME Statement
- DML – Data Manipulation Language Statements
- SELECT Statement
- INSERT Statement
- UPDATE Statement
- DELETE Statement
13) Primary Database artifacts
14) SQL Script Programming
- Procedures
- Read Only Procedures
- Update Procedures
- Functions
- Scalar Functions
- Table Functions
- Additional Topics
- Indexes
- Sequences
- Triggers
- Database Transaction
- COMMIT Statement
- ROLLBACK Statement
15) Data Modeling
16) Calculation Views
- Runtime artifacts: Column View, Table Type and Database Procedure
- Functions
- Calling the Procedure
- Category
- Standard Calculation View
- Graphical Calculation Views: Dimension, Cube and Space
- Script Based Calculation View
- Time Calculation Views: Gregorian and Fiscal
17) ABAP on S/4HANA 1709
- Object Oriented Programming Overview
- Important ABAP 7.4 and 7.5 Features
- ABAP CDS (Core Data Services)
- Parameters
- Joins
- Associations
- Table Functions
- Roles
- Generating OData Service from CDS Views
- Create FIORI apps using Smart templates
- AMDPs(ABAP Managed Database Procedures)
- HANA ADBC
- Calling Native SQL Statements
- Calling Table Functions
- Calling Procedures
18) HANA SALV IDA
- Consume Tables
- Set field Catalog
- Set display Options
- Handle events
- Consume CDS views
19) BOPF Overview
20) HANA CDS
- Create Elementary Types, Structure Types and Table types
- Create entities
- Create views
- Create Associations
