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

Get values from Search Help

former_member221372
Participant

‎2014 Jun 21 6:46 PM

0 Likes
1,828

Hi,

I have 2 Tables, KNVP & KNA1.

Have data base view for these tables.

KNVP-KUNNR & KUNN2

KNA1 - KUNNR & NAME1

I have to get output like this

KUNNR    Name 1    KUNN2    Name 2

Both KUNNR & KUNN2 are there in KNA1 as KUNNR. So unable to get  Name 2

I am getting like this now

KUNNR    Name 1    KUNN2    Name 1

I want the output like this

KUNNR    Name 1    KUNN2    Name 2

Cheers,

Bharath

Hi,

I have 2 Tables, KNVP & KNA1.

Have data base view for these tables.

KNVP-KUNNR & KUNN2

KNA1 - KUNNR & NAME1

I have to get output like this

KUNNR    Name 1    KUNN2    Name 2

Both KUNNR & KUNN2 are there in KNA1 as KUNNR. So unable to get  Name 2

I am getting like this now

KUNNR    Name 1    KUNN2    Name 1

I want the output like this

KUNNR    Name 1    KUNN2    Name 2

Cheers,

Bharath

Reply
7 REPLIES 7
Read only

Florian
SAP Champion
SAP Champion

‎2014 Jun 21 6:50 PM

0 Likes
1,720

Hi Bharath,

you need to join another table into it. KNA1 is linked to ADRC trough ADDRNUMBER

Here you will find everything you need. NAme1 and NAme2

By the way: To be sure having always the correct data is anyway necessary to link to ADRC

~Florian

Read only

former_member221372
Participant
In response to Florian

‎2014 Jun 21 7:10 PM

0 Likes
1,720

Hi Florian,

In that case also I will get KUNNR - NAME1 Only, not KUNN2, as I will join based on any one of the field.

Bharath

Read only

Florian
SAP Champion
SAP Champion
In response to Florian

‎2014 Jun 21 10:53 PM

0 Likes
1,720

Ahh... got name2 in my mind..

So what is the problem with it. You need to have a full qualified key? Just add it...

Otherwise if I'm right kunn2 ends always in one kna1-kunnr. But of course the number could be more often included...

~Florian

Read only

former_member221372
Participant
In response to Florian

‎2014 Jun 22 9:48 AM

0 Likes
1,720

Hi Florian,

Created a scenario. PFA.

Now my requirement is to get the Name of KUNN2 as a 4th Column

Cheers,

Bharath

Preview file
8 KB
Preview file
19 KB
Preview file
21 KB
Read only

Former Member

‎2014 Jun 22 5:44 AM

0 Likes
1,720

Hi,

Take Name2 from kna1.

Read only

Florian
SAP Champion
SAP Champion
In response to Former Member

‎2014 Jun 22 8:23 AM

0 Likes
1,720

Hi noufal,

I'm not sure if you are familiar with the SAP-concepts of addresshandling. If so, take some time and work through the official sites to learn more about that. Your suggestion is against best practise.

Have a look here:

Central Address Management (BC-SRV-ADR) - SAP Library

~Florian

Read only

Former Member
In response to Former Member

‎2014 Jun 22 11:21 AM

0 Likes
1,720

Hi Expert Florian,

Thanks for your advice.I APPRECIATE IT