The Most Frequently Asked In-Depth Questions About SAP CDS Views

CDS Views

The list contains the most frequently asked in-depth questions about SAP CDS Views. The list grows continual. The answers are to the point. As a result, as short as possible without missing the important information.

Please leave a comment if the list does not contain your question. I will try to answer it and maybe add it to this list.

How to Consume an OData Service of a CDS View with Parameters Including a Date Value?

ABAP CDS View with parameters bp_id, p_date and p_language:

@AbapCatalog.sqlViewName: 'ZC_CDSView'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'My Consumption CDS View'
@OData.publish: true
define view ZC_CDS_View_Consumption
    with parameters bp_id: bu_partner,
        @Environment.systemField: #SYSTEM_DATE
        p_date: dats,
        @Environment.systemField: #SYSTEM_LANGUAGE
        p_langu: spras
as select from ZI_CDS_View_Composite {    
    key partner1, 
} where partner1 = :bp_id
    and date_to >= :p_date
    and date_from <= :p_date
    and spras = :p_langu

OData Service consumption of the from the ABAP CDS View generated OData Service with parameters:

1 Comment
Get Dose for Excel
Dose for Excel screenshot.

Dose for Excel adds 100+ advanced functions and features for Microsoft Excel.

For example, you can:

  • Export sheets quickly
  • Merge cells or rows or columns without losing data
  • Comments assistant
  • Count cells by color
  • Advanced built-in formulas
  • Advanced built-in functions
  • Auto backup your workbooks easily
  • Lots more

Check it out here!

Get A COMPLETE SAP Modules Overview infographic (free)

Plus, receive for free SAP tips & insights and all future infographics that are only shared with the private newsletter subscribers. 

Complete SAP modules/components overview infographic.
Latest Poll
Essential Ressources

1 Comment. Leave new


How to read Text Types/Notes in CDS considering we have to convert it to a string.
ps: I cant use table functions as I am on a lower version


Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.