kingers Posted April 23 Report Share Posted April 23 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 HANAhttps://voltupload.com/uimxpprgbwjt/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.z01https://voltupload.com/7jmconm7mzq0/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.z02https://voltupload.com/qlp15fce5h46/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.z03https://voltupload.com/4h2hp718kqir/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.z04https://voltupload.com/fovs2d63wahk/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.z05https://voltupload.com/wtecjq06uasr/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.z06https://voltupload.com/qdadthpqlmbh/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.ziphttps://rapidgator.net/file/d5c67d3c0c1b1c4a1275ff2ca01e014b/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.z01https://rapidgator.net/file/711792486fcbcd7d35c5a2ce4c7f9831/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.z02https://rapidgator.net/file/78a6ee59d2680aedce82a38f296c25c7/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.z03https://rapidgator.net/file/95c14d168dc02754f6386cc3676e2b44/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.z04https://rapidgator.net/file/7640489384843fe360a65265a3219875/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.z05https://rapidgator.net/file/f5df8e966e8410b031f7b570d1728605/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.z06https://rapidgator.net/file/e71d0179d6a25fefb4d29a82e22c2954/SAP_ABAP_On_HANA_Native_HANA_AMDP_CDS.zipFree search engine download: SAP ABAP On HANA Native HANA AMDP CDS Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now