Practical Guide to SAP ABAP HANA Development

Categories SAP

Welcome to Proximsoft’s SAP ABAP HANA course, where we merge the power of SAP ABAP programming with the capabilities of the SAP HANA database. Our course is designed to provide you with comprehensive insights into this dynamic duo, ensuring you gain the skills needed to excel in SAP ABAP HANA development. Understanding that SAP ABAP HANA is more than simply a course, Proximsoft provides high-performance analytics and sophisticated business application development to help you realize the full potential of SAP applications.

Why Learn SAP ABAP HANA?

SAP is widely used by large enterprises for managing their business processes. ABAP on HANA is a sought-after skill, and professionals with expertise in this area are in high demand.
The in-memory database that powers SAP HANA is well-known for significantly speeding up data processing. Learning ABAP on HANA allows you to work with this cutting-edge technology and take the advantages of in-memory computing.
ABAP on HANA allows for the optimization of existing ABAP programs to run more efficiently on the HANA platform. This skill is valuable for organizations looking to enhance the performance of their SAP applications
As technology evolves, having skills in the latest SAP technologies ensures that your career remains relevant. ABAP on HANA is part of SAP’s modernization efforts, making it a valuable skill for the future.
SAP HANA provides a platform for innovation by offering advanced features for data processing and analytics. Learning ABAP on HANA opens the door to developing innovative applications that can drive business growth.

Mode of Training	Online live Interactive sessions
Duration of the Training	6 weeks
Training duration per day	60 – 90 min session
Software Access	Software will be installed/server access will be provided, whichever is possible
Training Materials	Soft copy of the material will be provided during the training
Training fee	Depends on the Requirement
Resume Preparation	Yes, at the end of the course based on the JD
Interview Preparation	Yes, by sharing some FAQ’s
Mock calls	Yes, 2 Technical Mock calls
Internship Project	Yes
Certification	Yes, at the end of the training
JOB Assistance	Yes
JOB Support	Yes


Weekdays	6AM -2 PM EST & 6-11:30 PM EST (student can pick any 1 hr)
Weekends	8 AM – 12 PM EST (student can pick any 2 hrs)

Course Content

Introduction to ABAP on HANA

ABAP 7.40 & 7.50 New Syntax.
- a) Inline Declarations
- b) Helper Variable Dynamic Declaration
- c) Read Table Operator
  - Default & Options
  - Using Index
  - Find out if the row existed or not.
d) Find out the Number of rows of an internal table
e) Adding the Record to the Internal table
- Adding records Manually
- moving the record from one ITAB to Another ITAB
f) Move Corresponding
- Moving Details from one WA to Another WA
- Moving Details from One Internal table to Another Internal table
g) Importance of BASE Command when moving the Data
h) Processing functions
- Replace statement.
- Find out the length of an string.
- Insert string.
- Repeat operator.
- Shift_left/Shift_right
i) Formatting Operators:
- Conversions – ALPHA
- Formatting with Decimal and sign
- formatting with case
- Formatting Date, Currency to Specific country format
- Formatting time stamp using time zone
j) Operators
- EQUIV
- Casting operator
- Convert operator
- Conditional Operator
- Switch operator
- Translate operator
- Value operator
- LET Operator
k) FOR Loop
l) Reduce Statement
m) New Open SQL Statement
- APPEND
- MODIFY
- UPDATE
- DELETE
n) New Native SQL statement
- INSERT
- UPDATE
- MODIFY
- DETELE
o) New SQL Queries
- Select Statement using inline Declarations
- Select statement with joins using Inline Declarations
- Select statement for all entries using line Declarations.
- Select statement joining one ITAB and One DB Table
- Select statement using unions.
- Select statement using SUM keyword
- Select statement using CASE Statement
- Select statement using Associations.
- Select statement using MIN and MAX key words
- Select statement using Group BY and ORDER BY Clause
- ABAP CTE’s
- RANK Functions
- DENSE RANK Function
- Select Query using CDS views
Migration steps/tools from SAP S4 HANA
- SQLM – SQL Monitor
- ATC – ABAP Test Cockpit
- SLIN – Extended syntax check
- SCI – Code inspector
Installation of Eclipse / SAP HANA Studio
Adding SAP ABAP Development Tools in Eclipse
Adding SAP system to Eclipse/SAP HANA Studio
Core Data Services (CDS View)
- a.What is CDS view
  b.Different types of CDS views
  - Define View
  - View with joins
  - View with associations
  - Parameter-based CDS view
  - CDS View extension
    - - Extend CDS view
    - CDS View using Table functions
    - CDS View converting into OData
    - CDS with Associations as OData service and accessing via Navigation
