CDS View Generator
CDSGenerate SAP Core Data Services (CDS) views with visual table selection, JOIN definitions, field selection, and automatic annotations for Fiori Elements.
Main Table (FROM)
Joins
No joins yet. Click "Add Join" to add one.
Fields (SELECT)
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'ZI_Material'
define view entity ZI_Material
as select from MARA as _Mara
{
key _Mara.MATNR as Material,
_Mara.MTART as MaterialType
}Advertisement
About CDS View Generator
Every ABAP CDS view starts with the same boilerplate — @AbapCatalog annotations, a SELECT FROM clause, key fields, associations — and typing it from memory is where typos creep in. This generator lets you pick source tables, define joins and key fields visually, then emits syntactically valid CDS DDL with the right Fiori Elements annotations already in place.
How to use this tool
- Select your main database table or CDS view as the FROM source.
- Add JOIN or association targets and map the ON conditions between fields.
- Choose which fields to expose and mark key fields for the entity.
- Toggle common annotations (@AccessControl, @EndUserText.label) as needed.
- Copy the generated CDS DDL source into ADT and adjust naming to your project's conventions.
All processing happens locally in your browser. No data is sent to any server. Your SAP code and business data remain private at all times.
Frequently Asked Questions
What is a SAP CDS View?
A SAP Core Data Services (CDS) View is a database view defined using CDS Data Definition Language (DDL). It is the foundation of SAP S/4HANA data models and Fiori Elements applications.
Can I generate CDS views for RAP (Restful ABAP Programming)?
Yes! The generator includes RAP-specific annotations like @AccessControl, @Metadata.layer, and the basic structure for Behavior Definitions. Select "RAP Mode" to enable these annotations.
What join types are supported?
The CDS View Generator supports INNER JOIN, LEFT OUTER JOIN, and RIGHT OUTER JOIN between database tables. You can define multiple joins in a single view.
Advertisement