What difference would it make to use CDS View instead of table name in select query?

[sh4il3sh]

I have select queries on mulitple Business Partner related tables, what difference would it make if I select from I_BUSINESSPARTNER instead of BUT000?

Do we have any performance gains or is it just a good practice to do so?

[former_member14709]

Hi Shailesh,

As per my understanding, difference is in terms of recommended way. When you plan to upgrade, you would see issues if you are firing selects on database tables. You would be all secured during upgrades if you are using released CDS views. Moreover, you have a choice only in classic ABAP. In Embedded Steampunk or Steampunk, you won't have a choice and must use only released CDS views.

Thanks,

Aman Garg

[sh4il3sh]

Thanks for answering Aman, I am worried if would I need additional autorization for those CDS views used in this case?
because I reckon CDS has DCL concept.