Sign Up Complete your profile

Name *

Email *

Create Password *

Mobile *

Experience in ABAP? * I am Fresher/Want to start career in ABAP I am Functional - Looking to enhance ABAP Debugging skill 1-5Years 5-10Years 10-20Years 20+Years

Which Course you are looking for? *

Have a referral code?

By signing up, I agree to the Terms of Use and Privacy Policy.

Unable to Login? We are here - pankajkumaram@gmail.com

SQL SCRIPT, AMDP, CDS MASTERY

Language: English

Instructors: Pankaj Kumar

PREVIEW Enroll in Course

Description

This course helps you to master the optimization of Advanced Business Application Programming applications that gives access to data stored in the In-memory Database.

It covers the SQL Script concept from Basic to Advance which will help you to write the complex business logic efficiently with the help of AMDP. With this training your AMDP concept will be Crystal clear and you will come to know where, when and How to use.

With AMDP you can use SQLScript procedures and CDS table functions from ABAP programs which Accelerate your customer developments in S/4HANA and have great client experience.

You will also learn about CDS - Core Data Services which is core of all future ABAP Enhancement like FIORI Elements, Restful ABAP Programming Model and Cloud Application Programming Model.

In current scenario - This is must learn subject to sustain in SAP technical Domain. Else, You will be outdated.

We'll be also discussing about BOPF integration with CDS and will be creating Transactional App for same.

This will help you to make happy your client - because your client can access it from Mobile and Table etc.. It's Super cool. It's development is also very fast.. Don't have write much code, Just you have to use the framework and a little or no code based on requirement.

This investment in yourself to groom to be updated in technology is worth.

This training will also help you switch your job change because we'll be covering the important Q & A during Class also we'll be covering Test Scenario ( using simple examples ) to make concept clear by writing the code.

You can Check out the Rough Class wise Break-up in below section.

Push your code to HANA Layer"- by Learning SQL SCRIPT, AMDP and CDS Today

Who Training Is For

Fresher ABAPER or Experienced ABPER |Techno-Functionals who wants to upgrade with CDS and AMDP for better career growth and visibility
Technical Architect to decide which approach to follow for better performance
Manager/Project Manager to Understand and decide if the current project development should follow the CDS, AMDP approach or not

Points to be Covered

Class 1:

What is SQL Script, Why SQL Scripts, When SQL Script
The Important Data types: SQL Script
Containers – 3 Different types of Containers for SQL Script
What are Anonymous Functions – With Examples
Why AMDP?
What is AMDP?
Why AMDP is preferred over Directly creating Stored Procedure for an ABAPERs
How to use FOR LOOP | DO – ENDDO in SQL SCRIPT
What is Procedure (Stored Procedure)
What is Declarative Statement & Imperative Statement
Using Data Element in AMDP Procedure function
Calling a procedure from another procedure

Class 2:

IF ELSE
While Loop
While Loop with BETWEEN
Temporary table in SQL SCRIPT
DB Cursor
Parameterized DB cursor
SQL Exception
Exception handling Example
Handle the Exception for specific error code

Class 3:

Example to Handle Multiple Exceptions
TRIM_ARRAY and Cardinality
Why DB Cursor?
DB System Variables
How to Debug a Procedure
Creating Table
User Defined Functions
Table UDF

Class 4:

SQL Script for an ABAP Developer - From Internal Table Perspective
Example How to Declare an Internal Table in AMDP
How to Search Internal Table and get the index in AMDP
How to find total number of records in an Internal table using AMDP(RECORD_COUNT)
Existence Check of a record in an internal table using AMDP
How to Insert New Records in Internal Table in AMDP
How to check Emptiness Check of an Internal Table (IS_EMPTY ())
What is the similar statement to MODIFY in AMDP (UPSERT)
What are the different Date Functions available in AMDP?

Class 5:

Different Functions
How to use Global Variable in AMDP using SET and UNSET
DEFAULT NULL
EXCEPT OPERATOR
AMDP Function

Class 6:

OIA using SQL Script - A Real time example with SAP test data
DB procedure Proxy (Overview)

Class 7:

CDS - What,why,How
CDS Common Questions and Answer
SQL View and CDS View
Annotations
Aggregate Functions
CDS with Parameter
CDS Table Functions

Class 8:

Associations
Path Expression
ADHOC Associations and Exposed Associations
Inner Join in Association using INNER

Class 9:

Case and When in CDS
ODATA using CDS
CDS Table Functions
Virtual Data Model
Basic Composite and Consumption

Class 10:

CDS and BOPF Integration
Develop a Transactional App using CDS and BOPF.

Class 11:

CDS Performance
Fiori Elements - List Report

Course Curriculum

How to Use

After successful purchase, this item would be added to your courses.You can access your courses in the following ways :

From the computer, you can access your courses after successful login
For other devices, you can access your library using this web app through browser of your device.

Reviews

SAPTECH MADE EASY

Declaration: SAPTECH MADE EASY is not an authorized SAP Partner. Any course, training or any other service provided at SAPTECH MADE EASY or by Pankaj Kumar are not associated, affiliated, authorized, endorsed by, or in any way officially connected with SAP organization. SAP is a registered trademark of SAP AG in Germany and many other countries. SAPTECH MADE EASY and Pankaj Kumar both are NOT associated with the SAP organization. We do not conduct any SAP Certification training programs

Enroll in Course

SQL SCRIPT, AMDP AND CDS Mastery

Lifetime

₹9999

1 Year Plan

Till 365 days

₹4999