topic CDS view calculation level and buffer level in Application Development and Automation Discussions

CDS view calculation level and buffer level

raffinkira — Sun, 24 Dec 2017 09:11:22 GMT

Hi all, I have a question about CDS view.

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

retired_member — Sun, 24 Dec 2017 10:43:31 GMT

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

raffinkira — Mon, 25 Dec 2017 05:14:48 GMT

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?