In this blog, we will cover some use cases and OData exposure of CDS Views created with Key column. News – Check out our most recent news, key announcements & Press releases.Innovation Lab – The Innovation Lab is built with an aim to create market-ready BI & Analytic solutions.Careers – Explore intellectually rewarding careers in the field of Business Intelligence & Analytics.About Visual BI – We make the best in BI possible through our passion and commitment to innovation.Events – Check out events hosted and attended by Visual BI Solutions.Webinars – Get latest updates on our webinar schedules & register to learn from our experts.Videos – Handpicked video resources showcasing you the latest BI trends and technologies.Case Studies – A growing collection of more than 50+ case studies exhibiting our customers’ success.Blogs – Get your inside scoop into our take on the latest developments in BI & Analytics.

Data Science & ML – Unlock endless possibilities with an optimum mix of Data Science and Machine learning.

Modern BI & Analytics – Experience the power of data with modern visualization techniques.

Strategy & Architecture – Drive successful outcomes with the right data strategy and architecture.

Data Architecture & Engineering – Build a modern data foundation that supports your business.If DEMO_SHOW_DDL_SOURCE ABAP report does not exist on your SAP system, you can try to create it by using following ABAP codes. Do not use the DDL SQL View name instead of DDL Source name.Īlthough the format of the SQL codes is confusing the developers, all of the SQL DDL codes of a CDS view can be displayed with DEMO_SHOW_DDL_SOURCE ABAP program without the requirement of an installed SAP HANA Studio. Please check on SE11 for DDL Source attribute.

Launch SE38 ABAP transaction to execute DEMO_SHOW_DDL_SOURCE reportĮnter the DDL source name (name of the SQL DDL document) and press Enter button. SAP provided ABAP program DEMO_SHOW_DDL_SOURCE to display DDL source codes of CDS views or other CDS objects easily in SAP GUI environment without using SAP HANA Studio. So if you have SAP HANA Studio ADT Tool installed, using the Eclipse IDE it is possible to display the SQL data definition language source codes of the CDS view.įortunately, there is an ABAP report to display source codes of SQL DDL views.ĭEMO_SHOW_DDL_SOURCE to Show DDL Source Codes of CDS Views When I double click it, I get only a small part of the SQL DDL source codes of the CDS view.ĪBAP programmers should realize the warning:ĭata Definitions can only be edited using ADT in Eclipse Note that there is DDL Source section which has the value 'BSIS_DDL'. Here is BSIS CDS View in SAP HANA system which I use SE11 transaction to display DDL SQL View.

Views in sap abap with example