topic Re: Creating CDS view - missing 'DDL Source' option in Application Development and Automation Discussions

Creating CDS view - missing 'DDL Source' option

Former Member — Wed, 21 Dec 2016 16:07:39 GMT

Hi All,

I am trying to create a CDS view using Eclipse Neon. I have installed latest 'ABAP Development Tools for SAP NetWeaver' from "SAP Development Tools for Eclipse Neon - https://tools.hana.ondemand.com/neon/". Also, have ABAP system 7.40 service pack 009.

But still I am not able to see the DDL Source option to create (see the attached jpeg). Do you know what I am missing?

Please advise. Thanks in advance.ddl-source.jpg

Chandra

Re: Creating CDS view - missing 'DDL Source' option

retired_member — Wed, 21 Dec 2016 17:19:38 GMT

It is "Data Definition".

Re: Creating CDS view - missing 'DDL Source' option

Former Member — Wed, 21 Dec 2016 17:55:13 GMT

Thank you very much Horst. I was going through 2014 Open SAP course that is where I got 'DDL Source'.

Re: Creating CDS view - missing 'DDL Source' option

galeksan — Thu, 22 Dec 2016 14:57:28 GMT

Could you please provide more details about renaming the CDS development objects.

All the videos on the HANA Academy channel for modeling CDS views (uploaded July 2016) show it as a DDL Source.

Re: Creating CDS view - missing 'DDL Source' option

retired_member — Thu, 22 Dec 2016 17:51:37 GMT

The node in ADT is Core Data Services with subnodes Access Control and Data Definitions.

Under Data Definitions there are the DDL source codes that define CDS Views or CDS Table Functions. The source codes are the transportable repository objects (DDLS in TADIR). Nevertheless we speak of Data Definitions. Similar to ABAP, where we speak of classes rather than of their class pools.

Each DDL source defines one CDS entity. The entity is instantiated when you activate the DDL. This also happens in the target system after a transport. Instantiation means that the description of the DDL is transformed to metadata entries in system tables. ABAP looks up these metadata when addressed behind TYPE or in Open SQL. Furthermore, for CDS views the SQL view is instantiated on the DB. For technical reasons, for each view there is also a classical database view generated in the ABAP Dictionary, visible in SE11, but that should not be used itself.

A DDL source code for a data definition can have a different name than the CDS entity defined therein, but this is not recommended.

Under Access Control, you find the DCL sources for CDS roles.