Day 0: Topics Covered

-


✅ Topics Covered (with Deep Dive & Hands-On)

Area

Topics

Days

CDS Views

Basic CDS, Associations, Joins, VDM (3-layer), UI Annotations, DCL, OData Publish,CDS View with Parameters

✅ Covered in (Days 1–6, 7, 13)

CDS Annotations and OData Integration

CDS Annotations for Fiori Elements, URI Testing, $filter, $expand, $metadata, Service Activation /IWFND/MAINT_SERVICE

✅ Covered in (Day 7)

AMDP

Syntax, SQLScript inside AMDP, Marker Interface, DML (Insert/Update/Delete), Exception Handling, Advanced JOINS/CASE/IF, Aggregation

✅ Covered in(Day 8–9)

Table Functions (TF)

CDS TF definition, AMDP logic, TF vs CDS vs AMDP, SQLScript inside TF

✅ Covered in(Day 10)

Real-Time Use Cases

Sales Order Fulfillment Dashboard (CDS+TF+AMDP+DCL+UI), Complex SE38 to CDS-TF-AMDP conversion

✅ Covered in(Day 11–13)

Authorization

DCL (Data Control Language), Role-Based Restriction (Sales Org-based)

✅ Covered in(in 3-layer project and DCL views)

Performance & Optimization

Pushdown, ST05, SAT, Explain Plan, Indexing/Buffering, Decision logic for CDS/AMDP/OpenSQL

✅ Covered in (Day 12)








 

Comments

Post a Comment

Popular posts from this blog

Day 1: Introduction to ABAP on HANA

-
  Day 1: Introduction to ABAP on HANA What is ABAP on HANA? Code Pushdown concept Differences: Classical ABAP vs ABAP on HANA Tools: Eclipse/ADT, HANA Studio vs SE80 Setup environment (if needed) Tasks : Read SAP Help documentation Watch SAP DevTuts video (YouTube/learning.sap.com) Write Hello World CDS view in ADT 1️⃣ What is ABAP on HANA? Verified Source : SAP Help: ABAP on SAP HANA ABAP on HANA is not a new language — it's the modern way to write ABAP code that uses SAP HANA’s in-memory capabilities . It focuses on performance, clean architecture, and code pushdown to the database. 2️⃣ Code Pushdown Concept Verified Source : SAP Blog - Code Pushdown Explained Traditional ABAP fetches all data, then filters it in memory. With HANA, logic should be executed at the DB level (pushdown), using: CDS Views AMDP (ABAP Managed DB Procedures) Table Functions Benefit : Less data transfer = Faster, more efficient programs. 3️⃣ Classical ABAP vs ABAP on HANA Feature Classical ABAP ABAP on...
Read more

Day 3: CDS Intermediate – Filters & Expressions

-
  ✅ 𝗗𝗮𝘆 3 : CDS Intermediate - Filter and Expression  Where conditions Parameters COALESCE, CASE, Arithmetic expressions Value help with @ObjectModel and search help annotations Hands-on : CDS view with parameter & expression field Add @Search.defaultSearchElement 📌 1. Using WHERE Conditions in CDS Views In CDS views, the WHERE clause filters data at the database level, enhancing performance by retrieving only relevant records.​ Medium Syntax: define view entity ZI_CustomerFilter   as select from kna1   where land1 = 'IN' {   key kunnr,       name1,       ort01 } Key Points: The WHERE clause applies conditions directly to the data source. Fields used in the WHERE clause need not be part of the SELECT list. Aggregate functions are not permitted within the WHERE clause.​ SAP Help Portal For more details, refer to the SAP Help Portal on WHERE clauses . 📌 2. Utilizing Parameter...
Read more

Day 2: CDS View Basics

-
Click Here To Explore Day 1: Introduction to ABAP on HANA Day 2: CDS View Basics Syntax and structure of CDS Data elements, labels, associations, joins Types: Basic View, Composite View Predefined functions Annotations: @AbapCatalog, @EndUserText Hands-on : Create 2–3 CDS views with associations Practice INNER JOIN, LEFT OUTER JOIN 📘 Syntax and Structure of CDS Views SAP recommends using the DEFINE VIEW ENTITY syntax for defining CDS views, especially in S/4HANA and RAP models. This approach simplifies the syntax and eliminates the need for certain annotations like @AbapCatalog.sqlViewName . Example: @AbapCatalog.viewEnhancementCategory: [#NONE] @AccessControl.authorizationCheck: #NOT_REQUIRED @ EndUserText .label: 'Customer Basic View' @Metadata.ignorePropagatedAnnotations: true @ObjectModel.usageType:{ serviceQuality: #X, sizeCategory: #S, dataClass: #MIXED } define view entity ZDEMO_Customer as select from snwd_bpa { key node_key as GenericNo...
Read more