topic Get values from Search Help in Application Development and Automation Discussions

Get values from Search Help

former_member221372 — Sat, 21 Jun 2014 17:46:11 GMT

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

Re: Get values from Search Help

Florian — Sat, 21 Jun 2014 17:50:15 GMT

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

Re: Get values from Search Help

former_member221372 — Sat, 21 Jun 2014 18:10:40 GMT

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

Re: Get values from Search Help

Florian — Sat, 21 Jun 2014 21:53:39 GMT

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

Re: Get values from Search Help

Former Member — Sun, 22 Jun 2014 04:44:46 GMT

Hi,

Take Name2 from kna1.

Re: Get values from Search Help

Florian — Sun, 22 Jun 2014 07:23:28 GMT

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

Re: Get values from Search Help

former_member221372 — Sun, 22 Jun 2014 08:48:44 GMT

Hi Florian,

Created a scenario. PFA.

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

Cheers,

Bharath

Re: Get values from Search Help

Former Member — Sun, 22 Jun 2014 10:21:46 GMT

Hi Expert Florian,

Thanks for your advice.I APPRECIATE IT