SAP ABAP On HANA | Native HANA | AMDP | CDS |

Focused View

Sree Harsha Reddy

14:01:16

97 View

1. Native HANA Development

1.1 Working with HANA Studio.docx

1. Working with HANA studio, Schema, Table creation , Data Insertion etc...mp4

42:17

2.1 Foreign key relationship.docx

2. FOREIGN KEY CONSTRAINT, ON DELETE CASCADE,DELETE RESTRICT.mp4

32:33

3.1 SET SCHEMA.docx

3. Comments , Triggers.mp4

28:35

4.1 Hana 5.doc

4. Sequence, Triggers few more examples , Introduction to Procedures.mp4

30:21

5.1 9th Feb Examples.doc

5. Procedures with and without parameters like IN, Out , IN & OUT.mp4

13:39

6. Procedure to retrieve data from DB table and assign to local internal table.mp4

05:31

7.1 HANA 7.doc

7. Procedure parameter referring to DB Table, Table Type Creation using UI.mp4

40:42

8. Generating column view with input parameter , If Endif, Case Endcase, While end.mp4

38:00

9.1 HANA 9 Notes.doc

9. Cursors, cursor for loop.mp4

38:21

10.1 HANA 10 NOTES.doc

10. Static SQL, Dynamic SQL, SQL functions, DATETIME functions , Number Functions.mp4

46:07

2. Consuming Stored Procedures of HANA DB in ABAP Reports (ADBC) (Procedure Proxy)

1.1 adbc.zip

1.2 db proxies.zip

1.3 Hana 11 Notes.doc

1. Steps to use ADBC ( Working with ADBC ).mp4

51:30

2. Creating Database procedure proxy Part 1.mp4

28:32

3. Creating Database procedure proxy and consuming in report program Part 2.mp4

37:24

4. Consuming Stored Procedure in ABAP Reports using ADBC.mp4

37:10

5. Consuming modified stored procedure in ABAP reports.mp4

10:38

6.1 22nd Feb Examples.doc

6. Exception Handling in ABAP On HANA.mp4

22:45

7.1 23rs Feb Examples.doc

7.2 stored procedures vs functions.zip

7.3 user defined functions.zip

7. Functions and types of functions.mp4

20:42

8.1 26th Feb Examples.doc

8. ARRAYS in ABAP On HANA.mp4

35:20

9.1 hana note.zip

9.2 HANA NOTES.doc

9. One more example using ARRAYs , Functions, Procedures.mp4

24:56

10.1 HANA Notes.doc

10. Order by clause , group by clause , Having clause , Delete, Truncate, commit,.mp4

30:20

11.1 HANA Notes.doc

11. Database Views.mp4

10:50

12.1 CE FUNCTION NOTES.docx

12. CE FUNCTIONS IN ABAP ON HANA.mp4

14:11

13.1 CE FUNCTION NOTES.docx

13. CE FUNCTIONS PART 2.mp4

20:19

3. AMDP (ABAP MANAGED DATABASE PROCEDURE)

1.1 AMDP.docx

1. AMDP Introduction and sample program.mp4

26:24

2.1 AMDP 3.docx

2. Passing Parameters to AMDP.mp4

38:23

3.1 AMDP 3.docx

3. Select-option functionality in AMDP.mp4

27:02

4. CDS ( Core Data Services ) Views

1.1 cds1.docx

1. Simplesample program on CDS views.mp4

14:48

2. CDS views with parameters CDS Views with Functions and Arithmetic Expressions.mp4

33:13

3. CDS View with multiple parameters, association, and consuming in report.mp4

23:06

4. CDS Table functions.mp4

17:37

Description

SAP ABAP On HANA, with Native HANA , Stored Procedures, ADBC, AMDP, CDS

What You'll Learn?

Native HANA Development
Stored Procedures
ADBC (ABAP DATABASE Connectivity)
AMDP (ABAP Managed Database Procedures)
IDA (Integrated Data Access)
CDS (CORE DATA Services)
HANA Modeling

Who is this for?

For ABAP Developers who want to upgrade their skills to ABAP On HANA

What You Need to Know?

GOOD Knowledge in ABAP and OOPS ABAP is required

More details

Description
SAP HANA Introduction
Features and Architecture of HANA Database
ABAP HANA Introduction
Role of ABAP consultants in SAP HANA
Data to Code Vs Code to Data Approach
Introduction to HANA Studio
Native HANA Development
Introduction to SQL and Database Objects
Row Store Table Vs Column Store Table
Database Tables â€“ CRUD Operations
Transaction Control Statements
Order By, Group By, Having, Where Clauses
Primary key and Foreign Key Constraints
Global Vs Local Temporary Tables
Defining and Managing Triggers
Sequences
Synonyms
Altering Database Objects
Table Types
Procedures
Functions
Temporary Internal Tables
Conditional and Looping statements
Cursors
Exception Handling
Views
Arrays
Joins
Indexes
Standard SQL Functions
STORED PROCEDURES
Creating Stored Procedures
Creating Database Procedure Proxies
Consuming Stored Procedure from ABAP Reports
Scalar Functions
Table Functions
ABAP HANA
(PRE-REQUISITES: ABAP PROGRAMMING)
3
ADBC (ABAP DATABASE Connectivity)
Introduction to ADBC Framework
Consuming Select Queries in ABAP Reports using ADBC
Parameter Binding in Queries using ADBC
Consuming Stored Procedures using ADBC
Parameter Binding in Stored Procedures using ADBC
Accessing DDL and DML statements using ADBC
AMDP (ABAP Managed Database Procedures)
Introduction to AMDP and ADT
Creating AMDPâ€™s
Consuming AMDPâ€™s from ABAP Reports
AMDP Vs Stored Procedures
Passing Parameters to AMDP
Select-option functionality in AMDP
CDS (CORE DATA Services)
Introduction and Components of CDS Views
CDS simple views
Consuming CDS views from ABAP Reports and ALV IDA Reports
CDS views with parameters
CDS Views with Functions and Arithmetic Expressions
CDS Views with Joins and Associations
CDS view Implemented in AMDP Table Functions

Who this course is for:
For ABAP Developers who want to upgrade their skills to ABAP On HANA

User Reviews

Rating

average 0

Total votes0

Focused display

SAP ABAP

Sree Harsha Reddy

Instructor's Courses

My name is Sree Harsha Reddy, I have 10 years of experience in SAP as an ABAP consultant, and 6 years of experience as ABAP trainer. Had trained nearly 1000+ students in my carrier and also worked as a corporate trainer in few MNC companies. i am specialized in giving training of core abap topics with in depth and incomparable and subject guaranteed content.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.