topic Re: relation between knb1 and adr6 in Application Development and Automation Discussions

relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 11:53:40 GMT

Hi,

I´m searching for the relation between the table KNB1 and the ADR6 to find the email of a customer, but I´m having serious problems.

Can someone help me, please????

Thanks!!

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 11:56:18 GMT

Hello,

<b>KNB1-PERNR and ADR6-PERNR

KNB1-ADRNR and ADR6-ADRNR</b>

VAsanth

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 11:56:41 GMT

try KNA1/KNB1 and get ADRNR of customer to get data from ADR6.

Regards

peram

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 11:58:55 GMT

Hi,

You can find PERNR in both tables.

Regards

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 12:01:05 GMT

You have to link via KNA1 (field ADRNR), then link KNA1 to KNB1

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 12:01:38 GMT

In the table ADR6 I find the field persnumber, in the table KNB1 the field PERNR, and they are differents

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 12:02:55 GMT

I tried it, but the field ADRNR not is unique.

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 12:03:52 GMT

using customer number from KNb1, goto KNA1 and get ADRNR for that customer, then goto ADR6 using ADRNR and find out the mail id

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 12:05:21 GMT

Hello,

DO like this.

data: lv_email like adr6-SMTP_ADDR.
Select single SMTP_ADDR from adr6 into lv_email where PERSNUMBER = knb1-pernr.
write: lv_email.

Vasanth

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 12:06:56 GMT

Thanks, but the persnumber and the pernr have differents values.

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 12:15:15 GMT

This will be true if your customer is set up in more than one company code.

What data do you need from KNB1?

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 12:45:55 GMT

Here is the code for you Email id from KNB1 and ADR6 .....

REPORT  ZAASD line-size  100.

tables  :  KNA1 , knb1 , adr6 .

data :  begin of  IT_DATA occurs  0 .
include  structure    KNB1  .
 DATA  :end of iT_DATA .
*
data :  begin of  IT_DATA2    occurs  0,
kunnr  LIKE  kna1-kunnr ,
adrnr  LIKE  KNA1-adrnr,
addrnumber  LIKE  adr6-addrnumber ,
SMTP_ADDR   like  adr6-SMTP_ADDR ,
end of iT_DATA2  .


select-options  :s_kunnr  for  knb1-kunnr..


*
SELECT *  FROM KNB1 INTO  TABLE IT_DATA
WHERE KUNNR IN s_kunnr.
*
IF sy-subrc EQ 0.
  SELECT KNA1~KUNNR kna1~adrnr   adr6~addrnumber  adr6~SMTP_ADDR    INTO  TABLE  IT_DATA2
    FROM KNA1 LEFT OUTER JOIN adr6 ON kna1~adrnr EQ adr6~addrnumber
    FOR ALL ENTRIES IN  IT_DATA
    WHERE KNA1~KUNNR  EQ IT_DATA-KUNNR .

ENDIF.

LOOP AT IT_DATA2 .
WRITE  :  / IT_DATA2-KUNNR  , IT_DATA2-ADRNR  ,IT_DATA2-SMTP_ADDR  .
ENDLOOP.

reward points if it is usefull....

Girish

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 14:23:48 GMT

thanks!!

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 14:24:35 GMT

Thanks Girish and everybody!!!

Re: relation between knb1 and adr6

Former Member — Thu, 21 Jun 2007 14:25:43 GMT

The help was very usefull.