fields custoerm number name1 and email id in xd02 tcode

[Former Member]

hi

can anyone tell me the linkd for the tables in Xd02 for the following fields being put

cutomter number it is kna1 is suppoer

name1 also in kna1

now how is this kna1 link to email id of xd02 by whtihc table or tbles

regards

Arora

[Former Member]

Hi,

In KNA1 you will find the Personal Number or the Address number, based on that goto ADRP and find the othere i mean Personal or the Address number, then come to ADR6 table and give the Personal number and the Address number then you will get it

Regards

Sudheer

[Former Member]

hi sudheer

i kna1 address adrnr is there but in adrp PERSNUMBER is there

didnt get ur point related to PERSNUMBER in adrp ?

regards

Arora

[Former Member]

hi SUDHER PLS ELOBORATE

KNA1 I GOT THE ADRNR FIELD ( IE ADDRESS)

BUT THAT CAN BE MAPPED TO TABLE ADR6 DIRECTLY BY ADRNE

WHY U WANT TO MAP TO ADRP FIRS BY PERSON NUMBER

ALSO WIHC I WAS UNABLE TO FIND THE ADRNR IN KNA1 HAS NO ENTRY IN ADRP BUT HAS ENTRY IN ADR6 AND EMAIL ID I DIRECTLY FOUND THERE

CAN U ELOBORATE THE REASON FOR THAT?

REGARDS

ARORA

[Former Member]

Hi Nishant,

Mail ID 's are stored in ADR6 table field is (SMTP_ADDR)

please close u r previous threads,

reward points to all helpful answers

kiran.M

[Former Member]

hi Kiran

my previeous thread is how to find the table the PROCESS it not for the information as in this mail

regards

Arora

[former_member358602]

Hi Nishant,

SELECT single *

FROM ADR6

INTO wa_adr6

WHERE persnumber EQ prsnr.

wa_adr6-smtp_addr is email field.

Regards,

Ramesh