|
SQL SCRIPT, AMDP & CDS MASTERY
|
Preview
|
|
|
ESSENSE OF ABAP ON HANA | CDS_SQL_SCRIPT_AMDP_OVERVIEW Video
14:00
|
Preview
|
|
|
Essence of ABAP ON HANA_Syllabus
(5 pages)
|
Preview
|
|
Class 1 | SQL Script Intro etc.
|
Preview
|
|
|
Class 1 - Code Pushdown, SQL Script Intro, Data type, Declarative, Imperative, AMDP Example, Shema etc
111:00
|
Preview
|
|
|
Class 1 - Note
(13 pages)
|
Preview
|
|
|
Class 1 - Assignment 1
|
Preview
|
|
Class 2 | SQL Script Basic constructs - IF ELSE, WHILE LOOP, Debugging etc.
|
|
|
|
Class 2 - SQL Script - IF ELSE, WHILE LOOP, Debugging etc
120:00
|
|
|
|
Class 2
|
|
|
|
Assignment 2
|
|
|
Class 3 -Anonymous Block | FOR LOOP | DB Cursor | etc.
|
|
|
|
Class 3 - Anonymous Block, DB Cursor, ARRAY etc
127:00
|
|
|
|
Assignment 3
|
|
|
|
Class 3
|
|
|
Class 4. Different Attributes of Cursor,SQL Exception,
(120:00)
|
|
|
|
Class 4
(21 pages)
|
|
|
|
Class 4
|
|
|
|
Assignment 4
|
|
|
Class 5: RETURN, CONTINUE, BREAK, DB SYSTEM VARIABLES etc
|
|
|
|
Class 5 - Array Different Function, DB System Variables,Break, continue, return,
104:00
|
|
|
|
Class 5
|
|
|
Class 6 | POC and UDF
|
|
|
|
Class 6 - POC & UDF
111:00
|
|
|
|
Class 6
|
|
|
Class 7 | Temporaray Table ( Internal Table ) Operations - Search , Emptiness check etc.
|
|
|
|
Class 7 - SQL Script Temporaray Table Operations search, existence check etc
96:00
|
|
|
|
Class 7
|
|
|
|
Assignment 7
|
|
|
|
All Codes Till Class 7
|
|
|
|
aug_cds_sql_script_amdp_batch
|
|
|
Class 8 - SORT, DUPLICATE,OIA,AMDP
|
|
|
|
Class 8 - SORT, DUPLICATE,OIA,AMDP
104:00
|
|
|
|
Class8
|
|
|
|
OIA USING SQL SCRIPT
|
|
|
|
aug_cds_sql_script_amdp_batch
|
|
|
Class 9
|
|
|
|
Class 9 - Refresh, Deault NULL etc
115:00
|
|
|
|
Class 9 REFRESH, DEFAULT NULL etc oia
(16 pages)
|
|
|
|
Class 9 Refresh, DEFUALT NULL etc oia
|
|
|
|
aug_cds_sql_script_amdp_batch
|
|
|
Class 10
|
|
|
|
Class 10 - APPLY FILTER, CONCATENATION etc
121:00
|
|
|
|
Class 10 - APPLY FILTER, CONCATENATION etc
|
|
|
|
Assignment 10
|
|
|
Class 11 | CDS | Parameterized CDS
|
|
|
|
Class 11 - CDS Introduction, Parameterized CDS View etc
|
Preview
|
|
|
Class 11
|
Preview
|
|
|
Assignment 11 - CDS
|
|
|
Class 12 | CDS | Association - Part 1
|
|
|
|
Class 12 - CDS Association - part 1
|
|
|
|
Class 12 - CDS Association - part 1
|
|
|
|
Assignment 12 - Association
|
|
|
Class 13 | Association Deep Dive
|
|
|
|
Class 13_ Association Deep Dive
|
|
|
|
Class 13
|
|
|
|
Assignment 13
|
|
|
Class 14
|
|
|
|
Class 14 - Part1 - BY DEFAULT ANNOTATIONS
|
|
|
|
Class 14 - Part 2 - Inbuilt functions, case when,TF
|
|
|
|
Class 14 - Default Annotations and Tabel functions
|
|
|
|
Assignment 14
|
|
|
Class 15
|
|
|
|
Class 15 - VDM
|
|
|
|
Class 15 - VDM
|
|
|
|
Assignment 15
|
|
|
Class 16
|
|
|
|
Class 16 - list report and Master detail TRANSIENT PROVIDER
|
|
|
|
Class 16 - list report and Master detail TRANSIENT PROVIDER
|
|
|
|
Assignment 16
|
|
|
Class 17 | EXTENDED CDS | CDS and BOPF Integration
|
|
|
|
Class 17 - CDS Extension and BOPF integration with CDS
|
|
|
|
Class 17
|
|
|
|
Assignment 17
|
|
|
|
CDS_BOPF_INTEGRATION
|
|
|
Class 18
|
|
|
|
Class 18 | Part 1 | DCL and CDS peroformance
|
|
|
|
Class 18 - Part 2 | CDS View Entity
|
|
|
|
Class 18
|
|
|
Full PPT + All Program Files
|
|
|
|
CDS_BOPF_INTEGRATION
|
|
|
|
CDS_TEXT_FILE
|
|
|
|
All SQL Script Related Codes
|
|