Read the model with ABAP SQL

CDS defines a reusable shape and semantics. ABAP SQL is one way for an ABAP program to consume that entity.

SELECT FROM zi_dispatch_since( p_since = @since_date )
  FIELDS dispatchorder, createdat
  INTO TABLE @DATA(orders).
DATA(result) = lines( orders ).

The parameter value is an ABAP host variable, hence the @. The target is an internal table because the query can return multiple orders.

Keep the responsibility boundaries clear

• A database table persists records.
• A CDS view entity models and exposes a reusable data shape, often with semantic annotations, associations, and access controls.
• ABAP SQL reads from a data source into program data.
• RAP exposes a business object/service contract with behavior, authorization, and transaction semantics; a CDS view alone is not automatically a complete API.

Use the simplest layer that meets the requirement. If multiple consumers need shared semantics, CDS can help. If a client must perform business operations through a supported service, use the appropriate RAP/service design rather than exposing a raw read model as if it were a transactional API.

Cloud and Classic source access

The query syntax is modern ABAP SQL. In ABAP Cloud, SAP-delivered sources must be released for the relevant use; project-owned sources must follow the package and language-version rules. Classic systems have their own compatibility and API policies. An entity name copied from this fictional lesson will not exist in your system.

Practice

Supply the parameter, select fields, collect the rows, and set result to the row count. The checker verifies structure only; it performs no SELECT.

Sources

• SAP Samples, ABAP SQL
• SAP Samples, CDS View Entities
• SAP Samples, ABAP for Cloud Development
• SAP Help Portal, ABAP SQL

Version note: CDS parameter syntax in a data source and the entity’s availability depend on the ABAP release and project language version.

SELECT FROM zi_dispatch_since( p_since = @since_date )
  FIELDS dispatchorder, createdat
  INTO TABLE @DATA(orders).
DATA(result) = lines( orders ).

WRITE result.

out->write( result ).