SAP ABAP on HANA

SAP ABAP ON HANA COURSE CONTENT

 Course Duration: 40-45  Hours

  • HA100
  • HA150
  • New Open SQL Syntax
  • SAP HANA Studio
    • Modeler,
  • Architecture of SAP HANA
    •  Row Store
    • Column Store
    • Database engine of HANA
    • Data modeling
    • Reporting Architecture
    • Administration
  • 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
    • Variables in HANA
    • Meta data import to SAP HANA Using SAP BODS
    • SQL Script
    • CE Functions
    • 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

  • Data Provisioning or Data Loading
    • SAP LANDSCAPE Transformation – SLT
    • SAP BODS Load to SAP HANA – ODP Enabled
    • Flat File Upload to SAP HANA
    • Creating Data store for ECC and HANA
  • Administration in SAP HANA Backup & recovery
    • SAP HANA Studio Installation and Configuration
    • Analytical Privileges,
    • SLT Replication – SAP HANA Model.
  • ABAP on HANA(HA400)
    • Overview of ABAP ON HANA
    • External view
    • Expose Hana view as external view in
    • ABAP dictionary
    • Implementing ABAP Report consuming
    • An External view
    • Database procedure proxies
    • Program to consume HANA Stored procedure in ABAP
    • Table functions
    • HANA HDB TABLE
    • Stored Procedures
    • CDS Views
    • Creation of CDS views with column list and column alias
    • Creation of CDS views with case statements
    • Creation of CDS views with Joins
    • Call ABAP CDS Views in ABAP report on HANA
    • ABAP ALV with Integrated Data Access on HANA
    • AMDP CLASS
    • AMDP Methods
    • Call the AMDP procedure in Report
    • Fuzzy Search