02-21-2023 9:14 AM
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
02-21-2023 12:46 PM
02-21-2023 9:41 AM
You can create Maintenance view (in SE11 or SE54) and that can be used in SM30 afterwards.
Here is relevant ABAP docu:
02-21-2023 11:54 AM
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
02-21-2023 12:46 PM
02-21-2023 1:57 PM
02-21-2023 2:58 PM
Correct. It's not possible. Only table and maintenance views are possible for SM30.
02-21-2023 3:00 PM
But you can join tables in maintenance views provided that you have correctly defined the foreign keys.
2 weeks ago - last edited 2 weeks ago
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