Help
Sap Abap On Hana | Native Hana | Amdp | Cds |
Published 4/2024
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English
| Size: 7.50 GB[/center]
| Duration: 14h 1m
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
Requirements
GOOD Knowledge in ABAP and OOPS ABAP is required
Description
SAP HANA IntroductionFeatures and Architecture of HANA DatabaseABAP HANA IntroductionRole of ABAP consultants in SAP HANAData to Code Vs Code to Data ApproachIntroduction to HANA StudioNative HANA DevelopmentIntroduction to SQL and Database ObjectsRow Store Table Vs Column Store TableDatabase Tables - CRUD OperationsTransaction Control StatementsOrder By, Group By, Having, Where ClausesPrimary key and Foreign Key ConstraintsGlobal Vs Local Temporary TablesDefining and Managing TriggersSequencesSynonymsAltering Database ObjectsTable TypesProceduresFunctionsTemporary Internal TablesConditional and Looping statementsCursorsException HandlingViewsArraysJoinsIndexesStandard SQL FunctionsSTORED PROCEDURESCreating Stored ProceduresCreating Database Procedure ProxiesConsuming Stored Procedure from ABAP ReportsScalar FunctionsTable FunctionsABAP HANA(PRE-REQUISITES: ABAP PROGRAMMING)3ADBC (ABAP DATABASE Connectivity)Introduction to ADBC FrameworkConsuming Select Queries in ABAP Reports using ADBCParameter Binding in Queries using ADBCConsuming Stored Procedures using ADBCParameter Binding in Stored Procedures using ADBCAccessing DDL and DML statements using ADBCAMDP (ABAP Managed Database Procedures)Introduction to AMDP and ADTCreating AMDP'sConsuming AMDP's from ABAP ReportsAMDP Vs Stored ProceduresPassing Parameters to AMDPSelect-option functionality in AMDPCDS (CORE DATA Services)Introduction and Components of CDS ViewsCDS simple viewsConsuming CDS views from ABAP Reports and ALV IDA ReportsCDS views with parametersCDS Views with Functions and Arithmetic ExpressionsCDS Views with Joins and AssociationsCDS view Implemented in AMDP Table Functions
Overview
Section 1: Native HANA Development
Lecture 1 Working with HANA studio, Schema, Table creation , Data Insertion etc..
Lecture 2 FOREIGN KEY CONSTRAINT, ON DELETE CASCADE,DELETE RESTRICT
Lecture 3 Comments , Triggers
Lecture 4 Sequence, Triggers few more examples , Introduction to Procedures
Lecture 5 Procedures with and without parameters like IN, Out , IN & OUT
Lecture 6 Procedure to retrieve data from DB table and assign to local internal table
Lecture 7 Procedure parameter referring to DB Table, Table Type Creation using UI
Lecture 8 Generating column view with input parameter , If Endif, Case Endcase, While end
Lecture 9 Cursors, cursor for loop
Lecture 10 Static SQL, Dynamic SQL, SQL functions, DATETIME functions , Number Functions
Section 2: Consuming Stored Procedures of HANA DB in ABAP Reports (ADBC) (Procedure Proxy)
Lecture 11 Steps to use ADBC ( Working with ADBC )
Lecture 12 Creating Database procedure proxy Part 1
Lecture 13 Creating Database procedure proxy and consuming in report program Part 2
Lecture 14 Consuming Stored Procedure in ABAP Reports using ADBC
Lecture 15 Consuming modified stored procedure in ABAP reports
Lecture 16 Exception Handling in ABAP On HANA
Lecture 17 Functions and types of functions
Lecture 18 ARRAYS in ABAP On HANA
Lecture 19 One more example using ARRAYs , Functions, Procedures
Lecture 20 Order by clause , group by clause , Having clause , Delete, Truncate, commit,
Lecture 21 Database Views
Lecture 22 CE FUNCTIONS IN ABAP ON HANA
Lecture 23 CE FUNCTIONS PART 2
Section 3: AMDP (ABAP MANAGED DATABASE PROCEDURE)
Lecture 24 AMDP Introduction and sample program
Lecture 25 Passing Parameters to AMDP
Lecture 26 Select-option functionality in AMDP
Section 4: CDS ( Core Data Services ) Views
Lecture 27 Simple/sample program on CDS views
Lecture 28 CDS views with parameters CDS Views with Functions and Arithmetic Expressions
Lecture 29 CDS View with multiple parameters, association, and consuming in report
Lecture 30 CDS Table functions
For ABAP Developers who want to upgrade their skills to ABAP On HANA
https://voltupload.c...NA_AMDP_CDS.z01
https://voltupload.c...NA_AMDP_CDS.z02
https://voltupload.c...NA_AMDP_CDS.z03
https://voltupload.c...NA_AMDP_CDS.z04
https://voltupload.c...NA_AMDP_CDS.z05
https://voltupload.c...NA_AMDP_CDS.z06
https://voltupload.c...NA_AMDP_CDS.zip
https://rapidgator.n...NA_AMDP_CDS.z01
https://rapidgator.n...NA_AMDP_CDS.z02
https://rapidgator.n...NA_AMDP_CDS.z03
https://rapidgator.n...NA_AMDP_CDS.z04
https://rapidgator.n...NA_AMDP_CDS.z05
https://rapidgator.n...NA_AMDP_CDS.z06
https://rapidgator.n...NA_AMDP_CDS.zip
Free search engine download: SAP ABAP On HANA Native HANA AMDP CDS
