Introduction to SAP HANA
  • Describing the SAPHANA
  • How SAPHANA has become more popular over a traditional database
  • Benefits of Row and column based technology in SAP HANA
  • What is SAP BI/BW and how SAP HANA has overcome the limits of SAP BIBW
  • Why customers choose SAP HANA
  • Benefits of using SAP HANA
  • Operating systems supported by SAP HANA
  • SAP HANA Hardware Partners
  • SAP HANA software Editions
  • SAP HANA software Innovations
  • SAP HANA Hardware Innovations
  • SAP HANA Areas Administrator Modeler and Application Developer
  • Knowledge on SAP BW.SAPBOBI and SAP Data Services needed for SAP HANA
  • What is Business Suite on HANA SAP BW ON HANA, SAP ABAP ON HANA
  • The Evolution of SAP S/4 HANA
  • Comparisons of the versions
  • SAP HANA Editions
  • SAP HANA Release History
SAP HANA Landscape and Architecture
  • Main components of an SAP HANA Landscape
  • SAPHANA Architecture Overview
  • What is SAP HANA Studio?
  • What is a Perspective and Different perspectives in SAP HANA Studio
  • How to connect to SAP HANA Database using SAP HANA Studio
  • Introduction to ABAP Development Tools (also known as ABAP in Eclipse)
Where ABAP Meets HANA
  • New Features : Open SQL,CDS,AMDP and ALV IDA
Tools to prioritize performance issues
  • SQL Monitor
  • SQL Performance Tuning Worklist
ABAP CDS (Core Data Services)
  • Overview of Core Data Services – CDS
  • Availability of CDS in SAP Platforms
  • Code Push-Down Scenarios with CDS
  • Buil-in SQL-functions/SQL expressions
  1. Generic SQL Expressions
  2. Conversion Functions
  3. String Functions
  4. Arithmetic Functions
  5. Date and Time Function
  • CDS Table Functions
  1. Why do we need Table Functions
  2. Definition and Implementation of a Table Function
  3. Usage of Table Function
  4. Client Handling Definition and Implementation
  • Create CDS Views with Parameters
  • Create CDS Views with Joins
  • Create CDS Views with Associations
  • Extending CDS Views
  • Annotations
  • Authorization with DCL-Data Control Language
  1. Overview of DCL
  2. Usage of Declarative DCL Authorizations
  3. Classic Authority check
  4. Usage of Declarative DCL Authorizations
  • CDS and SAP Gateway
  1. Define view in CDS editor or reuse existing CDS views
  2. Import CDS view to Gateway Service Builder (SEGW)
  3. Activate/Register Gateway Service
  4. Consumption of CDS Views
Database Independent Code-to-Data
  • New Open SQL
SAP HANA specific Code-to-Data
  • Using native SQL and ABAP Data Base Connectivity (ADBC)
  • Creating, using and debugging ABAP Managed Database Procedures
SAP HANA Proxy Objects
  • Creating and using External Views
  • Database Procedure Proxies
  • HANA Transport Container
New Features in SAP Netweaver 7.4
  • In-Line Declarations in ABAP 7.4
  • Internal Table Expressions in ABAP 7.4
  • Move-Corresponding for Internal tables in ABAP 7.4
  • Filter operator for Internal tables in ABAP 7.4
  • Constructor Expression in ABAP 7.4
  • LET keyword in ABAP 7.4
Tools to detect potential functional and performance issues when migrating to SAP HANA
  • Code Inspector
  • ABAP Test Cockpit
  • ABAP Trace and
  • ABAP Profiler SQL Trace
  • Accessing SAP HANA as a Secondary Database
Performance Rules and Guidelines for ABAP in the context of SAP HANA Advanced Topics
  • Using SAP HANA Full Text Search in ABAP
  • Enabling input fields for type-ahead search
  • SAP List Viewer (ALV) for SAP HANA
  • How ALV with IDA works
  • Classical ABAPALV v/s ALV with IDA-Integrated Data Access on SAP HANA
  • How to set PARAMETERS to the ALV with IDA on SAP HANA
  • How to set SELECT-OPTIOINS to the ALV with IDA on SAP HANA
  • How to Modify Default field catalog of ABAPALV with IDA on SAP HANA
  • How to set Sort Order in ABAP ALV with IDA on SAP HANA
  • How to set Totals and Sub-Totals in ALV !DA

Leave a comment