Hello everyone,
I would like to create a view which is an inner join of the same table twice. I can do this in an ABAP program, but I need a view because it will serve as data provider for a search help.
I have tried to use aliases as you would in an ordinary join, but this seems not to be possible. I also tried to create the view on the table and a projection view of the table, but views can only be created on transparent tables.
The cleanest way would be to use an alias, the other solutions I tried were workarounds. Does anybody know of a way to handle this?
Thanks a lot for your feedback.
Kind regards,
Tim