Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Creating a view with a 2 same tables

Former Member

‎2007 Oct 24 7:29 PM

0 Likes
543

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

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

Reply
2 REPLIES 2
Read only

Former Member

‎2007 Oct 24 7:32 PM

0 Likes
432

Hi,

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

ashish

Read only

Former Member
In response to Former Member

‎2007 Oct 25 7:08 PM

0 Likes
432

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ú