Application Development 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
Showing results for 
Search instead for 
Did you mean: 

Address number in XD02...in KNA1

rahul2000
Contributor
0 Kudos
654

Dear All,

Can any one plz tell me where is the address number field in XD02 whih is ADRNR in KNA1 table.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
75

Hi!

You can't see this ADRNR field in the XD0* transactions, they are only background identifiers and can be seen only at table level.

However they are poinitng to the ADRC table.

Regards

Tamá

5 REPLIES 5

Former Member
0 Kudos
76

Hi!

You can't see this ADRNR field in the XD0* transactions, they are only background identifiers and can be seen only at table level.

However they are poinitng to the ADRC table.

Regards

Tamá

former_member598013
Active Contributor
0 Kudos
75

Hi Rahul,

You can get some additional information regarding hte customer address by the table ADR6.

IF you want to get email id etc.......

&*************Reward Point if helpful*****************&

0 Kudos
75

hi.

i want to pick up the email id...how can this be done?

0 Kudos
75

Hi Rahul,

SMTP_ADDR is the field for Email address.

select adr6~SMTP_ADDR from ADR6 inner join kna1 where

ADR6ADDRNUMBER eq kna1ADRNR where

kunnr in so_kunnr.

Regards,

Charumathi.B

0 Kudos
75

Hi Rahul,

I have already specified to get the Email id. Use Table ADR6.

It contains the email address field.

&************ Reward point if helpfull************&