Unlock Your Potential with Expert Training at SKY Technologies!

• Code to Data and Data to Code paradigm/Code Push down/Bottom-up and Top-down.
• Row Store and Column Store.
• SAP ABAP CDS and HANA CDS
• Joining Concepts
• Interview Questions

• How many ways we can Create the CDS Views
• CDS Templates

                1. Define Views

                2. Define Views with Joins

                3. Define Views with Associations

                4. Define Views with Parameters

                5. Extend Views( Example will be shown you in Standard enhancement )

                6. Table Function with Parameters

                7. Projection View

                8. Interface View 

                9. Interview Questions

• What happens in the HANA DB?
• Explore Standard CDS Views
• How to call global classes in CDS Views
• Performance Improvement in CDS Views by Annotations (CDS Performance will be increased by more than 90% and will be shown you in system)
• Fuzzy Search in CDS Views 
• Aggregate Functions
• String functions
• Date functions
• Unit and Currency conversion in CDS
• How to Consume CDS Views in OData?
• How to fetch domain values in CDS View?
• Union and Union All
• Case Expression
• Authorizations in CDS Views
• VDM Types
• CDS fit in
• Best Practices on CDS Views

                1. Effective filter Push-Down

                2. Avoid filtering using DCL

                3. Avoid Unions far as possible

                4. Effective usage of Association and Joins

                5. Avoid Non-Equi Join

                6. Effective usage of Aggregations

• Tools to analyze our CDS Views

                1. Navigation from SQL View to DDL Source

                2. Display of SQL Create Statement

                3. Activate Annotation View

                4. Graphical Editor

                5. Dependency Analyzer

                6. Data Preview 

• Practical/Real Time Examples on CDS Views
• Interview Questions

• Normal
• AMDP method and its properties
• SQL Script
• How to Pass Select Options in AMDP
• Fuzzy Search in AMDP
• AMDP Debugging
• Call AMDP inside another AMDP 
• Real Time Object on AMDP
• Interview Questions

• How to Pass Select Options in IDA
• Set Report Header in IDA
• Remove Unwanted Fields
• Change Fields Level
• Aggregations in IDA
• Add toolbar in IDA
• Enable Single Row Selections(Double Click Event)
• Sorting of IDA Output
• Interview Questions

• In-Line Declarations
• Properties of Internal Tables
• Value Operator
• BASE Operator
• Conditional Operator
• Group by Functionality 
• Reduce Operator
• Filter Operator
• Operation of Corresponding Operator
• Let expression
• Table Expression - Read Alternative 
• Interview Questions

• Literals in select field list
• Arithmetic expression in Select
• Aggregation expression in Select
• String Operation in Select
• Case statement in Select
• COALESCE function
• Currency conversion in Open SQL
• Group by
• Having Clause
• Union and Union all in Select
• Window Expressions in ABAP SQL
• Interview Questions 

•  A complex report can be built by only Select query with a huge super-fast performance.