topic Re: Alias Table in Database View in Application Development and Automation Discussions

Alias Table in Database View

Former Member — Sat, 01 May 2010 10:42:17 GMT

Dear All,

I am creating a Database View and I would like to add an Alias of table VBAP. How to achieve this?

Kindly Suggest.

Re: Alias Table in Database View

Former Member — Mon, 07 Jun 2010 18:23:45 GMT

i dont understand your question.! explain a little more

Re: Alias Table in Database View

Former Member — Tue, 08 Jun 2010 06:04:39 GMT

hi,

what do you want.... do you want all the fields of vbap in your database view....if yes then make vbap as your primary table of the view and copy the fields which you want...........................

if you want to use only one tbale then create a projection view.......it is used for selecting fields from one database table only

be more specific whats the requirement

hope this post helps you.....

thanks,

tanmaya

Re: Alias Table in Database View

Former Member — Thu, 10 Jun 2010 20:17:40 GMT

I beleive you are supposed ask question about JOINs...coz Alias names used in JOINs and interfaces of OO programing

Re: Alias Table in Database View

ThomasZloch — Thu, 10 Jun 2010 20:24:49 GMT

No aliases in database views, sorry.

Thomas

Re: Alias Table in Database View

GisovP — Wed, 18 Jan 2023 11:28:34 GMT

The idea behind the alias is to have one table linked more than once in a view structure. Although no alias can be created directly in a view, I managed to get a similar effect by creating a view on the table that I wanted to alias, then used the table once and the view once to get a similar effect.

Re: Alias Table in Database View

ThorstenHoefer — Wed, 18 Jan 2023 14:15:18 GMT

Have you tried to use a CDS View?

Re: Alias Table in Database View

cmilkau — Thu, 25 Apr 2024 16:13:56 GMT

You cannot use ABAP database views in ABAP database views, according to the editor. So how did you manage to do that?