Database view in SM30

[dschiener]

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

[Tomas_Buryanek]

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_...

[dschiener]

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

[thkolz]

You can just use maintenance views in SM30/SM31.

[junwu]

how about this?

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

[Sandra_Rossi]

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

[Sandra_Rossi]

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

[David23]

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