When to create CDS view?

[#1]

I have a concern as when should i create CDS views.

If i need to fetch two fields from standard tables, and i am sure it's used only for single program, should i still go ahead to create CDS view?

[SiddharthaR · Accepted solution]

Hi Madhuri,

CDS views should only be created if there are runtime calculations or logical expressions you want to push to DB layer to take advantage of Code push down technique and there is a reusability factor involved. For your use case open SQL will give same performance as CDS without creating additional objects.