SAP ABAP on HANA

Description

ABAP ON HANA COURSE CONTENT

Introduction to SAP HANA

• Introduction to IMCE( In-Memory Computing Engine)
• Row v/s Column store
• Software and Hardware advancements
• Evolution to SAP HANA -1.0 to 2.0
• Usage Of SAP HANA with SAP Products
  • As secondary DB
  • BW on HANA
  • ABAP on HANA
• Setup you SAP ABAP on HANA instance in CAL
• Connection to your HANA system via HANA Studio
• SQL Console
• Introduction to HANA user
• SAP HANA Information Modelling
  • Attribute Views
  • Analytic Views
  • Calculation views
    • Graphical Calculation Views
    • Scripted Calculation Views

Decision Table

• With value update
• Without value update

• Concept of currency conversion
• Concept of Dimension and Measures
• SQL Script in SAP HANA
• SAP HANA Anonymous blocks
• Scripted procedure in SAP HANA
• Procedures with parameters
• User Defined functions in SAP HANA
• Reuse functions for SQL queries

ABAP on HANA

• Introduction to ADT(ABAP Development Tools)
• ABAP on eclipse
• ABAP project in eclipse
• Working with ADT shortcuts, inline view
• Optimising developer efficiency with ADT
• Introduction to schema of ABAP in SAP HANA
• Evolution of SAP Net weaver and capabilities
• Open SQL Enhancement in SAP HANA
• Introduction to DDL,DML,DCL,DQL
• New syntax in ABAP
  • Inline data declaration
  • Dynamic memory references
  • SQL statements with escaping of host variables
• Introduction to EPM Data model
• Consumption of SAP HANA Objects in ABAP
  • View proxies
  • Procedure proxies
• Transporting of dependent objects
  • Lifecycle management
  • HANA transport container
• New tooling updates in ABAP
  • SQL monitor SQLM
  • Code inspector variants
  • Data migration points
  • Static checks with SQL performance – SWLT
  • SQL performance worklist monitor

 Advanced features of SAP ABAP on HANA

•  Introduction to code-to-data paradigm
• Code push down to Database
• Integration cloud system to HANA Cloud platform using Cloud connector
• Performance improvement using SAP HANA
• ABAP Database Connectivity API (ADBC)
• Open Item analysis scenario using ADBC
• ABAP Managed Database Procedures(AMDP)
• Core Data Services (CDS)
  • CDS Introduction
  • CDS Associations
  • CDS View on View
  • s/4 HANA CDS VDM (Virtual Data Model)
    • Basic/Interface Views
    • Composite Views
    • Consumption Views
  • CDS Annotations
    • Object Model Annotations
    • OData Annotations
    • Analytical Annotations
    • End user annotations
    • UI Annotations
  • CDS View Table Functions
  • CDS DCL (Authorisation and secure programming)
  • Consuming CDS in Analytical Tools
  • CDS-BOPF integration
  • Creative your own O Data services on top of CDS views
• SAP ABAP Improved ALV IDA (Integrated Data Access)
• Full Text Search with SAP HANA
• Fuzzy search for search helps with SAP HANA

End to End Implementation

• Implementation of End to end OIA(Open Item Analysis)scenario using all techniques in ABAP on HANA
• Implementation of smart filter Fiori Application
• Create Your OVP (Overview page) Fiori Elements to show Analytical dashboard
• Transnational Fiori App with CDS and BOPF
• Complementary OOPS ABAP session RTTS

https://www.govideotutorials.com