topic Re: Creating a view with a 2 same tables in Application Development and Automation Discussions

Creating a view with a 2 same tables

Former Member — Wed, 24 Oct 2007 18:29:24 GMT

Hi experts. I have a Question... I want to make a view but I need to use the KNA1 table, but... I need again the KNA1 table to make a joing like this: KNA1_1. and KNA1_2.KUNNR. But in the transaction se11, I don't know how can I make the alias for the KNA1 table, with the alias I could add KNA1 and do a join with KNA1 again.

Thank you for your help!

Lulú McDonald

Re: Creating a view with a 2 same tables

Former Member — Wed, 24 Oct 2007 18:32:41 GMT

Hi,

Can you explain your requirement in detail? Perhaps we can use same table and add conditions for various fields.

ashish

Re: Creating a view with a 2 same tables

Former Member — Thu, 25 Oct 2007 18:08:22 GMT

Hi Ashish... I want do the following:

I need to do in a view 2 joins with the Customer Master table, but I want reference 2 differents clients, to the second table KNA1 I want to use an alias... then How could do I the followin joins?:

KNA1.COUNC=T005F.COUNC

KNA1.LAND1= T005F.LAND1

KNA1.REGIO=T005F.REGIO

KNA1.KUNNR=LIKP.KUNAG

LIKP.KUNNR=KNA1_1.KUNNR

How you can see the KNA1_1 do not exist, but I want to use them like an alias of KNA1... them I don't know how in the se11, when I'm making a view, how add a table with an alias name.

Thank you!!!

Lulú