on 07-28-2014 9:15 AM
Hi,
internally we have since some time a discussion on whether one can make external views in ABAP when HANA is your secondary database. According to the documentation it is not possible, but apparently the HANA-versions of Financial transactions do use them. These transactions are SAP standard transactions. It is difficult to convince our users/developers that this is not possible, when they see it is used in SAP standard ...
We do not get any clear answer to this problem. Also not from our consultants. The only remaining possibility seems to sketch a possible solution and ask you all some questions and make some statements to see if I am right.
I think this little sketch shows the landscape you need to make all this possible:
Is this correct? Or do I still miss something?
Thanks for any reaction.
Regard.
Kris
Message was edited by: Jens Weiler
Hi Kris,
except for "The name of the HANA-artefact and the external view in the ABAP dictionary have to be identical" all you points above are valid.
Let me say a couple of words about the external views, especially those delivered by SAP.
Assume you have a development system landscape like DEH (development system with HANA as primary DB), DEO (development system with another DB), QCS (quality system, doesn't matter which DB but receiving the consolidated transports of DEH and DEO), PDS (productive system with non-HANA as primary DB and a secondary DB connection to HANA).
In this heterogeneous landscape you can create HANA content in DEH (respectively in the HANA underlying DEH) and external views via the ABAP Development Tools. You can transport the HANA content (e.g. via the HANA Transport Container) as well as the external views (and database procedure proxies) to the QCS system. The dictionary content, i.e. external views and database procedure proxies are active - otherwise the import/activation will fail - but you cannot consume them. Consumption of external views in the QCS system will lead to runtime exceptions as the underlying HANA artefacts are not accessible. However, since all the dictionary content exists, i.e. external views, database procedures, and the HANA transport container and all of them are active, you can further transport them to the productive system PDS. Once the external view is available in PDS and the HANA artefacts are available in the "side-car HANA" (assuming for simplicity you just use the connection to the DEH HANA), you can consume the external view respectively the underlying HANA view via OpenSQL in conjunction with the CONNECTION statement.
The described procedure explains how SAP has been able to deliver external views. In our system landscape, we have development systems on HANA as well as systems using non-HANA as primary database - how exactly depends on the product etc. So once the colleagues developed their HANA views and created the external views on such a development system on HANA, we can deliver external views. You can consume these external views:
In scenario 1. you are able to create external views yourself via the ABAP Development Tools, while in the second scenario you can neither view nor maintain the external view.
For database procedure proxies, there is a method to create the DB procedure proxies programatically (see http://scn.sap.com/thread/3498161).
Hope this clarifies your questions,
Cheers,
Jasmin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.