SAP ABAP ON HANA -S/4 Hana Technical Along with building Fiori Apps COURSE CONTENT
Course Duration: 40 Hours (Online Live & Interactive)
Introduction to SAP HANA
• Introduction to IMCE (In-Memory Computing Engine)
• Row v/s Column Store
• Software and Hardware advancements
ARCHITECTURE FOR ABAP FOR HANA
• Evolution and architecture
• Overview for ABAP meets HANA
• Code to data paradigm
Usage of SAP HANA with SAP Products
• As secondary DB
• ABAP on HANA
SYSTEM REQUIREMENT AND SYSTEM SET UP:
• SAP HANA ADT Installation on HANA Studio
• Overview of HANA studio
• Overview of ABAP development environment in eclipse
• Adding system in HANA studio
• Creating package in HANA Studio
• Setup environment in eclipse for ABAP development
• SQL Console
Introduction to Catalog, Content, Provisioning and Security in SAP HANA
• Schema Creation
• Authorization
• Table creation and data load
SAP HANA Information Modeling
• Attribute Views
• Analytic Views
• Calculation Views
• Graphical Calculation Views
• Scripted Calculation Views
• Decision Table
a) With value update
b) Without value update
• Concept of Dimensions and Measures
• Star Join Concept
• SQL Scripting in SAP HANA
• Scripted procedures in SAP HANA
Transport MANAGEMENT IN SAP HANA
ABAP on HANA
• ABAP on eclipse/HANA Studio(ADT)
• ABAP project in eclipse
• Working with ADT shortcuts, inline view
• Optimizing developer efficiency with ADT
• Introduction to schema of ABAP in SAP HANA
• Open SQL Enhancements in SAP HANA
• New syntax in ABAP
• Inline data declaration
• SQL statements with escaping of host variables
Consumption of SAP HANA Objects in ABAP
a) View Proxies
b) Procedure proxies
• HANA transport container for ABAP
New tooling updates in ABAP
• ABAP TEST Cockpit (along with variants)
• SQL monitor SQLM
• Code inspector variants
• Static checks with SQL performance – SWLT
• SQL Performance worklist monitor
Advanced features of SAP ABAP on S/4HANA
• Introduction to code-to-data paradigm
• Code push down to Database
• Performance improvement using SAP HANA
• ABAP Managed Database Procedures (AMDP)
• Core Data Services (CDS) Views
a) CDS Introduction
b) CDS Associations
c) CDS View on View
d) CDS with input parameter
Integration of inbuilt SQL function with CDS
• Conversion Functions
• String Functions
• Arithmetic Functions
• Date and Time Functions
• Generic SQL Expressions
Extensibility
• Extension/enhancement of standard CDS delivered by SAP.
• Best practices and rules to follow
S/4 HANA CDS VDM (Virtual Data Model)
1) Basic/Interface Views
2) Composite Views
3) Consumption Views
CDS Annotations
➢ ObjectModel Annotations
➢ OData Annotations
➢ End User annotations
➢ UI Annotations
➢ Semantic Annotations
➢ ABAPCatalog Anotations
• CDS View Table Functions
• CDS DCL (Authorizations and secure programming)
Introduction to BOPF concept
• CDS-BOPF integration
ABAP on SAP Cloud platform
• ABAP RESTful Programming Model (RAP) with CRUD(End to End hands-on)
Business Services
• Service definition
• Service binding
Introduction to Odata
• Create your own OData services on top of CDS views
SAP ABAP Improved ALV IDA (Integrated Data Access)
• Introduction to S/4 HANA and HANA Cloud Platform
• Introduction to HANA Cloud Connector
• Configuration
• BUILDING FIORI SMART TEMPLATE APPLICATION USING WEBIDE
End to End Implementation
• Fiori App for reporting (Using CDS)
• Transactional Fiori App with CDS and BOPF
• Fiori app to display Charts
• Fiori app with navigation features and multiple tabs
• Fiori app development using ABAP on SAP Cloud platform