topic Re: Is it possible to create CDS views through Programming in Application Development and Automation Discussions

Is it possible to create CDS views through Programming

former_member207873 — Wed, 17 Feb 2021 14:44:09 GMT

Hello Experts,

Is it possible to create CDS views using programming ?

B.R.

Re: Is it possible to create CDS views through Programming

gurkanyilmaz — Wed, 17 Feb 2021 15:01:58 GMT

Please check here

Dynamic CDS Creation

Re: Is it possible to create CDS views through Programming

joltdx — Wed, 17 Feb 2021 15:03:47 GMT

If you're asking how to create a dynamic CDS view, then the answer is no. You need to specify names and fields in the CDS view definitions, so it's not possible to create dynamic CDS views.

Re: Is it possible to create CDS views through Programming

Patrick_vN — Wed, 17 Feb 2021 15:06:39 GMT

Theoretically I guess you could try to call the same APIs that eclipse/ADT does.. or the code behind the APIs.

I wouldn't consider it practical though. Then it might be easier to create some RPA process and let that do the actions in eclipse..

Re: Is it possible to create CDS views through Programming

joltdx — Wed, 17 Feb 2021 15:07:10 GMT

Hah, well, that is actually creating a CDS view in the system in a more complex way than necessary...

Re: Is it possible to create CDS views through Programming

former_member207873 — Wed, 17 Feb 2021 15:21:59 GMT

Hello jorgen_lindqvist41

No I do not mean dynamic CDS views. I mean can I create CDS view through only ABAP coding .

Re: Is it possible to create CDS views through Programming

former_member207873 — Wed, 17 Feb 2021 15:28:24 GMT

pvnierop

Can you please explain more about what you mean by RPA process ?

Re: Is it possible to create CDS views through Programming

joltdx — Wed, 17 Feb 2021 15:34:01 GMT

Ok. But why? You would still have to do the same things, and write the same definitions. Only in a much more complex and difficult way, without any checks of the syntax or anything...

There must be something I'm missing here as to your requirement...

Re: Is it possible to create CDS views through Programming

Patrick_vN — Wed, 17 Feb 2021 15:55:48 GMT

Are you sure it covers the creating of CDS artifacts? As far I can see "the functionality ranges from reading the content of CDS entities to querying annotations".

Re: Is it possible to create CDS views through Programming

Patrick_vN — Wed, 17 Feb 2021 16:02:47 GMT

I have no idea why you would want to create your CDS views through programming, but you could use a Robotic Process Automation tool (based on a xls for example) to create those views in eclipse.

Not sure if that would be a time-gain though, that would depend on whether you have RPA knowledge available and/or the amount of views to be generated

Re: Is it possible to create CDS views through Programming

former_member207873 — Wed, 17 Feb 2021 16:40:27 GMT

Jörgen LindqvistI need to automate certain processes .

Re: Is it possible to create CDS views through Programming

joltdx — Wed, 17 Feb 2021 17:01:04 GMT

I understand, could you explain a bit more about the certain processes? Preferably in your main question, so we all can have more information to base our suggestions on. For instance:

On what do you want to create the CDS views? Input in Excel? From a SAPUI5 app? All the existing Z database views in the data dictionary? IDoc data? Are we talking about 10, 50, 100 or 300 CDS views?

Is this a one time thing? Is this something to run continually as part of something else? Are we talking about 1 each time or 100 for each run?

To which degree should this be automated? Fully, as in no human contact at all? Or is some human interaction ok?

We are full of ideas, but we need more to go on... 🙂

Re: Is it possible to create CDS views through Programming

former_member207873 — Wed, 17 Feb 2021 17:23:57 GMT

Jörgen LindqvistThanks your reply. I would want to develop something for the process consultants who are not much knowledgeable in programming , sql queries to build CDS views with few selections , conditions and button clicks. Something like SQVI(SAP Query) does .

Re: Is it possible to create CDS views through Programming

joltdx — Thu, 18 Feb 2021 04:29:43 GMT

All right, that sounds like fun! 🙂 Difficult, tricky and hard, but fun!

And just out of curiosity then, as a next step, how are they going to use the CDS views? Some kind of dynamic ALV with IDA?

Re: Is it possible to create CDS views through Programming

maheshpalavalli — Thu, 18 Feb 2021 04:43:49 GMT

You can check XCO library, but it depends on the abap version you have probably, I only know that it is available in abap on cloud .

https://help.sap.com/viewer/65de2977205c403bbc107264b8eccf4b/Cloud/en-US/291f3c6f5b274cc98a0f55a87aa48a5b.html

Re: Is it possible to create CDS views through Programming

Patrick_vN — Thu, 18 Feb 2021 07:04:19 GMT

Considering XCO library, I think "the functionality ranges from reading the content of CDS entities to querying annotations".

Re: Is it possible to create CDS views through Programming

Patrick_vN — Thu, 18 Feb 2021 07:07:35 GMT

And have you checked the Query Designer application in SAP Fiori?

Re: Is it possible to create CDS views through Programming

maheshpalavalli — Thu, 18 Feb 2021 07:46:00 GMT

pvnierop Ohh, not sure about that statement in help, but I thought we can create cds views using XCO libraries, like how it was done in ABAP RAP Generator.

https://github.com/SAP-samples/cloud-abap-rap/blob/master/src/zcl_rap_bo_generator.clas.abap

Re: Is it possible to create CDS views through Programming

former_member207873 — Fri, 19 Feb 2021 11:31:30 GMT

Hello maheshkumar.palavalli,

Are you sure that we can create CDS views from XCO library ? Because in the documentation , I am finding only "The functionality ranges from reading the content of CDS entities to querying annotations."

Re: Is it possible to create CDS views through Programming

maheshpalavalli — Sun, 21 Feb 2021 06:54:54 GMT

Yes, it says that, but I am looking at the RAP generator from Andre . There the CDS views will also be created, I am not sure if it works only with RAP model. But give it a try, I hope it should not be any different from what is used in the below code. Make sure you abap version have those API's.

https://github.com/SAP-samples/cloud-abap-rap/blob/master/src/zcl_rap_bo_generator.clas.abap