CDS views during Hana Database Migration

[former_member231366]

Hello Experts,

Could you please answer my query.

When we migrate from old database to HANA DB, then

1.Will only the Tables will be copied from old database to HANA DB

(or)

2. Will there be any CDS views created on top of the tables during migration.

I know that when we migrate from ECC to S/4 HANA, CDS views will be created on top of the some standard tables to improve the performance.

But my question is - When we do plain database migration ,Will there be any CDS views created on top of the tables

Thanks,

Raju

[pfefferf · Accepted solution]

No, in that case no ABAP CDS Views will be created, because all ABAP CDS Views design time objects are defined on the S/4, Business Suite or base NetWeaver layer.

Regards,
Florian

[former_member231366 · Accepted solution]

Thank you for clarification. When there are no ABAP CDS Views, then how the system will be fast, I mean, How the standard SAP Reports are fast in execution?

Is it because of In-memory, Column format, Parallel processing, in HANA DB? Please confirm

Thanks,

Mallik

[pfefferf · Accepted solution]

What you mean with "Standard Reports"? There are different kinds of reports on different layers.

On DB level only there are of course also optons available to create respectively feed reports with data in a fast way (for instance using calculation views).

[former_member231366 · Accepted solution]

By "standard reports", I mean, KE24 Tcode and KE30 Tcode reports in SAP FICO.

KE30 - Execute profitability report CO - Profitability Analysis

KE24 - Line Item Display - Actual Data CO - Profitability Analysis

These reports usually take very long time in ECC on 3rd party Database.

So, my question is: When there are no ABAP CDS Views, then how the system will be fast, I mean, How the standard SAP Reports like above are fast in execution?

Is it because of In-memory, Column format, Parallel processing, in HANA DB? Please confirm

[pfefferf · Accepted solution]

Sees are transactions in the Business Suite (which maybe can also be used in S/4). But when you not update that layer, you will "only" the benefits by the things you have listed. And also only if the ABAP implementation is written in a way that it can benefit from the HANA database.