🗄️

CDS View Generator

CDS

Generate SAP Core Data Services (CDS) views with visual table selection, JOIN definitions, field selection, and automatic annotations for Fiori Elements.

View Name

Mode

Main Table (FROM)

Joins

No joins yet. Click "Add Join" to add one.

Fields (SELECT)

Key

Generated CDS DDL

@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
}

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.

All Tools

🔍OData Filter Builder 🗄️CDS View Generator 📅SAP DATS / TIMS Converter 🔄JSON to ABAP Structure 🔐Base64 Encoder / Decoder { }JSON Formatter & Validator