topic Re: Database view in SM30 in Application Development and Automation Discussions

Database view in SM30

dschiener — Tue, 21 Feb 2023 09:14:01 GMT

Hi there,

is it possible to use a database view via SM30 / SM31?

I cannot find any possibility. I don't think that it is possible to create a maintenance view for a database view huh?

Background: In my use case I have to join multiple database tables for viewing.

Best regards,

Daniel

Re: Database view in SM30

Tomas_Buryanek — Tue, 21 Feb 2023 09:41:56 GMT

You can create Maintenance view (in SE11 or SE54) and that can be used in SM30 afterwards.

Here is relevant ABAP docu:

https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abenddic_maintenance_views.htm

Re: Database view in SM30

dschiener — Tue, 21 Feb 2023 11:54:46 GMT

Hi,

thank you for your response.

Yes I know.

Unfortunately my use case does not support joining multiple tables by a maintenance view...so this won't be an option at the moment.

Conclusion: Via SM30 I cannot use a database view, right?

BR,
Daniel

Re: Database view in SM30

thkolz — Tue, 21 Feb 2023 12:46:01 GMT

You can just use maintenance views in SM30/SM31.

Re: Database view in SM30

junwu — Tue, 21 Feb 2023 13:57:03 GMT

how about this?

https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=473962134

Re: Database view in SM30

Sandra_Rossi — Tue, 21 Feb 2023 14:58:43 GMT

Correct. It's not possible. Only table and maintenance views are possible for SM30.

Re: Database view in SM30

Sandra_Rossi — Tue, 21 Feb 2023 15:00:04 GMT

But you can join tables in maintenance views provided that you have correctly defined the foreign keys.

Re: Database view in SM30

DavidSolaliga — Mon, 06 May 2024 17:32:49 GMT

Hello dschiener,

I hope this message finds you well.I thinks there is a quick soluction respects your problem.

To access and recover view maintenance, I recommend you do:

1)Please, to access transaction SM30 in SAP

2)Once inside the transacction in SAP, click option "Searh Maintenance Dialog" this is going to do, shearch from the specific maintenance view, that you need to manage or verify.

Best Regards,

Solaliga David