- c) Using Session variable in CDS view
- d) Built in Functions in CDS view
  - CAST Functions
  - Numeric Functions
  - String Functions
  - Conversion functions
    - - FLTP_DEC
- e) Virtual elements in CDS view
- f) Virtual Data models
  - Interface Views
    - - BASIC Views
    - Consumption Views
- g) Creating a FIORI tile for consumption CDS view using Custom Analytical App Query
- h) Value Helps Using
  - Foreign Key associations
  - Modeled Value Help views
SAP IDA using CDS — SAP Integrated Data access model using CDS View
OData Services:
introduction to SAP NetWeaver Gateway and ODATA
Usage of the SAP NetWeaver Gateway
Overview of the ODATA Services
Overview of the ODATA Services Metadata document.
Architecture of the SAP NetWeaver Gateway.
ODATA Service Generation technique.
Technical Components involved
Creating OData Service in SAP NetWeaver Gateway (Code Based)
Reading and filtering data (Code Based)
Development life cycle of SAP NetWeaver Gateway
Hub deployment and Embedded Deployment
Creating, Reading, Updating, deleting Entry of OData Service. (Code Based) i.e CRUD Operation.
Function Import (Code Based)
File Upload and download (Code Based)
Map to Data Source
Service Generation using RFC
EXPAND, Create DEEP Entity and BATCH

AMDP - ABAP Managed Data Base procedure

a) What is AMDP?
b) Types of AMDP method
- Database procedure
- Date base functions
c) Passing Parameters in AMDP method
d) Passing Select options
- AMDP Method
- CDS Table functions
e) Learning SQL Scripting for AMDP
- Passing Select options/Range
  - - AMDP Method
- AMDP OOPS Operations
  - - Inheritance
- Data declarations
  - Defining Variable with
    - - Build-In types
      - user Defined types
  - Changing variable/Changing Table
- Internal table operations

CRUD & Exception Handling Using AMDP

CASE Statement in AMDP
How to Perform CRUD operations
- - INSERT
  - UPDATE
  - UPSERT
  - DELETE
JOINS – INNER and LEFT OUTER JOINS
UUID Generations
ROW Number(), Partition BY, RANK Functions
DEFAULT NULL
Defining Exit handler in AMDP
AMDP Filtering

g. FUZZY Search and BADI operations using AMDP

UNION & UNION ALL
UPPER()/ UCASE() & LOWER Functions
IFNULL and NULLIF Functions
DATE Functions
FUZZY functions
Parallel processing Using AMDP – MAP_MERGE
What is AMDP BADI
- - FallBack class in AMBP BADI
  - Filter in AMDP

Course Duration: 30h

Course level:All Levels

No prerequisites are required, but having knowledge in the following areas might benefit:
Fundamental programming skills (Java, C++, etc.).
Knowledge of database concepts and SQL queries.
General understanding of database management systems.
Skills in data modeling concepts (entities, attributes, relationships).
Strong analytical skills for efficient solution development.
Effective communication skills for collaboration and stakeholder interaction.

Talk to Our Career Advisor

FAQ'S

No, our course warmly welcomes beginners, ensuring a smooth learning curve for all enthusiasts.

SAP ABAP HANA leverages the capabilities of the SAP HANA database, offering enhanced data processing and a sophisticated application design.

You'll have the skills to work on diverse projects, from database optimization to creating high-performance analytics applications.

Yes, the course includes practical exercises that allow you to apply your knowledge in real-world scenarios, enhancing your understanding.

By mastering SAP ABAP HANA, participants can advance their careers as SAP consultants, developers, and experts in high-demand technologies.