LATEST ARTICLES

CDS Arithmetic Functions – Ceil, Floor, Div (Integer), Division (Dec), Mod, Round & Aggregate...

CDS Arithmetic Functions Ceil, Floor, Div (Integer), Division (Dec), Mod, RoundCeil is 26 for a number 25.3 while Floor is 25 for the same number 25.3. Aggregate Expressions MAX MIN AVG SUM COUNTNote:Require a GROUP BY clause when aggregate functions are...

CDS String Functions(Concat, Instr, Left / Right, Length, Lpad / Rpad, Ltrim / Rtrim...

CDS String functions: • CONCAT(arg1, arg2) • LENGTH(arg) • LPAD/RPAD(arg, len, src) • REPLACE(arg1, arg2, arg3) • SUBSTRING(arg, pos, len) 

CDS Conversion Functions (CAST, Unit Conversion, Currency Conversion)

CAST Expression Supported Operands: Literal, column, path expression, build-in function, arithmetic expressionVarious data types in ABAP namespace supported Result length determined at activation time No nesting of CAST expressions Alias names required for resulting...

CDS Generic SQL Expressions – CASE expressions ( Simple CASE, Searched CASE & Nested...

CDS FunctionsGeneric SQL Expressions CASE Expressions 3 types of CASE expressions we have that are mentioned below:Simple CASE ExpressionThe projection list can contain columns that are based on a case differentiation. These columns can be...

CDS Annotations

Enrich CDS data models with additional metadata. Annotations begin with @Kinds of Annotations • AbapCatalog Annotations • AccessControl Annotations • Analytics Annotations • AnalyticsDetails Annotations • ClientDependent Annotations • Consumption Annotations • DataAging Annotations • DefaultAggregation Annotations • EndUserText Annotations • EnterpriseSearch Annotations • Environment...

CDS Views Basic Syntaxes : – Select *, Select columns, Select distinct, WHERE clause,...

1. CDS View - Select * Select * - selects all columns from the underlying data source.Output in Data Preview:2. CDS View - Select columnsComma separated list of names optional alias names with keyword ASAlternative Syntax select...

Introduction to Core Data Services

Application Design with SAP HANAWhat is Code Push Diagram?Why CDS was required? Issue 1: Large Semantic Gap between Task and SQL Code TodayIssue 2: SQL Complexity Leads to Imperative CodeCDS Brings Conceptual and Implementation Level...

What is SAP Hana? Software Components of SAP HANA ? Hardware & Software Innovations...

SAP HANA stands for High Performance Analytical Appliance. This flexible appliance (combination of hardware and software) runs independently of the data source and can be used to analyze large data volumes in real time...

Mesothelioma Settlement and verdict amounts? Mesothelioma Lawsuits Types?

Settlement and verdict amounts may depend on:A claimant’s diagnosis and medical history The number of companies sued Where the claim is filed Proof of negligence Lost wages, medical bills and other expensesAn experienced mesothelioma...

Mesothelioma Lawsuit Payouts & Settlements? Eligibility for Mesothelioma compensation? Compensation for family members applicable or...

Most mesothelioma settlements begin as lawsuits. History shows an overwhelming majority of cases end in a settlement before reaching the courtroom.Some very important Questions in your mind related to this. How do I apply for...