CDS view calculation level and buffer level

[raffinkira]

Hi all, I have a question about CDS view.

Does CDS view calculate and buffer data on ABAP server level or on DB level?

[raffinkira]

Both. If you are able to switch on buffering, data are buffered, when accessed with Open SQL. Otherwise all is done on DB.

[retired_member]

Both. If you are able to switch on buffering, data are buffered, when accessed with Open SQL. Otherwise all is done on DB.

[raffinkira]

Thank you for the reply.

BTW, would CDS view do data pre-selecting at the beginning of the ABAP program, which mignt be better than Open SQL in terms of performance?