The list of table is as under: You have to figure
out the table according to your requirement.
None the less CRMD_ORDERADM_H, CRMD_ORDERADM_I will give
you info about all the transactions.
BUT000 : BP: General data - Contains Business Partner
Number, Partner Category, Partner Type, First Name, Last Name etc.
BUT020 : BP: Addresses
BUT050 : BP relationships/role definitions: General data
- Contains Relationship, Partner Number (PARTNER1), Relationship Category
BUT051 : BP Relationship: Contact Person Relationship
Similar to
BUT050 : Additionally contains Contact Person's Address
data
BUT0BK : Business Partner: Bank Data & Details BP
Number, Bank Key, Bank Country Key, Bank Account Number
BNKA : Bank Master Data
BUT100 : BP: Roles
ADR2 : Telephone Numbers (Business Address Services)
ADR6 : SMTP Numbers (Business Address Services) - Contains
Email Id of the BP.
ADRC : Addresses (Business Address Services) - BP's Complete
Address Details- City, Country, Post Code, District, Street, Title No Etc
TSAD3T : Table containing the Title text against a Title
No.
COMM_PRODUCT : Master Table for Product
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_OPPORT_H : OPPORTUNITY HEADER DATA
CRMD_ORDERADM_H : Contains the Header Information for
a Business Transaction.
Note:
1. It doesn't store the Business Partner responsible
for the transaction. To get the Partner No, link it with CRM_ORDER_INDEX.
2. This table can be used for search based on the Object
Id(Business Transaction No).
CRMD_OPPORT_H OPPORTUNITY HEADER DATA
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
Activities:
CRMD_ACTIVITY_H Activity Header table
CRMD_ACTIVITY_I Activity Reporting: Activity Line Item
Extension
CRMD_TM_ACTIVITY Activity reference
Lead:
CRMD_LEAD_H Lead Header table
Opportunity:
CRMD_OPPORT_H Opportunity Header table
BUT000 : BP: General data
Contains Business Partner Number, Partner Category, Partner
Type, First Name, Last Name etc.
BUT020 : BP: Addresses
BUT050 : BP relationships/role definitions: General data
Contains Relationship, Partner Number (PARTNER1), Relationship Category
BUT051 : BP Relationship: Contact Person Relationship
Similar to BUT050, additionally contains Contact Persons Address data
BUT0BK : Business Partner: Bank Data & Details BP
Number, Bank Key, Bank Country Key, Bank Account Number
BNKA : Bank Master Data
BUT100 : BP: Roles
ADR2 : Telephone Numbers (Business Address Services)
ADR6 : SMTP Numbers (Business Address Services) Contains
Email Id of the BP.
ADRC : Addresses (Business Address Services) : BPs Complete
Address Details- City, Country, Post Code, District, Street, Title No Etc
TSAD3T : Table containing the Title text against a Title
No.
COMM_PRODUCT : Master Table for Product
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:
1. It doesnt store the Business Partner responsible
for the transaction. To get the Partner No, link it with CRM_ORDER_INDEX.
2. 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 |
SAP CRM Tips
|