06-17-2008 12:36 PM
Dear All,
Can any one plz tell me where is the address number field in XD02 whih is ADRNR in KNA1 table.
06-17-2008 12:38 PM
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á
06-17-2008 12:38 PM
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á
06-17-2008 12:44 PM
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*****************&
06-17-2008 12:45 PM
06-17-2008 1:15 PM
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
06-17-2008 1:25 PM
Hi Rahul,
I have already specified to get the Email id. Use Table ADR6.
It contains the email address field.
&************ Reward point if helpfull************&