Ever found yourself writing repetitive validation handlers or debugging complex imperative code? Declarative programming in SAP Cloud Application Programming Model (CAP) offers a better way. Declarative programming means describing what you want to achieve rather than how to achieve it. Instead of writing step-by-step instructions, you express the problem itself and let the system determine the solution automatically.
There are a couple of benefits using a declarative approach:
In CAP, developers can declaratively define numerous CAP features - including queries and view definitions, input validations or annotation based constraints. The result? Less imperative code, consistent validations between backend and OData annotations, and logic that is intuitive to understand. This post walks you through the core concepts of declarative programming in CAP, covering declarative expressions, different kinds of input validations, how to use expressions as annotation values and the new @assert feature. These techniques work in both CAP Java and CAP Node.js.
With CAP, you can use declarative expressions in queries, view definitions, and calculated elements by defining them directly in your model. For example, you can use the exists predicate to select only those authors whose associated books contain elements with a price greater than 20:
Select from Authors { name } where exists books[price > 20.00]In another example, you can use declarative expressions to compute free seats on a flight:
entity Flights : cuid {\n ...\n max_seats : Integer;\n occupied_seats : Integer;\n free_seats : Integer = max_seats - occupied_seats;\n}In all cases you can reduce the need for imperative code by using declarative expressions.
Please read our documentation for further information about views and projections and calculated elements.
Instead of writing custom event handlers for every validation, CAP provides several built-in annotations that handle common scenarios declaratively. These validations are executed at the database layer, reducing round trips and enabling efficient error aggregation:
In the following example, you check that a description has a minimum length of 3 characters:
Description @assert.format: '.{3,}' @assert.format.message: 'Description too short’In CAP, Core Data Services (CDS) is used to define service definitions, data models, queries, and expressions. Using declarative annotations in CDS models reduces custom logic while keeping validations consistent across services and UI.
Learn more about event handlers in CAP Java and events in CAP Node.js , read our documentation on declarative constraints and check out DJ Adams’ blog post Constraints, expressions and axioms in action.
Annotations can use CXL (CDS Expression Language) expressions as values. This is particularly useful for instance-based authorizations. The following code snippet ensures that users can only read, update, or delete orders they created:
annotate Orders with @(restrict: [\n { grant: ['READ', 'UPDATE', 'DELETE'], where: (createdBy = $user) }\n]);Using parentheses ensures that the CDS compiler can validate and optimize the expression.
You can also use dynamic expressions in UI annotations. The compiler translates these expressions automatically to the corresponding OData annotations:
@UI.Hidden: (status <> 'visible')Learn more about expressions as annotation values.
If you are interested to learn more about CXL check out this mini-series on CXL by our Developer Advocate DJ Adams and Patrice Bender.
The @assert annotation is a new feature in CAP, released in December 2025. It enables complex, custom validations using CXL. This annotation provides a powerful way to enforce specific checks on inputs and raise appropriate errors if those checks fail. Error messages can be configured as either static strings or i18n message keys.
The annotation takes the form @assert: (<constraints>), where <constraints> are standard SQL case expressions containing one or more 'when' branches. The following example shows how to validate that a description is specified correctly:
annotate TravelService.Travels with {\n Description @assert: (case\n when Description is null then 'Description must be specified'\n when trim(Description) = '' then 'Description must not be empty'\n when length(Description) < 3 then 'Description too short'\n end); \n}It is also possible to formulate complex validations that would typically require a lot of code. The following example validates that the end date of a trip is not before the begin date and that all flight bookings fall within the travel period:
EndDate @assert: (case\n when EndDate < BeginDate then 'End Date must be after Begin Date'\n when exists Bookings [Flight.date > Travel.EndDate] then 'All bookings must be within the travel period'\nend);The new @assert feature enables you to leverage the full potential of the CXL expression language while ensuring that validations are executed efficiently directly on the database. It integrates tightly with the Fiori user interface, providing rich error feedback and reducing the need for custom code.
Embracing declarative programming in CAP can transform the way you develop cloud applications. By reducing the need for custom code, ensuring consistency, and facilitating the expression of business logic, you can efficiently create applications that are easy to maintain and intuitive. Whether you're new to CAP or a seasoned developer, consider exploring the benefits of declarative programming. Start by reading our documentation.
Happy coding!
","teaser":"This post walks you through the core concepts of declarative programming in CAP, covering declarative expressions, different kinds of input validations, how to use expressions as annotation values and the new @assert feature. These techniques work in both CAP Java and CAP Node.js.
","board":{"type":"board","id":"technology-blog-sap","href":"/boards/technology-blog-sap","view_href":"https://community.sap.com/t5/technology-blog-posts-by-sap/bg-p/technology-blog-sap"},"conversation":{"type":"conversation","id":"14321990","href":"/conversations/14321990","view_href":"https://community.sap.com/t5/technology-blog-posts-by-sap/declarative-programming-in-cap-less-code-more-value/ba-p/14321990","style":"blog","thread_style":"blog","messages_count":2,"solved":false,"last_post_time":"2026-02-05T17:49:26.936+01:00","last_post_time_friendly":"2026 Feb 05"},"topic":{"type":"message","id":"14321990","href":"/messages/14321990","view_href":"https://community.sap.com/t5/technology-blog-posts-by-sap/declarative-programming-in-cap-less-code-more-value/ba-p/14321990"},"post_time":"2026-02-05T15:03:43.143+01:00","post_time_friendly":"2026 Feb 05","depth":0,"read_only":false,"edit_frozen":false,"language":"EN","can_accept_solution":false,"placeholder":false,"is_solution":false,"solution_data":{},"metrics":{"type":"message_metrics","views":2650},"current_revision":{"type":"revision","id":"14321990_43","last_edit_author":{"type":"user","id":"41902","href":"/users/41902","view_href":"https://community.sap.com/t5/user/viewprofilepage/user-id/41902","login":"BirgitS"},"last_edit_time":"2026-02-05T14:59:56.688+01:00"},"kudos":{"query":"SELECT * FROM kudos WHERE message.id = '14321990'"},"tags":{"query":"SELECT * FROM tags WHERE messages.id = '14321990'"},"labels":{"query":"SELECT * FROM labels WHERE messages.id = '14321990'"},"images":{"query":"SELECT * FROM images WHERE messages.id = '14321990'"},"videos":{"query":"SELECT * FROM videos WHERE messages.id = '14321990'"},"attachments":{"query":"SELECT * FROM attachments WHERE message.id = '14321990'"},"replies":{"query":"SELECT * FROM messages WHERE parent.id = '14321990'"},"ratings":{"query":"SELECT * FROM ratings WHERE message.id = '14321990'"},"custom_tags":{"query":"SELECT * FROM custom_tags WHERE messages.id = '14321990'"},"moderation_status":"approved","visibility_scope":"public","user_context":{"type":"user_context","kudo":false,"read":false,"can_reply":false,"can_kudo":false,"can_delete":false},"message_type":"blog_topic_message","popularity":2.385461813015015E-5,"excluded_from_kudos_leaderboards":false,"latest_version":{"type":"friendly_version","major":"1","minor":"0"},"include_hidden_messages":true,"content_workflow":{"type":"content_workflow","state":"publish","message_draft_history":{"query":"SELECT * FROM message_draft_history WHERE message.id = '14321990'"},"user_context":{"type":"message_workflow_context","can_edit":false,"can_schedule":false},"view_href":"https://community.sap.com/t5/blogs/blogworkflowpage/blog-id/technology-blog-sap/article-id/188131"},"is_promoted":false},"metadata":{}}