Table name could not found to link BUT000 in CRM5.0

[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 Vinay,

Here some of the tables of CRM ...

CRMM_BUAG: Master Table for Business Agreement

CRMM_BUAG_H: Header Data for Business Agreement such as Tax Category, Tax Characteristic, Form key, Business Agreement Class. Data in this table correspond to ISU CRMD_ORDERADM_H: Contains the Header Information for a Business Transaction.

[Note: It doesn’t store the Business Partner responsible for the transaction. To get the Partner No, link it with CRM_ORDER_INDEX. This table can be used for search based on the Object Id(Business Transaction No). ]

CRMD_CUSTOMER_H Additional Site Details at the Header Level of a Business Transaction

CRMC_PROC_TYPE Master table Business Transaction Type

CRMC_PARTNER_FCT Definition of Partner Functions

SCPRIOT Priorities for Activities with priority text.

CRMC_PROC_TYPE_T Text for a transaction type

CRMC_ACT_OBJ_T: Objective Number and Text for Activities

TJ30T: All the status code and text

CRMC_PR_ASSIGN: Transaction Type and its Transaction Type Object.

IBIB : Installed Base/Ibase

IBIN : Installed Base Components

CRMD_ORDERADM_H (for header) CRMD_ORDERADM_I (Item data)

CRMD_ORDERADM_H Business Transactions CRM

CRMD_ACTIVITY_H Activity

CRMD_OPPORT_H Opportunity

CDBC_T_PRODUCTID Mapping: Product Id

CDBD_ORGMAN Business transaction - organizational unit -

set

CRMC_CPRICPROC Customer Pricing Procedures

SMOKVBEZ15 Assignment employees to positions

CRMMLSGUID: GUID entry (should match GUID in CRMPRLS)

CRMM_BUT_CUSTNO : Also GUID table (GUID here should match GUID in R/3 table CRMKUNNR)

SMOFSUBTAB : Mapping & Parameters

SMOFDSTAT : Download Monitor (R4AM1)

SMOFFILTAB : Filters (Should match filters in R3AC1 & R/3 Table CRMFILTAB)

SMOFOBJECT Definition of Objects for Download

SMOFOBJPAR Parent Objects of an Object in Table

SMOFPARSFA Middleware Parameter

SMOFQFIND Queue Finder Table for MW-Queue finder

SMOFTABLES Definition of Tables for Download

regards,

• Dj

reward for all useful answers.

[Former Member]

If you want to see all the tables you can check the table DD02L, but this table will have all the SAP tables include CRM...

regards

• Dj

reward for all useful answers.