🟡 Devtoberfest 2025 - Coder's Challenge - CAP Documentation (Capire!)

Topic page: Definition Language (CDL).

In CDS modeling, what is the CDL keyword used to declare named definitions that are to be used to extend entities?

HINT: just by the way, there’s one of these types of named definitions (not explicitly declared, but) used in the CDS model above.

Topic page: Common Reuse Types.

Instead of each project re-inventing their own definitions for common concepts that many of them share, CAP ships with a set of types, entities and more, that each project can use instead of cluttering up their domain models with their own versions.

Entities such as Countries, Currencies, Languages and Timezones fall into this category and are themselves all extended with a common base definition which has name and descr elements.

What is the name of that base definition?

Topic page: CDS-based Authorization

Authorization restrictions can be added declaratively to CDS models via annotations (starting with the @ symbol). When compiled (or “mapped”) into EDMX, for an OData representation and conveyance of a given service, the metadata can also contain (OData flavor) annotations. Here’s an example of some annotations in EDMX, where there are three annotation terms that are applied to a Books entity target:

<Annotations Target="Bookshop.EntityContainer/Books">
  <Annotation Term="Capabilities.DeleteRestrictions">
    <Record Type="Capabilities.DeleteRestrictionsType">
      <PropertyValue Property="Deletable" Bool="false"/>
    </Record>
  </Annotation>
  <Annotation Term="Capabilities.InsertRestrictions">
    <Record Type="Capabilities.InsertRestrictionsType">
      <PropertyValue Property="Insertable" Bool="false"/>
    </Record>
  </Annotation>
  <Annotation Term="Capabilities.UpdateRestrictions">
    <Record Type="Capabilities.UpdateRestrictionsType">
      <PropertyValue Property="Updatable" Bool="false"/>
    </Record>
  </Annotation>
</Annotations>

These three annotations are in the OData Capabilities Vocabulary and are:

• DeleteRestrictions
• InsertRestrictions
• UpdateRestrictions

In other words, the only type of operation allowed on this entity is READ.

There is single annotation in CDS that, when applied, is represented in OData EDMX as exactly this set of capability annotations. What is it (make sure you include the @ prefix when submitting your answer)?

See A deep dive into CDS and OData annotations for further reading on this subject.

Topic page: Databases - Common

The Providing Initial Data section of this topic page describes the ability to use CSV files to provide initial / sample data.

According to this section, initial data (for configurations, code lists and similar) is picked up by default from data/ directories within the db/ directory. In contrast, sample data (for tests and demos) is picked up from data/ within a different parent directory, and is also excluded from production deployments.

What is the name of this different parent directory?

Topic page: Query Language (CQL)

CQL is a superset of SQL, and has many features that allow us to remain at a high level when thinking about how we can interact with our CDS models. One of these features is the concept of path expressions. Here are a few examples:

In a select clause:

SELECT *, author.address.town.name from Books;

In a where clause:

SELECT from Books where author.name='Emily Brontë'

In a from clause:

SELECT from Authors[name='Emily Brontë'].books;

In this last example, we see [name='Emily Brontë'] which is another feature of CQL. What is the two word phrase that describes what this feature is?

Topic page: Definition Language (CDL)

As described in the Entities & Type Definitions section of this topic page, we learn that entities (named structured types usually representing data that is persisted and accessed via CRUD style operations) and types (simple, or structured, or as an association) can be defined in CDL.

When defining entities or types, there is a keyword that can be used but is optional in both cases. What is that keyword?

Topic page: Common Annotations

In an earlier question (Q4) we got to learn about a CDS annotation that maps to multiple annotations in the Capabilities Vocabulary (in the OData / EDMX context). There are other common annotations in CDS that map to annotations in other established vocabularies.

For example, consider this CDS model definition:

service Bookshop {
  entity Books {
    @(
      title      : 'Identifier',
      description: 'A useless description'
    ) key ID : Integer;
    title    : String;
  }
}