Please enable JavaScript.
Coggle requires JavaScript to display documents.
Muji ABAP CDS (Capabilities (Annotations (Client Dependency (Default…
Muji ABAP CDS
Capabilities
Arithmetic
Expr.
+,-,*, DIV
MOD()
CAST()
CEIL(), FLOOR()
Annotations
Buffering
Status
Client
Dependency
Default client
handling
Begin with @
Unit,
Quantity
Currency Code,
Amount
Buffering
Type
Conditional
Expr.
CASE
Nested CASE
String
Expr
&&,
SUBSTRING()
UNION[ALL]
Same no. of cols
Col types compatible
Aggregates
Joins
Concept
Uses DBI
Can be used with all SAP
supported DB platforms
OpenSQL-like
behaviour
Supports table buffering
Extension
of SQL
Annotations
Associations
Expressions
Similar to DDIC Tables/view
but enhanced capabilities
Infrastructure to create
semantically rich data models
Consumption
Data Preview
ALV
Open SQL
Components
View Entity
Generated on
DDLS activation
Name after
DEFINE VIEW
Need NOT have
same name as DDLS
Should NOT have same
name as SQL View
Used for typing of
local ABAP variables
Use in FROM
clause of SELECT of
New Open SQL
DDLS
object
Creation via
ADT only
Context menu on ABAP Project
New->Other Repository Object -> DDL Source
SQL View
View Entity's
DB representation
Created when
DDLS activated
Name in
AbapCatalog.sqlViewName
Mandatory
Annotation
Can be used in FROM
clause of SELECT. Not
recommended in New Open SQL
Data Sources
DDIC Table/View
Native HANA col
Views not possible
Another CDS
View/SQL View
(Stacking/Nesting)