SAP Tables

[Former Member]

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

[Former Member]

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

[Former Member]

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