SAP CDS WHERE CLAUSE V1



Get Example source ABAP code based on a different SAP table
  


• WHERE ABAP_CDS_SELECT_V1

ABAP_CDS_DDL - DDIC-Based View, SELECT, WHERE

ABAP_SYNTAX
... WHERE cds_cond ...

What does it do?
Defines a WHERE condition for the result set of a ABAP_CDS_V1_VIEW . When the CDS view is accessed, the result set contains only the data from the data source data_source that meets the condition cds_cond specified after WHERE.
The fields evaluated in the condition do not need to be defined as elements of the CDS view in the SELECT list. For the operands, general and special rules apply when specifying the condition.



Latest notes:

Unlike in the HAVING condition, aggregate expressions cannot be specified in the WHERE condition.
NON_V5_HINTS
ABAP_HINT_END

ABAP_EXAMPLE_VX5
When the CDS view demo_sales_order_old4 is accessed, the result set contains only orders where the company name of the business partner starts with S and that were created between January and March 2013.
DDLS DEMO_SALES_ORDER_OLD4
ABAP_EXAMPLE_END