SMTP Address

[Soady, Phil]

Good advice...
but if you must hack (it makes me feel better as well)

The KNA* tables contain a pointer to the address tables.
The key is the address number.

go to ST05.  Turn the SQL trace.
Create a customer and enter an SMTP address.

No go back and turn of the trace. Then list it.
You can see the SQL statement needed to access the data.

Happy HACKing or use the BUPA and BAPI*Customer bapis.

Cheers
 


Phil Soady
Senior Consultant
Business Technologies
SAP Australia 
M  +61 (0) 412 213 079
E  phil.soady at sap.com


-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of Dart, Jocelyn
Sent: Monday,10 January 2005 10:27 AM
To: SAP Workflow Users' Group
Subject: RE: SMTP Address

Steve, 
Please stop looking directly at tables now!  Use the BAPIs and other
function modules and you will have much more
success. 
For customers try looking at business partner function modules (*BUPA*)
or the customer bapis (BAPI*CUSTOMER*).
Regards,
Jocelyn 

 

-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of Steve Johnson
Sent: Friday,7 January 2005 6:54 PM
To: SAP Workflow Users' Group
Subject: SMTP Address

Hello,

We are trying to gather customer vs. smtp mail adress
information. We found that adr6 has all smtp email
adresses. Is there any link  between the XD02 customer
and smtp address. In XD03 we see that customer tied to
smtp address based on creation. 


Is it possible to related these to and download the
info. 

Please help! Thanks

TIA

=====
Thanks,
Steve Johnson
BSHG
_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug

_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug