Skip to Content

Embedded Analytics - deployment of "custom" ABAP CDS query views

Feb 09 at 10:10 AM


avatar image


anybody with experience in deployment of Query Views, which are generated from ABAP CDS Views?

I have a customer request, where ABAP CDS annotations for query views are not expressive enough.

So I'd like to deploy "customized" query views (created in Analysis for Excel via "Save View"). I have no idea how or if I can transport these views. I found the persisted table entries via DB trace (TADIR, RSZWVIEW, RSZWOBJ, RSZWOBJTXT, RSPERS_BOD) but manually transporting these entries seems odd to me.

I also found the BEx Query Designer to create custom query views, but this tool seems a bit "old-fashioned" to me. Maybe anybody has experience with this tool and deployment?



10 |10000 characters needed characters left characters exceeded

So do I understand you correctly, that you want to replace the DB views generated from ABAP CDS DDL source codes with your own views?



in Analysis for Office (Excel), you can customize a query view (hide/show fields, change between display of key and/or text display for fields) and then persist the customized query view (via "Save View") on a Netweaver Server. I'm interested in deploying/transporting these customized views.

* Please Login or Register to Answer, Follow or Comment.

2 Answers

Best Answer
Stefan Boxleitner Feb 12 at 10:15 AM

I found the solution by myself. The tool of choice here is the "Data Warehousing Workbench" (transaction RSA1). Unter "Transport Connection", you can put these kinds of "customized" views into transport requests.

10 |10000 characters needed characters left characters exceeded
Horst Keller
Feb 09 at 10:47 AM

ABAP CDS views are deployed via their DDL source code (transport object R3TR DDLS in TADIR) with the SAP transport tool and nothing else.

To my knowledge, everything else (metadata in system tables, database view in ABAP Dictionary, DB views) is generated from that source code during and after import.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you for your quick reply, but i want to transport/deploy some sort of customized query view (see comment section of question for details).