Skip to Content
0
Former Member
Jun 09, 2009 at 01:37 PM

View on the same table twice (aliases in views)

863 Views

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