SAP ABAP on S/4 HANA with CDS Embedded S/4 HANA Analytics
Important Concepts of our Training Program :| 1. ABAP programming on Suit on HANA |
| 2. ABAP programming on S/4 HANA concepts |
| 3. S/4 HANA CDS Embedded Analytics |
| 4. SAP ABAP programming for Fiori |
| — SAP WEB IDE for Fiori Developments |
| — BOPF Functionality |
| 5. S/4 HANA Migration concepts |
SAP ABAP on S/4 HANA
SAP ABAP on S/4 HANA with CDS Embedded Analytics on S/4 HANA 1809 and ABAP Programming model with Fiori is the advanced programming model which will helps abapers to push the complete business application logic into the HANA Database with the in memory capabilities of HANA 2.0 database application business logic will get executed in fration of seconds and business will get the benefit of Real time reporting of billons of rows of data.
To acheive speed of HANA database, SAP introducted advanced progrmming patterns i.e. HANA CODE PUSHDOWN Appraoches / Top Down Apporach programming model for SAP ABAP on HANA or SAP ABAP on S/4 HANA. In SAP ABAP on HANA, SAP introduced advanced programming models i.e. CDS ( Core Data Services ), AMDP ( ABAP Managed Database Procedires) and Advanced ABAP SQL Statements with this new programming concepts we can push complete business logic inside the HANA Database and get executed inside HANA Database and will get results in fraction of seconds even on billions of records.
SAP HANA INTRODUCTION
1.0 Introduction to SAP HANA
| 1.1 Evolution of HANA |
| 1.2 Introduction to SAP HANA |
| 1.3 Introduction to SAP In-Memory Strategy and Technology |
| 1.4 HANA compare to BWA |
| 1.5 SAP HANA Landscape |
| 1.6 SAP In-Memory Computing Product Strategy and Roadmap |
2.0 SAP HANA STUDIO Look & Feel
| 2.1 In-Memory Computing Studio |
| 2.2 Administration view |
| 2.3 Navigator View |
| 2.4 System Monitor |
| 2.5 Information Modeller |
3.0 SAP HANA Architecture
| 3.1 Architecture Overview |
| 3.2 IMCE and Surroundings |
| 3.3 Row Store |
| 3.4 Column Store |
| 3.5 Loading data into HANA |
| 3.6 Data Modeling concepts |
| 3.7 Reporting |
| 3.8 Persistent Layer |
| 3.9 Backup & Recovery |
4.0 Performance Tools in SAP HANA
| 4.1 Understand the Runtime Analysis (SE30) |
| 4.2 Understand the ABAP Trace (SAT) |
| 4.3 Understand the Code Inspector (SCI) |
| 4.4 Understand the SQL Trace (ST05) |
| 4.5 SQL Monitoring Tool (SQLM) |
| 4.6 SQL Performance Tuning Work List Tool(SWLT) |
5.0 Migration concepts and Prerequisites for
| 5.1 Suite on HANA Implementations |
| 5.2 S/4 HANA 1809 Implementations |
| GREEN Field Implementation of S/4 HANA |
| BROWN Field Implementation of S/4 HANA |
| 5.3 Types Cloud Implementations |
ABAP on HANA Consultant Role in S/4 HANA Migration
| 5.4 SAP S/4 HANA Migration Changes |
| 5.5 SAP S/4 HANA Performance Changes |
CDS Views
Core Data Services (CDS) views are the next generation programming model introduced by SAP in ABAP on HANA or ABAP on S/4 HANA. In normal ABAP views we will do only joining of the database tables but in Core Data Serivices views ( CDS ) along with joining of tables we can implement complete business logic also and on activation of CDS Views automicatically HANA Views will get created in HANA Database with business logic given in Core Data Services ( CDS ) views. When we call the CDS views and CDS Views will calls the HANA Views created in HANA Database and business logic will get executed completely in HANA Database and will get the results in seconds.
ABAP PROGRAMMING FOR HANA
6.0 Advanced ABAP SQL concepts for SAP HANA
| 6.1 Escape Host Variables |
| 6.2 Dynamic Declaration of Internal tables and work areas |
| 6.3 Arithmetic Expression Operations in HANA ABAP SQL |
| 6.4 IF then ELSE inside HANA ABAP SQL |
| 6.5 CASE Statements inside HANA ABAP SQL |
| 6.6 COALESCE Function in HANA ABAP SQL |
| 6.7 Advanced Filtering on ON CONDITION |
| 6.8 Advanced Joins on HANA ABAP SQL |
7.0 Core Data Services(CDS) ANALYTICS - CDS : DATA DEFINATIONS
| 7.1 CDS Define View Definition |
| 7.2 CDS Define View with Joins |
| 7.3 CDS Define View on View |
| 7.4 CDS View Extensions |
| 7.5 CDS Views with Input Parameters |
| 7.6 CDS Views with Associations |
| 7.7 CDS Define View with Annotations |
| 7.9 CDS Standard View Extensions/Ehancements |
| 7.10 CDS Define TABLE FUNCTIONS with PARAMETERS |
| 7.11 CDS Define ABSTRACT ENTITIES |
| 7.12 CDS ABSTRACT ENTTIES with PARAMETERS |
8.0 CORE DATA SERVICES : ACCESS CONTROL
| 8.1 CDS Authorization Object |
| 8.2 CDS FULL Access |
| 8.3 CDS User Data Access |
9.0 CORE DATA SERVICES : ASSOCIATION
| 9.1 CDS ASSOCIATIONS LEFT OUTER JOINS |
| 9.2 CDS ASSOCIATIONS INNER JOINS |
| 9.3 CDS ASSOCIATIONS FILTERS |
AMDP
ABAP Managed Database Procedures( AMDP) : is the concept built based on ABAP Object oriented concept and SAP HANA SQL Scripting Programming in SAP ABAP on HANA or SAP ABAP on S/4 hana. We will build the ABAP Class and by adding interface IF_AMDP_MARKER_HDB in the normal ABAP Classes will get converted into ABAP Mananged Database Procedute( AMDP ) and its class methods will allow us to write the SQL Script coding inside the ABAP Managed Database Procedures ( AMDP ) Class Methods. For every class method of ABAP Managed Database Procedures( AMDP ) system will create HANA Database procedures with the business logic written inside ABAP Managed Database Procedures( AMDP ). In SAPP ABAP on HANA or SAP ABAP on S/4 HANA it is one of the most efficent programming model .
CDS embedded Anlaytics with S/4 HANA 1809 and ABAP Programming model with Fiori : is the advaned programming model in ABAP on HANA or ABAP on S/4 HANA where ABAP on S/4 HANA Consultant can be build High complex OData projects and SAP Fiori anlytical Applications will simple steps without writing any SAP UI5 code or without creating any Odata Projects.
S/4 HANA CDS Embedded Analytics
10.1 Building CDS Views with S/4 HANA Features
| 10.11 CDS Basic Views |
| 10.12 CDS Composite Views |
| 10.13 CDS Consumption View |
| 10.14 Building CDS DIMENSION and FACT Views |
| 10.15 Building CDS CUBE’s with BW STAR SCHEMA Concept |
| 10.16 Building CDS Queries |
10.2 S/4 HANA CDS Annotations
| 10.21 VDM.viewtype : PRIVATE, PUBLIC |
| 10.22 Analytics.dataCategory : #DIMENSION, CUBE,FACT |
| 10.23 Anlaytics.dataExtraction.enabled |
| 10.24 Analytical.query : true |
| 10.25 OData.publish : true |
| 10.26 Search.searchable |
| 10.27 UI.selectionField.position: |
| 10.28 UI.lineItem , UI.hidden: true |
Exposing S/4 hana CDS Embedded View
10.3 Exposing CDS Embedded Views in Fiori Lanchpad
| 10.31 Details about FIORI Lanchpad |
| 10.32 Creating Fiori Catalogs |
| 10.33 Creating Fiori Tiles |
| 10.34 Configuring CDS Embedded Views in FIORI Lanchpad |
| 10.35 Automated ODATA Services for SAP UI5/FIORI |
10.4 Exposing S/4 CDS BW Reporting Tools
| 10.41 BW Bex Query Analyzer |
| 10.42 O Analysis for Office using CDS |
| 10.43 Query Browser |
10.5 Creating UI5 Developments using WEB IDE and CDS
| 10.51 Developing CDS Views with Filters, Aggregations, Selections |
| 10.52 Developing UI5 Application using WEB IDE |
| 10.51 Look and Feel of WEB IDE ADT |
| 10.52 Developing Fiori Analytical List Reporting |
| 10.53 Developing Fiori Transactional Reporting |
10.6 BOPF Functions
| 10.61 Overview of BOPF Functions |
| 10.62 BOPF CURD Operations |
| CREATE |
| UPDATE |
| READ |
| DELETE |
| 10.63 BOPF Functions: Debugging and Error Handling |
Prerequisite:
To attend training on SAP ABAP on S/4 HANA with CDS Embedded Analytics on S/4 HANA 1809 and ABAP Programming model with Fiori, need to have the basic knowledge of ABAP i.e. what are Database Tables and Internal Table concepts of ABAP.
We will conduct the training by considering that students don’t have any knowledge of HANA / ABAP on HANA / ABAP on S/4 HANA programming model. We will start from complete basic of SAP ABAP on S/4 HANA to the expert level of SAP ABAP on HANA or SAP ABAP on S/4 HANA with CDS Embedded Analytics on S/4 HANA 1809 and ABAP Programming model with Fiori.
SQL SCRIPT PROGRAMMING FOR HANA
11.0 SQL SCRIPTS Programming for SAP HANA
| 11.1 SQL Clause New Feature |
| 11.2 SQL Functions |
| 11.3 Using Tuple Variables |
| 11.4 Case Statements in SQL |
| 11.5 Group By |
| 11.6 Order By |
| 11.7 IS NULL/ NOT NULL |
| 11.8 Between |
| 11.9 LIKE Predicate |
| 11.10 Order Precedence |
| 11.11 Aggregate Functions |
| 11.12 UNION and UNION ALL |
| 11.13 Joining Table |
| à Inner Join |
| à Left Outer Join |
| à Right Outer Join |
| à Full Outer Join |
| 11.14 Data Manipulation |
| à Insert |
| à Update |
| à Delete |
| 11.15 Data Definition |
| à Create column table |
| à Alter Table |
| à Rename Table |
| à Drop Table |
12.0 ABAP Managed Database Procedures (AMDP)
| 12.1 AMDP Using PARAMETERS |
| 12.2 AMDP Using SELECT OPTIONS |
| 12.3 AMDP METHOD on METHOD Concept |
| 12.4 AMDP debugging using GUI and Eclipse Studio |
| 12.5 AMDP EXCEPTIONS Handling |
13.0 OO ABAP List Viewer with integrated Data Access ( IDA )
| 13.1 ABAP List Viewer (ALV) with Integrated Access to SAP HANA |
SAP HANA Side Car Approaches
Why only we ?
With our Professional Level Industrial training program on ABAP on S/4 HANA with CDS Embedded Analytics on S/4 HANA 1809 and ABAP Programming model with Fiori, participants will become experts and will be in a position to work in real time projects of ABAP on S/4 HANA with CDS Embedded Analytics on S/4 HANA 1809 and ABAP Programming model with Fiori like a experienced professionals.
Our trainers are highly skilled real time experts who are having more than 12+ years of experience in SAP ABAP and ABAP on S/4 HANA with CDS Embedded Analytics on S/4 HANA 1809 and ABAP Programming model with Fiori who deliver the training in a practical manner which helps participants to get the Real Time Knowledge on ABAP on S/4 HANA with CDS views with Pracitical exposure.
14.1.0 ADBC (ABAP DATABASE CONNECTIVITY) to SAP HANA
| 14.1.1 Accessing SAP HANA tables from ABAP |
| 14.1.2 Accessing SAP HANA Procedures from ABAP |
| 14.1.3 Pros and Cons of ADBC |
14.2.0 Secondary Database Connection to SAP HANA
| 14.2.1 Accessing SAP HANA tables from ABAP |
| 14.2.2 Pros and Cons of Secondary DB Connection |
SAP HANA ANALYTICAL MODELING
15.0 Creating SAP HANA Artifacts
| 15.1 Creating Packages |
| 15.2 Creating Delivery Units |
| 15.3 Creating SAP HANA Database (Column/Row tables) |
| 15.4 Creating SAP HANA Database Views |
| 15.5 Creating Authorization Objects |
| 15.6 Load data into SAP HANA tables using CSV Files |
| 15.7 Creating Sequences |
| 15.8 Creating Synonyms |
| 15.9 Creating SAP HANA Procedures |
| 15.10 Creating SAP HANA Functions |
16.0 Creating Attribute Views
| 16.1 Data Foundation and Semantics |
| 16.2 Calculated Columns |
| 16.3 Filters operations |
| 16.4 Attributes and Measures |
| 16.5 Data Analysis |
| 16.5.1 Raw Data |
| 16.5.2 Distinct Values |
| 16.5.3 Graphs |
About the Training
Oakrey provides Industrial Training of SAP ABAP on HANA, S/4 HANA, which contains 80% Practical Real Time Scenarios and 20% Theoritical part with which you will gain the real time knowledge as a more than 3 years experienced person in SAP ABAP on HANA, SAP S/4 HANA CDS Embedded Analytics, SAP S/4 HANA Modelling, HANA Migration Concepts, Sidecar HANA Approaches and Exposure to Business Object Reporting Tools. This training will help you to work as a more than 3 years experience S/4 HANA Consultant AND with this knowledge you can easily clear the Certification exam and Interviews and help you to get good Hikes in your salary.
Most of the Interview questions are covered in our LIVE Interactive Sessions and In the Training Materials prepared by the trainer. The training material will provide detailed information with step by step screenshots and explanation which you can easily refer anywhere even in your office while working in your project. Once after finishing this training, nothing will be left for you to learn in S/4 HANA. Our material will give you Real Time Project Oriented knowledge on SAP ABAP on HANA, SAP S/4 HANA CDS Embedded Analytics, SAP S/4 HANA Modelling, HANA Migration Concepts, Sidecar HANA Approaches and Exposure to Business Object Reporting Tools. So there is no need to search for any other books. We will provide Real Time Projects as ASSIGNMENTS on every scenarios of SAP ABAP on HANA, SAP S/4 HANA CDS Embedded Analytics, SAP S/4 HANA Modelling, HANA Migration Concepts, Sidecar HANA Approaches and Exposure to Business Object Reporting tools. You will get 24/7 Technical Support from our expert technical team
17.0 Creating Analytic Views
| 17.1 Creating Input Parameters |
| 17.2 Creating Restricted Columns |
| 17.3 Creating Calculated Columns |
| 17.4 Filter Operations |
18.0 Creating Calculated Views
| 18.1 Graphical Based Calculated Views |
| 18.2 Script Based Calculated Views |
| 18.3 Currency Conversion |
| 18.4 Unit of Measure Conversion |
19.0 Stored Procedures
| 19.1 Creating the Stored Procedures |
| 19.2 Debugging the stored Procedures |
20.0 User Management
| 20.1 Creation of Users |
| 20.2 Creation of Roles |
| 20.3 Creation of Role Hierarchy |
| 20.4 Assignment of users to roles |
| 20.5 Authentications |
| 20.6 IMCE Authorizations |
21.0 Consuming SAP HANA Views and Database Procedures in ABAP
| 21.1 Working with Views in SAP HANA Studio |
| 21.2 Consuming SAP HANA Views via Native SQL |
| 21.3 Accessing SAP HANA Views via External Views in ABAP |
| 21.4 Working with Database Procedures in SAP HANA Studio |
| 21.5 Calling SAP HANA Procedures in ABAP |
| 21.6 Calling SAP HANA Procedures via ABAP Database Procedure Proxies |
22.0 Transport of SAP HANA Objects
| 22.1 SAP HANA Transport — ABAP CTC |
| 22.2 SAP HANA Transport — Delivery Unit |
| 22.3 Schemas |
| 22.4 Import & Export |
| 22.5 Copying Objects |
23.0 XS ODATA Services
| 23.1 Exposing tables and views |
| 23.2 Defining relationship between tables |
24.0 Reporting Tools
|
24.1 Accessing the SAP HANA Views from Lumiro Reporting Tool |
| 24.2 Accessing the SAP HANA Views from Qlik Sense Reporting Tool |
| 24.3 Accessing the SAP HANA Views from Excel |
FOLLOW US ON :
SAP ABAP on S/4 HANA Demo
Day(s)
:
Hour(s)
:
Minute(s)
:
Second(s)
Popular Courses
SAP BW/4 HANA
SAP BASIS ADMINISTRATION