Hi,
I would like to know if there's a way to define the connection in the DDL of a CDS view. My requirements are as follows:
I want to use an IDA ALV to show the data of a HANA calculation view in an ABAP system with HANA as a secondary database. I've read that it's better to use a CDS consuming an AMDP than defining an external view, the problem is that AMDPs are not supported in my ABAP system and external views neither. It can be solved by creating AMDP and CDS view in the HANA system and executing the IDA ALV in the ABAP system modifying the PARAMETER ID of the connection (here), but it doesn't looks like a good idea to me because if there's a dump or an unexpected situation, the PARAMETER ID will be wrong for all the other IDA ALVs.
The only way that I can imagine to solve this is to create the AMDP in the HANA system and the CDS that consumes it in the ABAP system so I don't have to modify the PARAMETER ID of the connection when using the ALV IDA but I don't know if it's possible to specify the connection in the DDL. Is there an annotation or something like that to do such a thing?
Thanks.
