How to create CDS view in S/4 HANA

[former_member304103]

How to create CDS view in S/4 HANA.

[pfefferf]

As S/4 uses CDS views using the ABAP CDS implementation, you should search in the ABAP and/or S/4 tagged contents.

Some things to start:

• ABAP CDS Online Help
• SAP HANA Academy - Modeling with S/4HANA CDS - Creating a Sample Virtual Data Model

Especially the second link - a playlist of S/4HANA CDS Modeling videos - gives you an insight how CDS Views in HANA are built (considering the different annotations to create a correct VDM).

Regards,
Florian

[former_member304103]

Can we create CDS view in SQL script or only we can use ABAP code?

[pfefferf]

The CDS specification has an implementation in ABAP and on HANA.

For S/4 only the ABAP based CDS views are used.

On HANA you can use CDS entities/views to define the data model (for more infos check the SAP HANA Core Data Services Reference). But consider: This is not SQLScript.

[Former Member]

Hi Florian,

Performance impact : Real-time data is read from HANA column store tables in Oracle 11g.

I have one scenario where i need to read data real-time in Oracle from SAP Hana tables and update oracle tables. Using ODBC technique to read HANA data from oracle. There are huge difference in technology between these two. ODBC Data read from HANA to Oracle 11g will have huge performance impact due to deduplication and column store in HANA.

Can you please suggest, whether there is any other alternative technique?