06-29-2007 7:49 AM
Hi
Experts
I have one requirement where i should drag email and URL attached to ORg's
so i had developed Quicviewer query where i am not able to get table names for this URL and email
by pressing F1 i had got table name for URL as TSAC
and email id is SZA1_D0100
But in developing this query i could not able to connect it with Table BUT00
Where exactly i can get all the Table names for CRM5.0
I request you to kindly guide me on this as soon as possible
As it is very urgent
Thanks in Advance
regards
Vinay
06-29-2007 8:00 AM
Hi
Take the ADDRCOMM field of BUT000 and try to link with the communication related tables
in SE11 give AS* and you will get the lot of tables check them which one stores the Coomunication type URL
In SAP ADR6 stores the mail Ids
and with the ADDRESS NUMBER field we link that table and take the URL/MailID.
Reward points for useful Answers
Regards
Anji
06-29-2007 8:12 AM
Here is the Function module for Creatin of the Parter with email di and ur l /SAPHT/DRM_ECMASTER_CREATE .
/SAPHT/DRM_ECRETURNS_DR EC Returns Processing at Distributor-Reseller
/SAPHT/DRM_ECRETURNS_MS EC Returns Processing at Manufacturer-Supplier
you need not ise BUT00 and TSAC ...
struture SZA1_D0100 was linked with KNA1 table wherein with partner Flag it determines the Custmor is an Parnter ...
Because the Partners are stored in the Customer table it self with Partner Fields .
reward points if it is usefull ...
Girish