on 06-17-2007 6:19 AM
Hi Friends,
I am a functional consultant these days i am in need of CRM Tables Information.
If anybody has got the list of impartant tables in CRM please mail me.
Thanks in advance,
Sridhar.P
e-Mail:
Moderation: email removed.
Message was edited by: Andrei Vishnevsky
Hi Sridhar,
<b>
Following are the CRM Tables:</b>
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
COMM_PRODUCT : Products
CRMC_T077D : customer account groups
CRMD_ORDERADM_H (for header) CRMD_ORDERADM_I (Item data)
CRMD_ORDERADM_H Business Transactions CRM
CRMD_ACTIVITY_H Activity
CRMD_OPPORT_H Opportunity
BUTOO : Customer details
BUT001 BP: General data II
BUT100 BP: Roles
BUT150 BP relationship: Attribute table (test
different
BUT_HIER_TREE Business Partner Group Hierarchy
CDBC_T_PRODUCTID Mapping: Product Id
CDBD_ORGMAN Business transaction - organizational unit -
set
COMC_PRODUCT General Product Settings
COMC_R3_FIELDS Assignment of R/3 material master fields to
CFOP
COMM_CATEGORY Category
COMM_CFGMAT Basic Data for Materials
COMM_HIERARCHY Category Hierarchy
COMP_TYPES Hierarchy Tool: Comparison Type Check
Table
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
Best Regards,
Pratik Patel
<b>Reward with Points!</b>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi friends,
I am techno functional anlyst and i have just joined the SAP capability. I am currently working on a CRM/IS-U project. I would really appreciate if someone coule give me more information about the main CRM tables and how they are ralted (Schema).
Thanks,
Javesh
Moderation: email removed.
Message was edited by: Andrei Vishnevsky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sridhar,
You can use these tables..
COMM_PRODUCT : Products
CRMC_T077D : customer account groups
CRMD_ORDERADM_H (for header) CRMD_ORDERADM_I (Item data)
CRMD_ORDERADM_H Business Transactions CRM
CRMD_ACTIVITY_H Activity
CRMD_OPPORT_H Opportunity
BUTOO : Customer details
BUT001 BP: General data II
BUT100 BP: Roles
BUT150 BP relationship: Attribute table (test
different
BUT_HIER_TREE Business Partner Group Hierarchy
CDBC_T_PRODUCTID Mapping: Product Id
CDBD_ORGMAN Business transaction - organizational unit -
set
COMC_PRODUCT General Product Settings
COMC_R3_FIELDS Assignment of R/3 material master fields to
CFOP
COMM_CATEGORY Category
COMM_CFGMAT Basic Data for Materials
COMM_HIERARCHY Category Hierarchy
COMP_TYPES Hierarchy Tool: Comparison Type Check
Table
CRMC_CPRICPROC Customer Pricing Procedures
SMOKVBEZ15 Assignment employees to positions
R/3 Tables re CRM:
CRMRFCPAR : CRM Destination
CRMPRLS: GUID entry
CRMCONSUM: COnsumer entry (must match consumer of object in R3AC*)
KNA1 : Business Partner Master Data.
CRMPARNR : Partner Functions \ Contacts
CRMKUNNR : Business Partner GUIDS
KNVV: Sales Area Data
KNVP: Sales Area Data
KNVK: Contact Person
TBE31 & 34 : Events
MARA : Products
CRMFILTAB : Filters
CRMBP_MAP_BUGRP Mapping of Business Partner Grouping
CRMCLASSIF Account Groups in Replication into R/3
CRMCONSUM Possible Users R/3 Adapter Functionality
CRMFILFLD Permitted Table Fields for Filtering
CRMFILTAB Filter Criteria for Download
CRMINTBAP Assignment of Internal& External Table FLD
CRMKTOKD Assign Classification and Grouping R/3 Account Groups
CRMKUNNR Mapping Table Business Partner - Customer
CRMMAPTAB Relationship Between Table Names in CRMOBJTAB and BAPIMTCS
CRMPARNR Mapping Table Business Partner Relationship - Contact Person
CRMPAROLTP CRM OLTP Parameter
CRMQNAMES Queue Name Management for CRM-QRFC Supply
CRMSUBTAB Subscription Table for Up and Download Objects
COM_BUPA_CALL_FU Determining FMs for Data Exchange BP
COM_BUPA_BCSET Central Settings Data Exchange Business Partner
TCRMBP_REFCUST Default Reference Customer
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
CRMD_ORDERADM_H - PROCESS_TYPE field will give the transaction type.
CRMC_PROC_TYPE List of transaction types.
CRMV_LINKORGMAN Find out the Sales orgn.
Please Award points if it is Useful to you.
Regards,
Satish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
there is some of the tables used for CRM
Sales order / Quote / Sched Agreement / Contract
VA02 Sales order change
VA05 List of sales orders
VA22 Quotation change
VA32 Scheduling agreement change
VA42 Contract change
Billing
VF02 Change billing document
VF11 Cancel Billing document
VF04 Billing due list
FBL5N Display Customer invoices by line
FBL1N Display Vendor invoices by line
Delivery
VL02N Change delivery document
VL04 Delivery due list
VKM5 List of deliveries
VL06G List of outbound deliveries for goods issue
VL06P List of outbound deliveries for picking
VL09 Cancel goods issue
VT02N Change shipment
VT70 Output for shipments
General
VKM3, VKM4 List of sales documents
VKM1 List of blocked SD documents
VD52 Material Determination
thanks
Roopesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sent to ur email Id.
Please, allot points,
Regards,
Arjun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.