SAP*BYTE

November 2009
M	T	W	T	F	S	S
« Dec
	1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30

CRM – Tables and Transaction Codes

Posted by crmQ on December 23, 2008

TABLE NAME	DESCRIPTION
	BUSINESS PARTNERS
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. Note: Pass the langu key with the language in which you want the text.
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 Contract account table FKKVKP.
CRMM_BABR_H	Rule data for business agreements – data in this table correspond to ISU Contract account table FKKVK

	TRANSACTIONS

CNCCRMPRCUSZZBUR	Condition Records for Service Contracts. We get Basic Unit Rate, Standing Charge Rate etc. (This is a Z table used in a leading ISU SAP-CRM implementation. You can give the table SAP0090 – this is a standard table. – in general all condition tables have the naming convention CNCC*)
CRMD_ORDERADM_H	Contains the Header Information for a Business Transaction. Note: 1. It doesn’t store the Business Partner responsible for the transaction. So, 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. Note: Pass the langu key with the language in which you want the 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_LINK	Transaction GUID set for all the Business Transactions
CRMD_ORDER_INDEX	Contains Header as well as Item details for a Business Transaction. Note: 1.It doesn’t store the Business Transaction No (Object ID). To get the Business Transaction No link the table with CRMD_ORDERADM_H 2. This table can be used for search based on the Partner No
CRMD_ORDERADM_I	Stores the Item information for a Business Transaction. The scenarios where we have a Contract Header and within contract we have Line Items for the contract, this table can be useful. E.g. Service Contracts
CRMD_CUSTOMER_I	Additional Site Details at the Item Level of a Service Contract
SCAPPTSEG	Table for individual Appointment Types for a transaction.
CRM_JEST	Individual Object Status for any business transaction.
CRM_JCDS	Current Status for a business transaction along with set date, set time and status code.

BUSINESS PARTNER <> TRANSACTION TABLE RELATIONSHIP:

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, 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_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_ACTIVITY_H Activity Header table
CRMD_ACTIVITY_I Activity Reporting: Activity Line Item Extension
CRMD_TM_ACTIVITY Activity reference
CRMD_LEAD_H Lead Header table
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, 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.
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_ACTIVITY_H Activity Header table
CRMD_ACTIVITY_I Activity Reporting: Activity Line Item Extension
CRMD_TM_ACTIVITY Activity reference
CRMD_LEAD_H Lead Header table
CRMD_OPPORT_H Opportunity Header table

you can do is follow the below procedure to get the list
1. open table TDEVC and put DLVUNIT = ‘BBPCRM’.
you will get all the development classes for CRM.
2. open table TADIR and enter the following,
PGMID = ‘R3TR’
OBJECT = ‘TABL’
DEVCLASS = All the devclasses found above in step 1.

TRANSACTION CODES:

useful t-code for sales mktg and cic etc.

CRMBS02 Maintain Status Profiles
CRMBS03 Display Status Profiles
CRMBS42 Maintain Status Selection Profiles
CRMBS43 Display Status Selection Profile
CRMBS52 Maintain Authorization Keys
CRMBS53 Display Authoriztaion Key
CRMBWST Genertd DataSource for BW Status Obj
CRMBWTARGETS Release Data Target for BW Upload
CRMBW_CIC_ATTRIBUTES BW Key Figures for CRM
CRMCACTARC Archiving Control CRM Activity
CRMCPRMSG Configure Customer-Specific Messages
CRMCUSTOM Monitoring Middleware System
CRMC_ACTION_CONF Configure Action Profile
CRMC_ACTION_DEF Define Action Profile
CRMC_ACTION_JOB Action Monitor
CRMC_ACTION_PRINT Configure action profile (old)
CRMC_ACTION_WIZARD Action for Definition via Wizard
CRMC_ACTIVITY_H Customizing Maintenance Activity
CRMC_ACT_CATEGORY Cust. Maint. Activity: Category
CRMC_ACT_OBJ Cust. Maintenance Activity: Goal
CRMC_ACT_SURVEY Cust. Maint. Activity: Questionnaire
CRMC_AM_JCLASS Alert Modeler Java Class
CRMC_ATP_PROFILE Customizing Maintenance: APO Profile
CRMC_BLUEPRINT Maintenance for BSP Blueprint
CRMC_BLUEPRINT_C IMG Call
CRMC_BL_CHECK Check Blueprint Tables
CRMC_BL_COPY_QUERIES Copy Report Delivery Queries
CRMC_BP_CCKPT_PB Cust.Maint. BP Cockpit: Pushbuttons
CRMC_BSP_ANALYZE Starts CRMC_BSP_FRAME: Analysis Mode
CRMC_BSP_WD_MSGDEFH Message Default Handler Assignment
CRMC_BUAG_NUMBERS Number Range Maintenance: BUAG
CRMC_BUPA_CONSUM Maintain reference business partner
CRMC_BUPA_INITIAL Table Maintenance CRMC_BUT_INITIAL
CRMC_BUS_SUBOB_C Assign. BUS – Allowed Appl. Areas
CRMC_BUS_SUBOB_I Assignment BUS-allowed app.area item
CRMC_BUT_CALL_FU Establishing FMs for Data Exchng BP
CRMC_CAI_COCKPIT CAI – Test Cockpit
CRMC_CATAGORY_WP Cust. Maintenance Application Area
CRMC_CATALOG_DEFINE Create Catalog
CRMC_CATALOG_OVV Catalog Overview
CRMC_CIC_AB_LSYS_ASS Action Box: Assign logical systems
CRMC_CIC_AB_LSYS_CRE Action Box: Create logical systems
CRMC_CIC_AB_LSYS_RFC Action Box: Assign LogSYS to RfcDest
CRMC_CIC_AB_NAV Action Box Navigation Area
CRMC_CIC_AB_WEBGUI Define ITS for WebGui Mode
CRMC_CIC_ACT0 Transaction component profile
CRMC_CIC_AM_LANG Lang. dependent text – Alert Modeler
CRMC_CIC_AM_META Define Customer-Specific Meta Model
CRMC_CIC_AM_PROFILE Maintan Alert Modeler Editor Profile
CRMC_CIC_BP_PROFILE Maintain Profile Templates
CRMC_CIC_BROAD broadcasting profile assign
CRMC_CIC_COMP_ACTION Component Actions (for locator, BDD)
CRMC_CIC_EXT_INB_ACT Activate Agent Inbox
CRMC_CIC_FW_MAINTAIN Maintain Framework ID and Parameters
CRMC_CIC_MAIL_ADDR Addresses for Agent Inbox
CRMC_CIC_MAIL_E_RESP Maintain Rules for E-Mail
CRMC_CIC_MAIL_F_RESP Maintain Rules for Fax
CRMC_CIC_MAIL_GLOBAL Define Global Settings
CRMC_CIC_MAIL_IBXPRF Define Inbox Settings
CRMC_CIC_MAIL_TASKS Task Classification
CRMC_CIC_MAIL_WF Assign Agent for E-Mail Handling
CRMC_CIC_RESTART Set Time & Memory for Restart
CRMC_CIC_SEARCH_CNTR Maintain Search Components
CRMC_CIC_SEARCH_RULE Maintain Search Attributes
CRMC_CIC_TITLE_TEXTS Maintain Window Title
CRMC_CIC_WSP0 Workspace Definition
CRMC_CIC_WSP1 Inbox Profiles
CRMC_CIC_WSP2 E-Mail Editor Profiles
CRMC_CIC_WSP3 Default Workspaces Profile
CRMC_CIC_WSP_EDITOR2 Editor Profiles
CRMC_CLM_ACTION_CONF Configure Action Profile
CRMC_CLM_ACTION_DEF Define Action Profile
CRMC_CLM_ACTION_WIZ Action for Definition via Wizard
CRMC_CLM_BTSYNC Business transaction synchronization
CRMC_CLM_CALLATTRS Call Attributes
CRMC_CLM_CALLRESULTS Call results
CRMC_CLM_CLDP Call list determination procedures
CRMC_CLM_CLTYPES Call list types
CRMC_CLM_CMPGPM Campaign priority mapping
CRMC_CLM_CTMAP Calling Times Mapping
CRMC_CLM_ORCC Order control components
CRMC_CLM_RSCHVL Rescheduling validation procedures
CRMC_CLM_SORCC Standard order control profiles
CRMC_CLM_STMAP Call State Mapping
CRMC_CPRICPROC Definition of Cust. Determ. Proced.
CRMC_CP_BADI_F Copying BADI – Text Maintenance
CRMC_CSDR_ADD_CUST Design Registration Project
CRMC_CSDR_APPL_CUST Design Registration Project
CRMC_CUST_APPLLAYOUT ViewCluster Mtnce CRMV_APPLLAYOUT
CRMC_DPRICPROC Definition of Document Procedures
CRMC_EXEC_BAB CRM: Start business applic. builder
CRMC_EXEC_BAB_C CRM: Start OAS in customer mode
CRMC_EXEC_BAB_D CRM: OAS in customer design mode
CRMC_EXEC_BAB_S CRM: Start OAS in SAP mode
CRMC_IC_ACPROF Maintain Activity Clipboard profiles
CRMC_IC_ACTIONPROF Maintain Actions profiles
CRMC_IC_ACTIONWZ Start Action Box Wizard
CRMC_IC_ALERTMODELER Alert Modeler customizing
CRMC_IC_AMWZ alert wizard
CRMC_IC_AM_PHS Maintain Alert Modeler Placeholder
CRMC_IC_AM_PRM Alert Modeler Input Parameters
CRMC_IC_AUI_FWD Define Forwards for Inbox Items
CRMC_IC_AUI_GEN Agent Univ. Inbox – CRMV_IC_AUI_GEN
CRMC_IC_AUI_MAINCAT Define Main Categories
CRMC_IC_AUI_MAP_PRI Map Native to Inbox Priorities
CRMC_IC_AUI_MAP_STA Map Native to Inbox Status
CRMC_IC_AUI_PARTNER Agents Universal Inbox – Partners
CRMC_IC_AUI_PROFILE Define and Assign Inbox Profiles
CRMC_IC_AUI_QUICKS Define Quick Searches
CRMC_IC_AUI_TIMEPER Define Time Periods
CRMC_IC_BDCCONTEXT Specify alternative BDC context
CRMC_IC_BPPROF Define Profiles for Customer Identif
CRMC_IC_BTPFAS Assignment of Partner Functions
CRMC_IC_BTPROF Profile for Business Transaction
CRMC_IC_CHTPROF Maintain profiles for Chat
CRMC_IC_CLMPROF Call List Profile Maintenance
CRMC_IC_CM Content Management Customizing
CRMC_IC_EMLPROF Maintain profiles for Email
CRMC_IC_EVENTING Event management customizing
CRMC_IC_EVENTS IC WebClient Events
CRMC_IC_MAIL_E_RESP Maintain Rules for E-Mail
CRMC_IC_MAIL_F_RESP Maintain Rules for Fax
CRMC_IC_MAIL_WF Assign Agent for E-Mail Handling
CRMC_IC_MAIN Main Component Customizing
CRMC_IC_MCM_CCPRO Define Com Mgmt Software Profiles
CRMC_IC_MKTPROF Campaign Profile Maintenance
CRMC_IC_NAVBARWZ CRMC_IC_NAVBARWZ
CRMC_IC_NAVBAR_PERM Nav Bar Permanent Profile
CRMC_IC_NAVBAR_PERS Nav Bar Personalizing Profile Defaul
CRMC_IC_RTFRAMEWORK IC WebClient Runtime Framework
CRMC_IC_SCRIPT Maintain Interactive Scripting Prof
CRMC_IC_SPH_AGENTPRO Maintain Profiles for SPH Agent
CRMC_IC_TLBPROF Maintain profiles for Toolbar
CRMC_IC_TRACE Activate activity tracing for agent
CRMC_IC_WCTPROF Maintain profiles for Web Context
CRMC_IC_XML_TEMPLATE XML template maintenance
CRMC_IIA_KERNEL IIA: Customizing for Learning Engine
CRMC_IIA_REPORT IIA: Customizing for Learning Engine
CRMC_IOBJ_FIN_STATE Change Status of Individual Objects
CRMC_IPMO_BWSELOPT BW Select Optns: IPMO Sett.DataColl.
CRMC_IPMO_SRVUSE IPMO: Usage from Feature
CRMC_IPM_CLRRUL Clearing Control – Diagram Form
CRMC_ISA_IUSER Internet User Settings
CRMC_ITEM_CAT_GR Item Category Usage
CRMC_ITEM_MA Customizing Maintenance: Item Cats
CRMC_IT_ASSIGN Customizing Maint.: Item Cat. Dtrmtn
CRMC_IT_COPY_IF Copy: Item category determination
CRMC_IT_COPY_MA Copy Item Categories
CRMC_IT_TYPE_US Item Category Usage
CRMC_LAYOUTC_GENE Generation of Customer Table Layout
CRMC_LAYOUT_GENERATE Generation of Layout Table
CRMC_LOGS Maintenance of message classes
CRMC_MAP Customer Maintenance Mapping
CRMC_MKTCA_WF_CUST Workflows Campaign Automation
CRMC_MKTLIST_WF_CUST Workflows External List Management
CRMC_MKTPL_ACT_CONF Configure Action Profile
CRMC_MKTPL_ACT_DEF Define Action Profile
CRMC_MKTPL_ACT_WIZ Action for Definition via Wizard
CRMC_MKTPL_FAW_CPG Field Selection Campaign
CRMC_MKTPL_FAW_CPT Field Selection Campaign Element
CRMC_MKTPL_FAW_DLM Field Selection Deal
CRMC_MKTPL_FAW_MPL Field Selection Marketing Plan
CRMC_MKTPL_FAW_MPT Field Select. Marketing Plan Element
CRMC_MKTPL_FAW_TPM Field Selection Trade Promotion
CRMC_MKTPL_FAW_TPT Field Selection Trade Element
CRMC_MKTPL_MAPPING Customizing Field Assignment MS Proj
CRMC_MKTPL_RT_AC Maintaning residency time
CRMC_MKTPL_SETTYPE Marketing Planning: Process Set Type
CRMC_MKTTG_CUSTMSG Configure Customer-Specific Messages
CRMC_MKTTG_DTY CRM Marketing: View Display Type
CRMC_MKTTG_MGR_H CRM Marketing: Report Name
CRMC_MKTTG_OPT_H CRM Marketing: Sample Optimization
CRMC_MKTTG_RUL CRM MKT: Split/Reduce Rules for TGs
CRMC_MKTTG_SA_DP Assign Attribute Type to Display
CRMC_MKTTG_SA_TP CRM Marketing: View Attribute Types
CRMC_MKTTG_TYP_H CRM Marketing: Target Group Type…
CRMC_MKT_PARAMBW Customizing for BW Parameter ID
CRMC_MSGC Customizing CRM message attribute
CRMC_MSGS CRM message attribute maintenance
CRMC_NR_CONF Number Range Maint.: CRM_CONF
CRMC_NR_MPK_MPOINT Number Range Maint.: Counter
CRMC_NR_MPK_READING Number Range Maint.: Counter Reading
CRMC_NR_RA_ACTIVITY Number Range Maintenance: CRM_ACTIVI
CRMC_NR_RA_CONFIRM Number Range Maintenance:CRM_confirm
CRMC_NR_RA_FANF Number Range Maintenance: CRM_SERVIC
CRMC_NR_RA_LEADS Number range maintenance: CRM_LEAD
CRMC_NR_RA_OPPORT Number Range Maintenance: CRM_OPPORT
CRMC_NR_RA_SALES Number Range Maintenance: CRM_SALES
CRMC_NR_RA_SERVICE Number Range Maintenance: CRM_SERVIC
CRMC_NR_RA_SRV_CONF Number range maintenance: CRM_SRV_CF
CRMC_NR_RA_SUR Number range maintenance: CRM_SUR
CRMC_NR_SRV_CONF
CRMC_OBJECTS Subobjects of CRM Document
CRMC_OBJECT_ASSI Assignment Appl. Area – CRM Object
CRMC_OPPORT_H Customizing Maintenance: Opportunity
CRMC_ORGPROF Maintenance of Org. Data Profile
CRMC_PARTNER_AS Maintenance of Access Sequences
CRMC_PARTNER_FCT Maintenance of Partner Functions
CRMC_PARTNER_MAP2CRM Mapping Partner Functions into CRM
CRMC_PARTNER_MAP2R3 Mapping Partner Functions into R/3
CRMC_PARTNER_PDP Maintenance of Partner Procedures
CRMC_PARTNER_PFT Maintenance of Partner Function Typ
CRMC_PFTREL BP PartnerFunctionCat.for Rel. Cat.
CRMC_PLSRV_REL Product Proposal
CRMC_PPR_CTRL Maintain Global PPR Settings
CRMC_PPR_DEFINE_APPL Define Applications using PPRs
CRMC_PPR_DEFINE_OCHK Transaction Types Rel. for PPR Check
CRMC_PPR_DEFINE_PARA Customer Maintenance Rule Parameter
CRMC_PPR_DEFINE_RULE Customer Maintenance Rule Definition
CRMC_PPR_DEFINE_SRTB Define Sort Routines for BPartners
CRMC_PPR_DEFINE_SRTP Define Sort Routines for Products
CRMC_PPR_DEFINE_TYPE Customer Maintenance PPR Types
CRMC_PRCPROC_DET Cust. Maint. Pr. type determination
CRMC_PRCTYPE_DET Cust. Maint. Pric. Proced. Maint.
CRMC_PROCESS_MA Customizing Maint.:Transaction Types
CRMC_PROD_FIN_COPY Copy Financing Product
CRMC_PROD_FIN_HIER Create Financing Hierarchy
CRMC_PRPS BP Function Proposal Procedure
CRMC_PRP_IL_MAP PPR-Customizing: Maintenance Mapping
CRMC_PRP_OBJECTS PPR-Customizing: Maintenance Mapping
CRMC_PR_COPY_MA Copy Tranasction Types
CRMC_R3_ORG_GENERATE R/3 organizational data generation
CRMC_SALES_ITEM Sales Customizing at Item Level
CRMC_SERVICE_H Customizing Maintenance: Service
CRMC_SERVICE_IPT Maintenance of Internet Trans. Types
CRMC_SLS_ITM_BIL Maint. Item Types & Billing Relev.
CRMC_SRVCATIFC Catalog Integration
CRMC_SUBJPROFILE_H Define Subject Profile
CRMC_SUBOB_CAT Application Areas
CRMC_SUBOB_CAT_I Item – Business Object Types
CRMC_SWITCH_ORGMODEL Convert Org. Model
CRMC_TAX_CUST_UPD Maintain Condition Function in Cond.
CRMC_TAX_GROUP Tax Group Customizing
CRMC_TAX_MAP Tax Group Customizing
CRMC_TAX_SCHEMA Maintain tax procedures
CRMC_TIMEPROF CRM date profile
CRMC_TM_CLPROF0 Call list profile maintenance
CRMC_TM_NSM Namespace manager
CRMC_TM_PSM Persistent storage manager
CRMC_WEBREQ Request Categories for Web Requests
CRMC_WEBREQ_BEGR Authorization Groups for Views
CRMC_WEBREQ_BEGR_DIS Authorization Groups for Views
CRMC_XMLEDITOR Start XML Editor for Spice
CRMD_AR_MAINTAIN Process Product Association Rule
CRMD_BILLING Transfer Invoice Data to R/3
CRMD_BILL_REV Cancel Billing Document
CRMD_BUS2000107 Process Framework Agreements
CRMD_BUS2000108 Maintain Leads
CRMD_BUS2000111 Maintain Opportunities
CRMD_BUS2000112 Maintain Service Contracts
CRMD_BUS2000113 Process Purchase Contracts
CRMD_BUS2000114 Maintain Sales Contracts
CRMD_BUS2000115 Maintain Sales Transactions
CRMD_BUS2000116 Edit Service Processes
CRMD_BUS2000117 Process Service Confirmations
CRMD_BUS2000120 Process Complaints
CRMD_BUS2000121 Maintain Sales Contracts
CRMD_BUS2000126 Maintain Activities
CRMD_BUS2000210 Maintain Product Service Letter
CRMD_BUS2000220 Maintain Partner Design Project
CRMD_BUS2000230 Maintain License Sales Contracts
CRMD_BUS2000231 Edit License Acquisition Contracts
CRMD_BUS2000232 Edit License Usage Confirmation
CRMD_CALL_LIST Generation of Call Lists
CRMD_CC Currency Change
CRMD_CCKPT_VIEWCUST customizing for role default views
CRMD_CD Display of Document Changes
CRMD_CODEX CRM Codex : Evaluation
CRMD_CSDR_PROJ_FAST Fast entry screen for Project
CRMD_DOWNLOAD_OM CRM Mobile Client Download (Online)
CRMD_DOWNLOAD_SB Download Sales Bundling Data to CDB
CRMD_EMAIL Maintain Mail Form
CRMD_EMAIL_LIST Display Marketing Bus. Activity List
CRMD_EMAIL_TEMPL Maintain Mail Template
CRMD_EMAIL_TEMPL1 Maintain Mail Form
CRMD_EVENT_CHECK EH:Callback for Trans.Type/Item Cat.
CRMD_EVENT_TRACE Evaluate Transaction Event Trace
CRMD_IIA_FAQ Maintain Frequently Asked Questions
CRMD_IIA_REPORT Generate Statistics Reports
CRMD_IM_MAIL_DELETE Delete Marketing Bus. Activity List
CRMD_INDEX_OM Index structure search OM
CRMD_IPM_AVAILABLE Analyze Rights Availability
CRMD_IPM_EVENT Date/Event Management
CRMD_IPM_HIER Maintain Hierarchical Attributes
CRMD_IPM_HIER_VIEW Maintain Hier.Attributes Views
CRMD_IPM_RD_PCUI_GEN IPM: Generate People Centric UI
CRMD_ISA_AUC_ATT Web Auction Attributes Setup
CRMD_ISA_EAUCTION Manage Web Auctions
CRMD_LEAD_FREE_SEL Lead Monitor: Free Selection
CRMD_LEAD_MONITOR Lead Monitor – Organizational View
CRMD_LEAS_ME_ACCRUAL Month-End Accruals
CRMD_MINIPROCESS Process a Transaction from MiniApp
CRMD_MKTDS Data Sources for Segment Builder
CRMD_MKTDS_WIZARD Data Source Wizard
CRMD_MKTLIST External List Management
CRMD_MKTLIST_MAP CRM Marketing : ELM Mapping Tool
CRMD_MKTPL_AL00 CRM: Allocation Application
CRMD_MKTPL_AL02 CRM: Allocation Rules
CRMD_MKTPL_AL03 CRM: Allocation Priorities
CRMD_MKTPL_AL04 CRM: Status of actual quantities
CRMD_MKTSEG Segment Builder
CRMD_MKTSEG_MGR Edit Master Groups/Samples
CRMD_MKT_EXP CRM Marketing: Export Target Group
CRMD_MKT_PROC Create Business Transactions
CRMD_MKT_TOOLS Marketing Tools
CRMD_MKT_TRANS CRM Marketing: Transport to Channels
CRMD_OPPORT_FAST My opportunities – fast change
CRMD_ORDER Transaction Processing
CRMD_ORDER_BP Business Partner Cockpit
CRMD_ORDER_LEAS_WOFF Write-Offs Mass Update Leasing
CRMD_ORDER_OBJLINK CRM Order via BUS Type and Number
CRMD_ORDER_PA Dialog Transaction CRMD_ORDER
CRMD_PROF_BP Business Partner Attributes
CRMD_PROF_CHAR Attribute Maintenance
CRMD_PROF_TEMPL Maintain Attribute Sets
CRMD_ROUTING_PROFILE Maintain Profiles and Attributes
CRMD_SDB_PRMN Maintain Info. Security Profile
CRMD_SDB_PROF Assign Profile to User
CRMD_SERV_CYCLE Define Service Cycles
CRMD_SERV_FORECAST Service Plan Forecasting
CRMD_SERV_SLA Availability and Response Times
CRMD_SRWWW Internet Transaction Service Request
CRMD_TG_IMPORT Import External Target Groups
CRMD_TM_CLDIST Call List Maintenance
CRMD_TM_CLMS Call List Management
CRMD_TRACE_EVAL Evaluation of API Trace
CRMD_TRACE_SET Activate/Deactivate API Trace
CRMD_TRACE_WATCHP Setting/Deletion of Watchpoint
CRMD_TRANSLATE Translate Mail Form
CRMD_TRANS_OM Translate Short Text for Org Units
CRMD_WEBREQ_CUST_OVW Customizing Evaluation: Web Requests
CRMD_WEBREQ_GEN_EXIT Generate start_exit Page
CRMD_WEBREQ_MONITOR Monitor for Web Requests
CRMD_WEBREQ_SIG_SHOW Display Digital Signature
CRMINIT First steps in middleware servers
CRMMDCS MAINT. DECISION TREE
CRMMDTREE The Overall Maintenance
CRMMNODE Transcation of maint. script node
CRMMNODET Transcation of maint. script node
CRMMONITOR Monitoring Middleware System
CRMMOPTION Maint. Tansaction to script option
CRMMSCRCHECK CHECK SCRIPT CONSISTENCY
CRMMTREE SCRPT TREE MAINTENCE
CRMMTREET SCRPT TREE MAINTENCE
CRMM_BPCURR Currency Changeover Business Partner
CRMM_BPD Business Partner Diagnosis
CRMM_BUPA_MAP Business partner data exchange
CRMM_BUPA_SEND Business Partner: Sending Directly
CRMM_CIC_APDISPLAY Display IC WinClient Profile
CRMM_CSDR_PROD_MAIN Des.Reg. product attributes maintain
CRMM_HR_QUALI_DEF Create CRM relevant HR qualis remote
CRMM_HR_QUALI_GET Create attribute f. HR qualification
CRMM_IC_MCM_CCADM Maintain System Settings
CRMM_IC_MCM_CCLNK Assign Profiles
CRMM_ISA_IUSER Internet User Management
CRMM_ISA_UA Internet Sales – User Administration
CRMM_MARKET_ATTRSET Maintain Marketing Set Type
CRMM_MKT_SAMPLE Samples for Segment Builder
CRMM_PPR Maintain Partner/Product Range
CRMM_PPR_CHNG_STATUS Change Partner/Product Range Status
CRMM_PPR_GUID_INFO Program CRM_PRP_GUID_INFO
CRMM_PPR_GUID_PPR Display all GUIDs for a PPR
CRMM_PPR_LISTFORBUPA Program CRM_PRP_LIST_PPRS_FOR_BUPA
CRMM_PPR_LISTFORPROD Program CRM_PRP_LIST_BUPAS_FOR_PROD
CRMM_PPR_RULES Execute Partner/Product Range Rules
CRMM_PPR_SETTYPES Maintain PPR Set Types
CRMM_PPR_STATUS_TEST Change PPR Status for internal use
CRMM_PPR_TOPN Maintain Top n Products
CRMM_PRPROD Assign Pricing Reference Materials
CRMM_ROUTING start business routing
CRMM_ROUTING_COMPARE Business Routing: Compare Scenario
CRMM_ROUT_AGENT Maintain agents for business routing
CRMM_ROUT_GRP Start routing group of b. routing
CRMM_ROUT_GRP_BP Group Members for Routing Groups
CRMM_ROUT_PROF Maintain profile
CRMM_ROUT_PROF_BP Assign Routing Grp Member to Profile
CRMM_ROUT_PROF_CHAR Maintain Attributes
CRMM_ROUT_PROF_TEMP Maintain Profile Template
CRMM_SEARCH Knowledge Search
CRMM_TERRMAN Territory Management
CRMM_TM_SCRIPT Interactive scripting editor
CRMORDERARC Residence Times Transaction Types
CRMSE62 Activate Exchanged Short Texts
CRMST62 Create Industry Short Texts
CRMS_IC_ACTION_DF IC WebClient Data Flow Maintenance
CRMS_IC_CHECK Check System Settings and Status
CRMS_IC_CROSS_SYS Transaction Launcher Logical Systems
CRMS_IC_SYSTEM_PROPS IC WebClient System Properties
CRMV_CANCPROCEDURE Maintain cancellation procedures
CRMV_CANCRULES Maintain cancellation rules
CRMV_CHECK_EVENTS Check Cust. Tab. for Event Handler
CRMV_CHECK_SSC Check Screen Control Data
CRMV_CODEX CRM Codex: Maint. of Check Tables
CRMV_EVENT Customizing Event Handler
CRMV_GENIL Customizing Object Model Generic IL
CRMV_IPM_EVENTS Define Events
CRMV_IPM_HIER_ATTR Customizing: Hierarchical Attributes
CRMV_IPM_HIER_VIEW Hierarchical Attributes Views
CRMV_PARTY Maintain cancelling party
CRMV_SSC Mntce: Scrn Cntrl Data – CRM Trans.
CRMXIF_C1 Assignment Site ID Interface Type
CRM_AC Check Appointment Rule for Data Exch
CRM_ACE_ADM CRM ACE Administrator Console
CRM_ACE_ADM_OLD Old CRM ACE Activation Tool GUI.
CRM_ACE_DEV CRM ACE Developer Tools
CRM_ACT_CUST_FIELDS Add customer fields to Activity Jrnl
CRM_ACT_IBU_INCL Maintain IBU specific fields
CRM_ACT_JR_TMPT Create/Change Activity Jrnl Template
CRM_ACT_JR_TMPT_TYPE Create/Change Activity JRNL TempType
CRM_ACT_STD_JRNL Create Standard Activity Journal

OSS1 – SAP Online Service System
OY19 – Compare Tables
SA38 – Execute a program.
SCU0 – Compare Tables
SE12 – Dictionary: Initial Screen – enter object name
SE13 – Access tables in ABAP/4 Dictionary.
SE14 – ABAP/4 Dictionary: Database Utility.
SE14 – Utilities for Dictionary Tables
SE17 – General Table Display
SE30 – ABAP/4 Runtime Analysis
SE30 – Run Time Analysis (press Tips and Tricks button for good stuff)
SE30 – ABAP/4 Runtime Analysis: Initial Screen.
SE32 – ABAP/4 Text Element Maintenance
SE35 – ABAP/4 Dialog Modules
SE36 – ABAP/4: Logical Databases
SE37 – ABAP/4 Function Library.
SE37 – ABAP/4 Function Modules
SE38 – ABAP/4 Editor.
SE38 – ABAP Editor
SE38 – ABAP/4 Program Development
SE39 – Splitscreen Editor: Program Compare (Interesting tool to compare the programs of different system)
SE41 – Menu Painter
SE43 – Maintain Area Menu
SE51 – Screen Painter
SE51 – Screen Painter: Initial Screen.
SE54 – Generate View Maintenance Module
SE61 – R/3 Documentation
SE62 – Industry utilities
SE63 – Translate Short/Long Text.
SE63 – Translation
SE64 – Terminology
SE65 – R/3 documents. Short text statistics SE66 R/3 Documentation Statistics (Test!)
SE68 – Translation Administration
SE71 – SAPscript layout set
SE71 – SAPscript Layouts Create/Change
SE72 – SAPscript styles
SE73 – SAPscript font maintenance (revised)
SE74 – SAPscript format conversion
SE75 – SAPscript Settings
SE76 – SAPscript Translation Layout Sets
SE77 – SAPscript Translation Styles
SE80 – ABAP/4 Development Workbench
SE80 – Repository Browser: Initial Screen.
SE81 – SAP Application Hierarchy
SE82 – Customer Application Hierarchy
SE84 – ABAP/4 Repository Information System
SE85 – ABAP/4 Dictionary Information System
SE86 – ABAP/4 Repository Information System
SE92 – Maintain system log messages
SE93 – Maintain Transaction Codes
SE93 – Maintain Transaction.

BUT000           BP: General Data I
BUT000_BCS       Persistence of a BAS Address
BUT001           BP: General data II
BUT010           GP: old, do not use ==> BUT020
BUT020           BP: Addresses
BUT021           BP: Address usages
BUT021_FS        BP: Address Usage With Validity Data
BUT030           BP Where-Used List: Usages
BUT030G          BP Where-Used List: Generic Nodes
BUT030GT         BP Where-Used List: Generic Nodes, Text
BUT030T          BP Object Usage: Application Table, Texts
BUT050           BP relationships/role definitions: General data
BUT050_CD        BP Rel./Role Definition:Index Table for Change Doc.Access
BUT051           BP Relationship: Contact Person Relationship
BUT052           BP Relationship: Addresses
BUT053           BP Relationship: Company Interest
BUT054           BP Relationship (not used yet)
BUT0BANK         Business Partner: Bank Data
BUT0BK           BP: Bank details
BUT0CC           BP: Payment Cards
BUT0ID           BP: ID Numbers
BUT0ID_BIP_NOHIT Business Information Provider: Logging of non identified BP
BUT0IS           BP: Industries
BUT0VP           BP: Business Partner Assignment and Links
BUT100           BP: Roles
BUT150           BP relationship: Attribute table (test different.type TBUKR)
CRMM_BUT_BUHI_1 R/3 Customer Sales Area CRM BP Hierarchy Group Mapping
CRMM_BUT_BUHI_2 R/3 Leaf Customer Sales Area CRM BP Hierarchy Group Mapping
CRMM_BUT_CONTNO Mapping Table Business Partner Relationship – Contact Person
CRMM_BUT_CRMOBJ Buffer: Which BPs are in Which Systems
CRMM_BUT_CUSTNO Mapping Table Business Partner – Customer
CRMM_BUT_FRG0040 Business Partner Sales Classification List
CRMM_BUT_FRG0041 Business Partner Sales Classification
CRMM_BUT_FRG0042 Business Partner Sales Classification List Order Blocks
CRMM_BUT_FRG0050 Business Partner – Status
CRMM_BUT_FRG0060 Business Partner – Business Hours
CRMM_BUT_FRG0061 Business Partner – Business Hours Interval
CRMM_BUT_FRG0070 Business Partner Excluded Partner Functions List
CRMM_BUT_FRG0071 Business Partner Excluded Partner Functions
CRMM_BUT_FRG0080 Business Partner – Sales Area – Partner Function List
CRMM_BUT_FRG0081 Business Partner – Sales Area – Partner Function
CRMM_BUT_FRG0100 CRM Business Partner: Status
CRMM_BUT_KOR0040 Business Partner Korea
CRMM_BUT_KOR0041 Business Partner Korea History
CRMM_BUT_LNK0010 Business Partner – Sales Rule List
CRMM_BUT_LNK0011 Business Partner – Sales Rule
CRMM_BUT_LNK0020 Business Partner – Shipping Rule List
CRMM_BUT_LNK0021 Business Partner – Shipping Rule
CRMM_BUT_LNK0030 Business Partner – Billing Rule List
CRMM_BUT_LNK0031 Business Partner – Billing Rule
CRMM_BUT_LNK0140 Business Partner Organization Rule List
CRMM_BUT_LNK0141 Business Partner Organization Rule
CRMM_BUT_MIGRATE Migration Table: Fields Changed In CDB
CRMM_BUT_SEMPL00 Sales Employee for Contact Person Relationship: Admin. Tech.
CRMM_BUT_SEMPL01 Sales Employee to Contact Person Rel.: Data Table
CRMM_BUT_SET0010 Business Partner – Sales Rule Period
CRMM_BUT_SET0020 Business Partner – Shipping Rule Period
CRMM_BUT_SET0030 Business Partner – Billing Rule Period
CRMM_BUT_SET0140 Business Partner Organization Rule Period
CRMM_BUT_TDAR010 Business Partner – Time-Dependent Appointment Rules
CRMM_BUT_TDAR011 Business Partner – Time-Dependent Appointment Rule Intervals
CRMM_BUT_TDAR012 Business Partner – Time-Dependent Appt Rule Single Intervals
BUT_DNC          BP: Telephone Numbers of the “Do Not Call” List
BUT_DNC_OLD      BP: Telephone Numbers of the “Do Not Call” List
BUT_FRG0010      Business Partner: Tax Classification
BUT_FRG0011      Business Partner: Tax Classification
BUT_HIER_NODE    Business Partner Hierarchy Group
BUT_HIER_NODE_BP Business Partner Hierarchy Group – Bus. Partner Assignment
BUT_HIER_NODE_D Business Partner Hierarchy Group – Description
BUT_HIER_STRUCT Business Partner Hierarchy Group – Hierarchy Relationship
BUT_HIER_TREE    Business Partner Group Hierarchy
BUT_HIER_TREE_D Business Partner Group Hierarchy – Description
BUT_HIER_TYPE    Business Partner Group Hierarchy Category (GUID)
BUT_LOCA_APPL    Locator Applications
BUT_LOCA_APPLT   Locator Applications: Descriptions
BUT_LOCA_CSAP    Locator Customizing: Search Applications
BUT_LOCA_CSAPT   Locator Customizing: Search Application Texts
BUT_LOCA_CSID    Locator Customizing: Search IDs
BUT_LOCA_CSIDT   Locator Customizing: Search IDs Texts
BUT_LOCA_CSTY    Locator Customizing: Search Categories
BUT_LOCA_CSTYT   Locator Customizing: Search Categories Texts
BUT_LOCA_PSHIST Locator Personalization: Search History
BUT_TODO_PREMO   Personalization: Selected Objects per User

——————————-

TTXID                          Valid text IDs
TTXIE                          SAPscript: Function modules for INCLUDE ex
TTXIN                          SAPscript: Who with whom?
TTXIT                          Texts for Text IDs

TTXOT tables for texts in CRM. You can map R/3 text tables to CRM table. In this table having text id’s.

Where in the CRM database does the sales text get stored?

Eg: In genaral senario sales cycle has diffent texts are there
1) Genaral Opprtunity
2) Customer Acquistion
3) ISU New Customer etc….
those texts are get stored in CRM Table: CRMC_CYCLE_T

These are some text related tables
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
CRM_SVY_RE_ANSW – Survey Texts

STXH table is where all the texts get stored
Also check STXL table.

======================================

TCODES::::

CRMC_WEBREQ_BEGR Authorization Groups for Views
CRMC_WEBREQ_BEGR_DIS Authorization Groups for Views
CRMC_XMLEDITOR Start XML Editor for Spice
CRMD_AR_MAINTAIN Process Product Association Rule
CRMD_BILLING Transfer Invoice Data to R/3
CRMD_BILL_REV Cancel Billing Document
CRMD_BUS2000107 Process Framework Agreements
CRMD_BUS2000108 Maintain Leads
CRMD_BUS2000111 Maintain Opportunities
CRMD_BUS2000112 Maintain Service Contracts
CRMD_BUS2000113 Process Purchase Contracts
CRMD_BUS2000114 Maintain Sales Contracts
CRMD_BUS2000115 Maintain Sales Transactions
CRMD_BUS2000116 Edit Service Processes
CRMD_BUS2000117 Process Service Confirmations
CRMD_BUS2000120 Process Complaints
CRMD_BUS2000121 Maintain Sales Contracts
CRMD_BUS2000126 Maintain Activities
CRMD_BUS2000210 Maintain Product Service Letter
CRMD_BUS2000220 Maintain Partner Design Project
CRMD_BUS2000230 Maintain License Sales Contracts
CRMD_BUS2000231 Edit License Acquisition Contracts
CRMD_BUS2000232 Edit License Usage Confirmation
CRMD_CALL_LIST Generation of Call Lists
CRMD_CC Currency Change
CRMD_CCKPT_VIEWCUST customizing for role default views
CRMD_CD Display of Document Changes
CRMD_CODEX CRM Codex : Evaluation
CRMD_CSDR_PROJ_FAST Fast entry screen for Project
CRMD_DOWNLOAD_OM CRM Mobile Client Download (Online)
CRMD_DOWNLOAD_SB Download Sales Bundling Data to CDB
CRMD_EMAIL Maintain Mail Form
CRMD_EMAIL_LIST Display Marketing Bus. Activity List
CRMD_EMAIL_TEMPL Maintain Mail Template
CRMD_EMAIL_TEMPL1 Maintain Mail Form
CRMD_EVENT_CHECK EH: Callback for Trans.Type/Item Cat.
CRMD_EVENT_TRACE Evaluate Transaction Event Trace
CRMD_IIA_FAQ Maintain Frequently Asked Questions
CRMD_IIA_REPORT Generate Statistics Reports
CRMD_IM_MAIL_DELETE Delete Marketing Bus. Activity List
CRMD_INDEX_OM Index structure search OM
CRMD_IPM_AVAILABLE Analyze Rights Availability
CRMD_IPM_EVENT Date/Event Management
CRMD_IPM_HIER Maintain Hierarchical Attributes
CRMD_IPM_HIER_VIEW Maintain Hier.Attributes Views
CRMD_IPM_RD_PCUI_GEN IPM: Generate People Centric UI
CRMD_ISA_AUC_ATT Web Auction Attributes Setup
CRMD_ISA_EAUCTION Manage Web Auctions
CRMD_LEAD_FREE_SEL Lead Monitor: Free Selection
CRMD_LEAD_MONITOR Lead Monitor – Organizational View
CRMD_LEAS_ME_ACCRUAL Month-End Accruals
CRMD_MINIPROCESS Process a Transaction from MiniApp
CRMD_MKTDS Data Sources for Segment Builder
CRMD_MKTDS_WIZARD Data Source Wizard
CRMD_MKTLIST External List Management
CRMD_MKTLIST_MAP CRM Marketing : ELM Mapping Tool
CRMD_MKTPL_AL00 CRM: Allocation Application
CRMD_MKTPL_AL02 CRM: Allocation Rules
CRMD_MKTPL_AL03 CRM: Allocation Priorities
CRMD_MKTPL_AL04 CRM: Status of actual quantities
CRMD_MKTSEG Segment Builder
CRMD_MKTSEG_MGR Edit Master Groups/Samples
CRMD_MKT_EXP CRM Marketing: Export Target Group
CRMD_MKT_PROC Create Business Transactions
CRMD_MKT_TOOLS Marketing Tools
CRMD_MKT_TRANS CRM Marketing: Transport to Channels
CRMD_OPPORT_FAST My opportunities – fast change
CRMD_ORDER Transaction Processing
CRMD_ORDER_BP Business Partner Cockpit
CRMD_ORDER_LEAS_WOFF Write-Offs Mass Update Leasing
CRMD_ORDER_OBJLINK CRM Order via BUS Type and Number
CRMD_ORDER_PA Dialog Transaction CRMD_ORDER
CRMD_PROF_BP Business Partner Attributes
CRMD_PROF_CHAR Attribute Maintenance
CRMD_PROF_TEMPL Maintain Attribute Sets
CRMD_ROUTING_PROFILE Maintain Profiles and Attributes
CRMD_SDB_PRMN Maintain Info. Security Profile
CRMD_SDB_PROF Assign Profile to User
CRMD_SERV_CYCLE Define Service Cycles
CRMD_SERV_FORECAST Service Plan Forecasting
CRMD_SERV_SLA Availability and Response Times
CRMD_SRWWW Internet Transaction Service Request
CRMD_TG_IMPORT Import External Target Groups
CRMD_TM_CLDIST Call List Maintenance
CRMD_TM_CLMS Call List Management
CRMD_TRACE_EVAL Evaluation of API Trace
CRMD_TRACE_SET Activate/Deactivate API Trace
CRMD_TRACE_WATCHP Setting/Deletion of Watchpoint
CRMD_TRANSLATE Translate Mail Form
CRMD_TRANS_OM Translate Short Text for Org Units
CRMD_WEBREQ_CUST_OVW Customizing Evaluation: Web Requests
CRMD_WEBREQ_GEN_EXIT Generate start_exit Page
CRMD_WEBREQ_MONITOR Monitor for Web Requests
CRMD_WEBREQ_SIG_SHOW Display Digital Signature
CRMINIT First steps in middleware servers
CRMMDCS MAINT. DECISION TREE
CRMMDTREE The Overall Maintenance
CRMMNODE Transcation of maint. script node
CRMMNODET Transcation of maint. script node
CRMMONITOR Monitoring Middleware System
CRMMOPTION Maint. Tansaction to script option
CRMMSCRCHECK CHECK SCRIPT CONSISTENCY
CRMMTREE SCRPT TREE MAINTENCE
CRMMTREET SCRPT TREE MAINTENCE
CRMM_BPCURR Currency Changeover Business Partner
CRMM_BPD Business Partner Diagnosis
CRMM_BUPA_MAP Business partner data exchange
CRMM_BUPA_SEND Business Partner: Sending Directly
CRMM_CIC_APDISPLAY Display IC WinClient Profile
CRMM_CSDR_PROD_MAIN Des.Reg. product attributes maintain
CRMM_HR_QUALI_DEF Create CRM relevant HR qualis remote
CRMM_HR_QUALI_GET Create attribute f. HR qualification
CRMM_IC_MCM_CCADM Maintain System Settings
CRMM_IC_MCM_CCLNK Assign Profiles
CRMM_ISA_IUSER Internet User Management
CRMM_ISA_UA Internet Sales – User Administration
CRMM_MARKET_ATTRSET Maintain Marketing Set Type
CRMM_MKT_SAMPLE Samples for Segment Builder
CRMM_PPR Maintain Partner/Product Range
CRMM_PPR_CHNG_STATUS Change Partner/Product Range Status
CRMM_PPR_GUID_INFO Program CRM_PRP_GUID_INFO
CRMM_PPR_GUID_PPR Display all GUIDs for a PPR
CRMM_PPR_LISTFORBUPA Program CRM_PRP_LIST_PPRS_FOR_BUPA
CRMM_PPR_LISTFORPROD Program CRM_PRP_LIST_BUPAS_FOR_PROD
CRMM_PPR_RULES Execute Partner/Product Range Rules
CRMM_PPR_SETTYPES Maintain PPR Set Types
CRMM_PPR_STATUS_TEST Change PPR Status for internal use
CRMM_PPR_TOPN Maintain Top n Products
CRMM_PRPROD Assign Pricing Reference Materials
CRMM_ROUTING start business routing
CRMM_ROUTING_COMPARE Business Routing: Compare Scenario
CRMM_ROUT_AGENT Maintain agents for business routing
CRMM_ROUT_GRP Start routing group of b. routing
CRMM_ROUT_GRP_BP Group Members for Routing Groups
CRMM_ROUT_PROF Maintain profile
CRMM_ROUT_PROF_BP Assign Routing Grp Member to Profile
CRMM_ROUT_PROF_CHAR Maintain Attributes
CRMM_ROUT_PROF_TEMP Maintain Profile Template
CRMM_SEARCH Knowledge Search
CRMM_TERRMAN Territory Management
CRMM_TM_SCRIPT Interactive scripting editor
CRMORDERARC Residence Times Transaction Types
CRMSE62 Activate Exchanged Short Texts
CRMST62 Create Industry Short Texts
CRMS_IC_ACTION_DF IC WebClient Data Flow Maintenance
CRMS_IC_CHECK Check System Settings and Status
CRMS_IC_CROSS_SYS Transaction Launcher Logical Systems
CRMS_IC_SYSTEM_PROPS IC WebClient System Properties
CRMV_CANCPROCEDURE Maintain cancellation procedures
CRMV_CANCRULES Maintain cancellation rules
CRMV_CHECK_EVENTS Check Cust. Tab. for Event Handler
CRMV_CHECK_SSC Check Screen Control Data
CRMV_CODEX CRM Codex: Maint. of Check Tables
CRMV_EVENT Customizing Event Handler
CRMV_GENIL Customizing Object Model Generic IL
CRMV_IPM_EVENTS Define Events
CRMV_IPM_HIER_ATTR Customizing: Hierarchical Attributes
CRMV_IPM_HIER_VIEW Hierarchical Attributes Views
CRMV_PARTY Maintain cancelling party
CRMV_SSC Mntce: Scrn Cntrl Data – CRM Trans.
CRMXIF_C1 Assignment Site ID Interface Type
CRM_AC Check Appointment Rule for Data Exch
CRM_ACE_ADM CRM ACE Administrator Console
CRM_ACE_ADM_OLD Old CRM ACE Activation Tool GUI.
CRM_ACE_DEV CRM ACE Developer Tools
CRM_ACT_CUST_FIELDS Add customer fields to Activity Jrnl
CRM_ACT_IBU_INCL Maintain IBU specific fields
CRM_ACT_JR_TMPT Create/Change Activity Jrnl Template
CRM_ACT_JR_TMPT_TYPE Create/Change Activity JRNL TempType
CRM_ACT_STD_JRNL Create Standard Activity Journal

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 *–

==========================================================

BI TCODES ::::

RSA0: Content Settings Maintenance
RSA1: Modeling – Data Warehousing Workbench
RSA1OLD: BW Administrator Workbench (OLD)
RSA2: OLTP Metadata Repository
RSA3: Extractor Checker
RSA5: Install Business Content
RSA6: Maintain Datasource
RSA7: BW Delta Queue Monitor
RSA8: Data Source Repository
RSA9: Transfer Application Components
RSA10: Real time Test Interface Source System
RSA11: DW Workbench: Infoprovider Tree
RSA12: DW Workbench: Infosource Tree
RSA13: DW Workbench: Source System tree
RSA14: DW Workbench: Info Object Tree
RSA15: DW Workbench: Data Source Tree
RSA16: DW Workbench: Favourities Tree
RSA17: DW Worbench: General Search
RSAN_VERI: Analysis Process: Test Monitor
RSAN_WB_TST: Analysis Process: Display Data
RSANWB: Analysis Process Designer
RSAWB: DW Workbench (Last View)
UG_BW_RSA1: Admin Workbench:Modeling

=========================================

OSS1 – SAP Online Service System
OY19 – Compare Tables
SA38 – Execute a program.
SCU0 – Compare Tables
SE12 – Dictionary: Initial Screen – enter object name
SE13 – Access tables in ABAP/4 Dictionary.
SE14 – ABAP/4 Dictionary: Database Utility.
SE14 – Utilities for Dictionary Tables
SE17 – General Table Display
SE30 – ABAP/4 Runtime Analysis
SE30 – Run Time Analysis (press Tips and Tricks button for good stuff)
SE30 – ABAP/4 Runtime Analysis: Initial Screen.
SE32 – ABAP/4 Text Element Maintenance
SE35 – ABAP/4 Dialog Modules
SE36 – ABAP/4: Logical Databases
SE37 – ABAP/4 Function Library.
SE37 – ABAP/4 Function Modules
SE38 – ABAP/4 Editor.
SE38 – ABAP Editor
SE38 – ABAP/4 Program Development
SE39 – Splitscreen Editor: Program Compare (Interesting tool to compare the programs of different system)
SE41 – Menu Painter
SE43 – Maintain Area Menu
SE51 – Screen Painter
SE51 – Screen Painter: Initial Screen.
SE54 – Generate View Maintenance Module
SE61 – R/3 Documentation
SE62 – Industry utilities
SE63 – Translate Short/Long Text.
SE63 – Translation
SE64 – Terminology
SE65 – R/3 documents. Short text statistics SE66 R/3 Documentation Statistics (Test!)
SE68 – Translation Administration
SE71 – SAPscript layout set
SE71 – SAPscript Layouts Create/Change
SE72 – SAPscript styles
SE73 – SAPscript font maintenance (revised)
SE74 – SAPscript format conversion
SE75 – SAPscript Settings
SE76 – SAPscript Translation Layout Sets
SE77 – SAPscript Translation Styles
SE80 – ABAP/4 Development Workbench
SE80 – Repository Browser: Initial Screen.
SE81 – SAP Application Hierarchy
SE82 – Customer Application Hierarchy
SE84 – ABAP/4 Repository Information System
SE85 – ABAP/4 Dictionary Information System
SE86 – ABAP/4 Repository Information System
SE92 – Maintain system log messages
SE93 – Maintain Transaction Codes
SE93 – Maintain Transaction
CRMBS02 Maintain Status Profiles
CRMBS03 Display Status Profiles
CRMBS42 Maintain Status Selection Profiles
CRMBS43 Display Status Selection Profile
CRMBS52 Maintain Authorization Keys
CRMBS53 Display Authoriztaion Key
CRMBWST Genertd DataSource for BW Status Obj
CRMBWTARGETS Release Data Target for BW Upload
CRMBW_CIC_ATTRIBUTES BW Key Figures for CRM
CRMCACTARC Archiving Control CRM Activity
CRMCPRMSG Configure Customer-Specific Messages
CRMCUSTOM Monitoring Middleware System
CRMC_ACTION_CONF Configure Action Profile
CRMC_ACTION_DEF Define Action Profile
CRMC_ACTION_JOB Action Monitor
CRMC_ACTION_PRINT Configure action profile (old)
CRMC_ACTION_WIZARD Action for Definition via Wizard
CRMC_ACTIVITY_H Customizing Maintenance Activity
CRMC_ACT_CATEGORY Cust. Maint. Activity: Category
CRMC_ACT_OBJ Cust. Maintenance Activity: Goal
CRMC_ACT_SURVEY Cust. Maint. Activity: Questionnaire
CRMC_AM_JCLASS Alert Modeler Java Class
CRMC_ATP_PROFILE Customizing Maintenance: APO Profile
CRMC_BLUEPRINT Maintenance for BSP Blueprint
CRMC_BLUEPRINT_C IMG Call
CRMC_BL_CHECK Check Blueprint Tables
CRMC_BL_COPY_QUERIES Copy Report Delivery Queries
CRMC_BP_CCKPT_PB Cust.Maint. BP Cockpit: Pushbuttons
CRMC_BSP_ANALYZE Starts CRMC_BSP_FRAME: Analysis Mode
CRMC_BSP_WD_MSGDEFH Message Default Handler Assignment
CRMC_BUAG_NUMBERS Number Range Maintenance: BUAG
CRMC_BUPA_CONSUM Maintain reference business partner
CRMC_BUPA_INITIAL Table Maintenance CRMC_BUT_INITIAL
CRMC_BUS_SUBOB_C Assign. BUS – Allowed Appl. Areas
CRMC_BUS_SUBOB_I Assignment BUS-allowed app.area item
CRMC_BUT_CALL_FU Establishing FMs for Data Exchng BP
CRMC_CAI_COCKPIT CAI – Test Cockpit
CRMC_CATAGORY_WP Cust. Maintenance Application Area
CRMC_CATALOG_DEFINE Create Catalog
CRMC_CATALOG_OVV Catalog Overview
CRMC_CIC_AB_LSYS_ASS Action Box: Assign logical systems
CRMC_CIC_AB_LSYS_CRE Action Box: Create logical systems
CRMC_CIC_AB_LSYS_RFC Action Box: Assign LogSYS to RfcDest
CRMC_CIC_AB_NAV Action Box Navigation Area
CRMC_CIC_AB_WEBGUI Define ITS for WebGui Mode
CRMC_CIC_ACT0 Transaction component profile
CRMC_CIC_AM_LANG Lang. dependent text – Alert Modeler
CRMC_CIC_AM_META Define Customer-Specific Meta Model
CRMC_CIC_AM_PROFILE Maintan Alert Modeler Editor Profile
CRMC_CIC_BP_PROFILE Maintain Profile Templates
CRMC_CIC_BROAD broadcasting profile assign
CRMC_CIC_COMP_ACTION Component Actions (for locator, BDD)
CRMC_CIC_EXT_INB_ACT Activate Agent Inbox
CRMC_CIC_FW_MAINTAIN Maintain Framework ID and Parameters
CRMC_CIC_MAIL_ADDR Addresses for Agent Inbox
CRMC_CIC_MAIL_E_RESP Maintain Rules for E-Mail
CRMC_CIC_MAIL_F_RESP Maintain Rules for Fax
CRMC_CIC_MAIL_GLOBAL Define Global Settings
CRMC_CIC_MAIL_IBXPRF Define Inbox Settings
CRMC_CIC_MAIL_TASKS Task Classification
CRMC_CIC_MAIL_WF Assign Agent for E-Mail Handling
CRMC_CIC_RESTART Set Time & Memory for Restart
CRMC_CIC_SEARCH_CNTR Maintain Search Components
CRMC_CIC_SEARCH_RULE Maintain Search Attributes
CRMC_CIC_TITLE_TEXTS Maintain Window Title
CRMC_CIC_WSP0 Workspace Definition
CRMC_CIC_WSP1 Inbox Profiles
CRMC_CIC_WSP2 E-Mail Editor Profiles
CRMC_CIC_WSP3 Default Workspaces Profile
CRMC_CIC_WSP_EDITOR2 Editor Profiles
CRMC_CLM_ACTION_CONF Configure Action Profile
CRMC_CLM_ACTION_DEF Define Action Profile
CRMC_CLM_ACTION_WIZ Action for Definition via Wizard
CRMC_CLM_BTSYNC Business transaction synchronization
CRMC_CLM_CALLATTRS Call Attributes
CRMC_CLM_CALLRESULTS Call results
CRMC_CLM_CLDP Call list determination procedures
CRMC_CLM_CLTYPES Call list types
CRMC_CLM_CMPGPM Campaign priority mapping
CRMC_CLM_CTMAP Calling Times Mapping
CRMC_CLM_ORCC Order control components
CRMC_CLM_RSCHVL Rescheduling validation procedures
CRMC_CLM_SORCC Standard order control profiles
CRMC_CLM_STMAP Call State Mapping
CRMC_CPRICPROC Definition of Cust. Determ. Proced.
CRMC_CP_BADI_F Copying BADI – Text Maintenance
CRMC_CSDR_ADD_CUST Design Registration Project
CRMC_CSDR_APPL_CUST Design Registration Project
CRMC_CUST_APPLLAYOUT ViewCluster Mtnce CRMV_APPLLAYOUT
CRMC_DPRICPROC Definition of Document Procedures
CRMC_EXEC_BAB CRM: Start business applic. builder
CRMC_EXEC_BAB_C CRM: Start OAS in customer mode
CRMC_EXEC_BAB_D CRM: OAS in customer design mode
CRMC_EXEC_BAB_S CRM: Start OAS in SAP mode
CRMC_IC_ACPROF Maintain Activity Clipboard profiles
CRMC_IC_ACTIONPROF Maintain Actions profiles
CRMC_IC_ACTIONWZ Start Action Box Wizard
CRMC_IC_ALERTMODELER Alert Modeler customizing
CRMC_IC_AMWZ alert wizard
CRMC_IC_AM_PHS Maintain Alert Modeler Placeholder
CRMC_IC_AM_PRM Alert Modeler Input Parameters
CRMC_IC_AUI_FWD Define Forwards for Inbox Items
CRMC_IC_AUI_GEN Agent Univ. Inbox – CRMV_IC_AUI_GEN
CRMC_IC_AUI_MAINCAT Define Main Categories
CRMC_IC_AUI_MAP_PRI Map Native to Inbox Priorities
CRMC_IC_AUI_MAP_STA Map Native to Inbox Status
CRMC_IC_AUI_PARTNER Agents Universal Inbox – Partners
CRMC_IC_AUI_PROFILE Define and Assign Inbox Profiles
CRMC_IC_AUI_QUICKS Define Quick Searches
CRMC_IC_AUI_TIMEPER Define Time Periods
CRMC_IC_BDCCONTEXT Specify alternative BDC context
CRMC_IC_BPPROF Define Profiles for Customer Identif
CRMC_IC_BTPFAS Assignment of Partner Functions
CRMC_IC_BTPROF Profile for Business Transaction
CRMC_IC_CHTPROF Maintain profiles for Chat
CRMC_IC_CLMPROF Call List Profile Maintenance
CRMC_IC_CM Content Management Customizing
CRMC_IC_EMLPROF Maintain profiles for Email
CRMC_IC_EVENTING Event management customizing
CRMC_IC_EVENTS IC WebClient Events
CRMC_IC_MAIL_E_RESP Maintain Rules for E-Mail
CRMC_IC_MAIL_F_RESP Maintain Rules for Fax
CRMC_IC_MAIL_WF Assign Agent for E-Mail Handling
CRMC_IC_MAIN Main Component Customizing
CRMC_IC_MCM_CCPRO Define Com Mgmt Software Profiles
CRMC_IC_MKTPROF Campaign Profile Maintenance
CRMC_IC_NAVBARWZ CRMC_IC_NAVBARWZ
CRMC_IC_NAVBAR_PERM Nav Bar Permanent Profile
CRMC_IC_NAVBAR_PERS Nav Bar Personalizing Profile Defaul
CRMC_IC_RTFRAMEWORK IC WebClient Runtime Framework
CRMC_IC_SCRIPT Maintain Interactive Scripting Prof
CRMC_IC_SPH_AGENTPRO Maintain Profiles for SPH Agent
CRMC_IC_TLBPROF Maintain profiles for Toolbar
CRMC_IC_TRACE Activate activity tracing for agent
CRMC_IC_WCTPROF Maintain profiles for Web Context
CRMC_IC_XML_TEMPLATE XML template maintenance
CRMC_IIA_KERNEL IIA: Customizing for Learning Engine
CRMC_IIA_REPORT IIA: Customizing for Learning Engine
CRMC_IOBJ_FIN_STATE Change Status of Individual Objects
CRMC_IPMO_BWSELOPT BW Select Optns: IPMO Sett.DataColl.
CRMC_IPMO_SRVUSE IPMO: Usage from Feature
CRMC_IPM_CLRRUL Clearing Control – Diagram Form
CRMC_ISA_IUSER Internet User Settings
CRMC_ITEM_CAT_GR Item Category Usage
CRMC_ITEM_MA Customizing Maintenance: Item Cats
CRMC_IT_ASSIGN Customizing Maint.: Item Cat. Dtrmtn
CRMC_IT_COPY_IF Copy: Item category determination
CRMC_IT_COPY_MA Copy Item Categories
CRMC_IT_TYPE_US Item Category Usage
CRMC_LAYOUTC_GENE Generation of Customer Table Layout
CRMC_LAYOUT_GENERATE Generation of Layout Table
CRMC_LOGS Maintenance of message classes
CRMC_MAP Customer Maintenance Mapping
CRMC_MKTCA_WF_CUST Workflows Campaign Automation
CRMC_MKTLIST_WF_CUST Workflows External List Management
CRMC_MKTPL_ACT_CONF Configure Action Profile
CRMC_MKTPL_ACT_DEF Define Action Profile
CRMC_MKTPL_ACT_WIZ Action for Definition via Wizard
CRMC_MKTPL_FAW_CPG Field Selection Campaign
CRMC_MKTPL_FAW_CPT Field Selection Campaign Element
CRMC_MKTPL_FAW_DLM Field Selection Deal
CRMC_MKTPL_FAW_MPL Field Selection Marketing Plan
CRMC_MKTPL_FAW_MPT Field Select. Marketing Plan Element
CRMC_MKTPL_FAW_TPM Field Selection Trade Promotion
CRMC_MKTPL_FAW_TPT Field Selection Trade Element
CRMC_MKTPL_MAPPING Customizing Field Assignment MS Proj
CRMC_MKTPL_RT_AC Maintaning residency time
CRMC_MKTPL_SETTYPE Marketing Planning: Process Set Type
CRMC_MKTTG_CUSTMSG Configure Customer-Specific Messages
CRMC_MKTTG_DTY CRM Marketing: View Display Type
CRMC_MKTTG_MGR_H CRM Marketing: Report Name
CRMC_MKTTG_OPT_H CRM Marketing: Sample Optimization
CRMC_MKTTG_RUL CRM MKT: Split/Reduce Rules for TGs
CRMC_MKTTG_SA_DP Assign Attribute Type to Display
CRMC_MKTTG_SA_TP CRM Marketing: View Attribute Types
CRMC_MKTTG_TYP_H CRM Marketing: Target Group Type…
CRMC_MKT_PARAMBW Customizing for BW Parameter ID
CRMC_MSGC Customizing CRM message attribute
CRMC_MSGS CRM message attribute maintenance
CRMC_NR_CONF Number Range Maint.: CRM_CONF
CRMC_NR_MPK_MPOINT Number Range Maint.: Counter
CRMC_NR_MPK_READING Number Range Maint.: Counter Reading
CRMC_NR_RA_ACTIVITY Number Range Maintenance: CRM_ACTIVI
CRMC_NR_RA_CONFIRM Number Range Maintenance:CRM_confirm
CRMC_NR_RA_FANF Number Range Maintenance: CRM_SERVIC
CRMC_NR_RA_LEADS Number range maintenance: CRM_LEAD
CRMC_NR_RA_OPPORT Number Range Maintenance: CRM_OPPORT
CRMC_NR_RA_SALES Number Range Maintenance: CRM_SALES
CRMC_NR_RA_SERVICE Number Range Maintenance: CRM_SERVIC
CRMC_NR_RA_SRV_CONF Number range maintenance: CRM_SRV_CF
CRMC_NR_RA_SUR Number range maintenance: CRM_SUR
CRMC_NR_SRV_CONF
CRMC_OBJECTS Subobjects of CRM Document
CRMC_OBJECT_ASSI Assignment Appl. Area – CRM Object
CRMC_OPPORT_H Customizing Maintenance: Opportunity
CRMC_ORGPROF Maintenance of Org. Data Profile
CRMC_PARTNER_AS Maintenance of Access Sequences
CRMC_PARTNER_FCT Maintenance of Partner Functions
CRMC_PARTNER_MAP2CRM Mapping Partner Functions into CRM
CRMC_PARTNER_MAP2R3 Mapping Partner Functions into R/3
CRMC_PARTNER_PDP Maintenance of Partner Procedures
CRMC_PARTNER_PFT Maintenance of Partner Function Typ
CRMC_PFTREL BP PartnerFunctionCat.for Rel. Cat.
CRMC_PLSRV_REL Product Proposal
CRMC_PPR_CTRL Maintain Global PPR Settings
CRMC_PPR_DEFINE_APPL Define Applications using PPRs
CRMC_PPR_DEFINE_OCHK Transaction Types Rel. for PPR Check
CRMC_PPR_DEFINE_PARA Customer Maintenance Rule Parameter
CRMC_PPR_DEFINE_RULE Customer Maintenance Rule Definition
CRMC_PPR_DEFINE_SRTB Define Sort Routines for BPartners
CRMC_PPR_DEFINE_SRTP Define Sort Routines for Products
CRMC_PPR_DEFINE_TYPE Customer Maintenance PPR Types
CRMC_PRCPROC_DET Cust. Maint. Pr. type determination
CRMC_PRCTYPE_DET Cust. Maint. Pric. Proced. Maint.
CRMC_PROCESS_MA Customizing Maint.:Transaction Types
CRMC_PROD_FIN_COPY Copy Financing Product
CRMC_PROD_FIN_HIER Create Financing Hierarchy
CRMC_PRPS BP Function Proposal Procedure
CRMC_PRP_IL_MAP PPR-Customizing: Maintenance Mapping
CRMC_PRP_OBJECTS PPR-Customizing: Maintenance Mapping
CRMC_PR_COPY_MA Copy Tranasction Types
CRMC_R3_ORG_GENERATE R/3 organizational data generation
CRMC_SALES_ITEM Sales Customizing at Item Level
CRMC_SERVICE_H Customizing Maintenance: Service
CRMC_SERVICE_IPT Maintenance of Internet Trans. Types
CRMC_SLS_ITM_BIL Maint. Item Types & Billing Relev.
CRMC_SRVCATIFC Catalog Integration
CRMC_SUBJPROFILE_H Define Subject Profile
CRMC_SUBOB_CAT Application Areas
CRMC_SUBOB_CAT_I Item – Business Object Types
CRMC_SWITCH_ORGMODEL Convert Org. Model
CRMC_TAX_CUST_UPD Maintain Condition Function in Cond.
CRMC_TAX_GROUP Tax Group Customizing
CRMC_TAX_MAP Tax Group Customizing
CRMC_TAX_SCHEMA Maintain tax procedures
CRMC_TIMEPROF CRM date profile
CRMC_TM_CLPROF0 Call list profile maintenance
CRMC_TM_NSM Namespace manager
CRMC_TM_PSM Persistent storage manager
CRMC_WEBREQ Request Categories for Web Requests
CRMC_WEBREQ_BEGR Authorization Groups for Views
CRMC_WEBREQ_BEGR_DIS Authorization Groups for Views
CRMC_XMLEDITOR Start XML Editor for Spice
CRMD_AR_MAINTAIN Process Product Association Rule
CRMD_BILLING Transfer Invoice Data to R/3
CRMD_BILL_REV Cancel Billing Document
CRMD_BUS2000107 Process Framework Agreements
CRMD_BUS2000108 Maintain Leads
CRMD_BUS2000111 Maintain Opportunities
CRMD_BUS2000112 Maintain Service Contracts
CRMD_BUS2000113 Process Purchase Contracts
CRMD_BUS2000114 Maintain Sales Contracts
CRMD_BUS2000115 Maintain Sales Transactions
CRMD_BUS2000116 Edit Service Processes
CRMD_BUS2000117 Process Service Confirmations
CRMD_BUS2000120 Process Complaints
CRMD_BUS2000121 Maintain Sales Contracts
CRMD_BUS2000126 Maintain Activities
CRMD_BUS2000210 Maintain Product Service Letter
CRMD_BUS2000220 Maintain Partner Design Project
CRMD_BUS2000230 Maintain License Sales Contracts
CRMD_BUS2000231 Edit License Acquisition Contracts
CRMD_BUS2000232 Edit License Usage Confirmation
CRMD_CALL_LIST Generation of Call Lists
CRMD_CC Currency Change
CRMD_CCKPT_VIEWCUST customizing for role default views
CRMD_CD Display of Document Changes
CRMD_CODEX CRM Codex : Evaluation
CRMD_CSDR_PROJ_FAST Fast entry screen for Project
CRMD_DOWNLOAD_OM CRM Mobile Client Download (Online)
CRMD_DOWNLOAD_SB Download Sales Bundling Data to CDB
CRMD_EMAIL Maintain Mail Form
CRMD_EMAIL_LIST Display Marketing Bus. Activity List
CRMD_EMAIL_TEMPL Maintain Mail Template
CRMD_EMAIL_TEMPL1 Maintain Mail Form
CRMD_EVENT_CHECK EH:Callback for Trans.Type/Item Cat.
CRMD_EVENT_TRACE Evaluate Transaction Event Trace
CRMD_IIA_FAQ Maintain Frequently Asked Questions
CRMD_IIA_REPORT Generate Statistics Reports
CRMD_IM_MAIL_DELETE Delete Marketing Bus. Activity List
CRMD_INDEX_OM Index structure search OM
CRMD_IPM_AVAILABLE Analyze Rights Availability
CRMD_IPM_EVENT Date/Event Management
CRMD_IPM_HIER Maintain Hierarchical Attributes
CRMD_IPM_HIER_VIEW Maintain Hier.Attributes Views
CRMD_IPM_RD_PCUI_GEN IPM: Generate People Centric UI
CRMD_ISA_AUC_ATT Web Auction Attributes Setup
CRMD_ISA_EAUCTION Manage Web Auctions
CRMD_LEAD_FREE_SEL Lead Monitor: Free Selection
CRMD_LEAD_MONITOR Lead Monitor – Organizational View
CRMD_LEAS_ME_ACCRUAL Month-End Accruals
CRMD_MINIPROCESS Process a Transaction from MiniApp
CRMD_MKTDS Data Sources for Segment Builder
CRMD_MKTDS_WIZARD Data Source Wizard
CRMD_MKTLIST External List Management
CRMD_MKTLIST_MAP CRM Marketing : ELM Mapping Tool
CRMD_MKTPL_AL00 CRM: Allocation Application
CRMD_MKTPL_AL02 CRM: Allocation Rules
CRMD_MKTPL_AL03 CRM: Allocation Priorities
CRMD_MKTPL_AL04 CRM: Status of actual quantities
CRMD_MKTSEG Segment Builder
CRMD_MKTSEG_MGR Edit Master Groups/Samples
CRMD_MKT_EXP CRM Marketing: Export Target Group
CRMD_MKT_PROC Create Business Transactions
CRMD_MKT_TOOLS Marketing Tools
CRMD_MKT_TRANS CRM Marketing: Transport to Channels
CRMD_OPPORT_FAST My opportunities – fast change
CRMD_ORDER Transaction Processing
CRMD_ORDER_BP Business Partner Cockpit
CRMD_ORDER_LEAS_WOFF Write-Offs Mass Update Leasing
CRMD_ORDER_OBJLINK CRM Order via BUS Type and Number
CRMD_ORDER_PA Dialog Transaction CRMD_ORDER
CRMD_PROF_BP Business Partner Attributes
CRMD_PROF_CHAR Attribute Maintenance
CRMD_PROF_TEMPL Maintain Attribute Sets
CRMD_ROUTING_PROFILE Maintain Profiles and Attributes
CRMD_SDB_PRMN Maintain Info. Security Profile
CRMD_SDB_PROF Assign Profile to User
CRMD_SERV_CYCLE Define Service Cycles
CRMD_SERV_FORECAST Service Plan Forecasting
CRMD_SERV_SLA Availability and Response Times
CRMD_SRWWW Internet Transaction Service Request
CRMD_TG_IMPORT Import External Target Groups
CRMD_TM_CLDIST Call List Maintenance
CRMD_TM_CLMS Call List Management
CRMD_TRACE_EVAL Evaluation of API Trace
CRMD_TRACE_SET Activate/Deactivate API Trace
CRMD_TRACE_WATCHP Setting/Deletion of Watchpoint
CRMD_TRANSLATE Translate Mail Form
CRMD_TRANS_OM Translate Short Text for Org Units
CRMD_WEBREQ_CUST_OVW Customizing Evaluation: Web Requests
CRMD_WEBREQ_GEN_EXIT Generate start_exit Page
CRMD_WEBREQ_MONITOR Monitor for Web Requests
CRMD_WEBREQ_SIG_SHOW Display Digital Signature
CRMINIT First steps in middleware servers
CRMMDCS MAINT. DECISION TREE
CRMMDTREE The Overall Maintenance
CRMMNODE Transcation of maint. script node
CRMMNODET Transcation of maint. script node
CRMMONITOR Monitoring Middleware System
CRMMOPTION Maint. Tansaction to script option
CRMMSCRCHECK CHECK SCRIPT CONSISTENCY
CRMMTREE SCRPT TREE MAINTENCE
CRMMTREET SCRPT TREE MAINTENCE
CRMM_BPCURR Currency Changeover Business Partner
CRMM_BPD Business Partner Diagnosis
CRMM_BUPA_MAP Business partner data exchange
CRMM_BUPA_SEND Business Partner: Sending Directly
CRMM_CIC_APDISPLAY Display IC WinClient Profile
CRMM_CSDR_PROD_MAIN Des.Reg. product attributes maintain
CRMM_HR_QUALI_DEF Create CRM relevant HR qualis remote
CRMM_HR_QUALI_GET Create attribute f. HR qualification
CRMM_IC_MCM_CCADM Maintain System Settings
CRMM_IC_MCM_CCLNK Assign Profiles
CRMM_ISA_IUSER Internet User Management
CRMM_ISA_UA Internet Sales – User Administration
CRMM_MARKET_ATTRSET Maintain Marketing Set Type
CRMM_MKT_SAMPLE Samples for Segment Builder
CRMM_PPR Maintain Partner/Product Range
CRMM_PPR_CHNG_STATUS Change Partner/Product Range Status
CRMM_PPR_GUID_INFO Program CRM_PRP_GUID_INFO
CRMM_PPR_GUID_PPR Display all GUIDs for a PPR
CRMM_PPR_LISTFORBUPA Program CRM_PRP_LIST_PPRS_FOR_BUPA
CRMM_PPR_LISTFORPROD Program CRM_PRP_LIST_BUPAS_FOR_PROD
CRMM_PPR_RULES Execute Partner/Product Range Rules
CRMM_PPR_SETTYPES Maintain PPR Set Types
CRMM_PPR_STATUS_TEST Change PPR Status for internal use
CRMM_PPR_TOPN Maintain Top n Products
CRMM_PRPROD Assign Pricing Reference Materials
CRMM_ROUTING start business routing
CRMM_ROUTING_COMPARE Business Routing: Compare Scenario
CRMM_ROUT_AGENT Maintain agents for business routing
CRMM_ROUT_GRP Start routing group of b. routing
CRMM_ROUT_GRP_BP Group Members for Routing Groups
CRMM_ROUT_PROF Maintain profile
CRMM_ROUT_PROF_BP Assign Routing Grp Member to Profile
CRMM_ROUT_PROF_CHAR Maintain Attributes
CRMM_ROUT_PROF_TEMP Maintain Profile Template
CRMM_SEARCH Knowledge Search
CRMM_TERRMAN Territory Management
CRMM_TM_SCRIPT Interactive scripting editor
CRMORDERARC Residence Times Transaction Types
CRMSE62 Activate Exchanged Short Texts
CRMST62 Create Industry Short Texts
CRMS_IC_ACTION_DF IC WebClient Data Flow Maintenance
CRMS_IC_CHECK Check System Settings and Status
CRMS_IC_CROSS_SYS Transaction Launcher Logical Systems
CRMS_IC_SYSTEM_PROPS IC WebClient System Properties
CRMV_CANCPROCEDURE Maintain cancellation procedures
CRMV_CANCRULES Maintain cancellation rules
CRMV_CHECK_EVENTS Check Cust. Tab. for Event Handler
CRMV_CHECK_SSC Check Screen Control Data
CRMV_CODEX CRM Codex: Maint. of Check Tables
CRMV_EVENT Customizing Event Handler
CRMV_GENIL Customizing Object Model Generic IL
CRMV_IPM_EVENTS Define Events
CRMV_IPM_HIER_ATTR Customizing: Hierarchical Attributes
CRMV_IPM_HIER_VIEW Hierarchical Attributes Views
CRMV_PARTY Maintain cancelling party
CRMV_SSC Mntce: Scrn Cntrl Data – CRM Trans.
CRMXIF_C1 Assignment Site ID Interface Type
CRM_AC Check Appointment Rule for Data Exch
CRM_ACE_ADM CRM ACE Administrator Console
CRM_ACE_ADM_OLD Old CRM ACE Activation Tool GUI.
CRM_ACE_DEV CRM ACE Developer Tools
CRM_ACT_CUST_FIELDS Add customer fields to Activity Jrnl
CRM_ACT_IBU_INCL Maintain IBU specific fields
CRM_ACT_JR_TMPT Create/Change Activity Jrnl Template
CRM_ACT_JR_TMPT_TYPE Create/Change Activity JRNL TempType
CRM_ACT_STD_JRNL Create Standard Activity Journal

TABLES:

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, 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.

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_ACTIVITY_H Activity Header table
CRMD_ACTIVITY_I Activity Reporting: Activity Line Item Extension
CRMD_TM_ACTIVITY Activity reference
CRMD_LEAD_H Lead Header table
CRMD_OPPORT_H Opportunity Header table

=================================================

Some of the tables that are used in Marketing and Campaign Management are:
CRMD_IM_ML_HEAD Personalized Mails: Contact Tracking Outbound Table
CRMD_IM_ML_ITEM Personalized Mails: Contact Tracking Outbound Table (Item)
CRMD_IM_ITEM_L Personalized Mails: URL Extensions for CRMD_IM_ML_ITEM
CRMD_IM_LINK Personalized Mails: ‘Tracking Enabled URLs’ with Attributes
CRMD_IM_LINK_T Personalized Mails: Text Table for CRMD_IM_LINK
CRMC_IM_CAT Personalized Mails: Categories for URLs
CRMC_IM_CAT_T Personalized Mails: Text Table for CRMC_IM_CAT
CRMD_BOUNCE_ATTR
Delivery Info:
SOOD SAPoffice: Object definition
SOST SAPoffice: Status log table

===================================================

here r some tables which r most used
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_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_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
CRMD_ORDERADM_H = Document Header Table
CRMD_ORDERADM_I = Document Line item Table

==========================================

but still you can use these t codes to chweck the system ststues for the transactions
BSVW,BSVZ

Posted in 6-TABLES / TCODES | Leave a Comment »

Org Data Determination

Posted by crmQ on August 4, 2008

In R/3 SD, during Order entry, we have always wanted users to determine or select Sales Org/Dist Channel/division that is appropriate.

CRM can relieve the users of having to determine the “Org Structure” and determine that automatically. You essentially store some canned rules for organization determination and let the system run these rules to determine the the appropriate Org Structure in transactions.

Two types of rules. Generic and Specific.

In Generic Rule, called also a “organization Model” rule, you say (as an example) ” when I enter the customer, look at the country and region attributes of customer. Then with these values search organization attributes and determine the right Org Units….and then update the transaction org values accordingly”. The good thing about generic rule is, it does not require too much ‘maintenance’ unless the Logic for determination of the org structure itself is being overhauled. One disadvantage of using the generic rule is that, it does not account for typical Business Exceptions like ” though this pericular customer belongs to Belgium, John has been hanling this account from beginning and he would like it to be treated differently because the CEO of this……etc…”. Especially if there are more exceptions than generic rules, you go to Specific Rule.

Specific Rule also called ‘Responsibilities’. This is more or less ‘Hard Coding’ the responsibilty matrix and making the system look up this matrix to determine the appropriate Org Structure in transactions. The clear disadvantage is the frequent maintenance of this matrix when there are changes.

It is important to check in the Attributes section of the Organization Definition, you check the box for “Obj Permitted for Org Determination”. If this is not checked, even if the rules meet the requirements, these Org structures will not be fetched

Create these OrgDeterminationProfiles( ie Rules). Assign them to transaction types.

SPRO>CRM>MasterData>OrganizationManagement>OrgModel>Tools— Use this to check consistency. To check which determination Rule/what are the containers in the rule/what is the profile etcc.. provide transaction type and you can see how the transaction runs the Org Determination Check.

Transaction /nCRM_ORG_PROUVE

While creating or changing the transaction, go to ‘Organization’ tab and look for details to find out what rule and how the organization was determined.

Posted in 1-ORG MANAGEMENT | Leave a Comment »

SAP Holds Top Rankings in Worldwide Market Share for SAP(R) Business Suite Applications

Posted by crmQ on July 30, 2008

SAP AG today announced that it has been named the worldwide market share leader based on total software revenue for business solutions in the customer relationship management enterprise resource planning and supply chain management markets, according to 2007 market share reports published by renowned independent research firm Gartner, Inc.

The following is an overview of the Gartner rankings, measured by total software revenues for 2007:

– SAP leads the CRM market, with a total market share of 25.35 percent, placing nine percentage points over its closest competitor.(1)

– SAP leads the SCM market, with a total market share of 22.4 percent, a sizeable lead over second-ranked competitor at 16 percent.(2)

– SAP leads the ERP market, with a total market share of 27.5 percent, far surpassing the second-ranked competitor at 13.9 percent.(3)

“We believe SAP’s top leadership position throughout the Gartner Market Share reports is a shining confirmation of the value and continued trust companies place in the SAP Business Suite family of applications,” said Jim Hagemann Snabe, member of the Executive Board, SAP AG. “Customers around the world consistently turn to the unmatched end-to-end integration capabilities of the SAP Business Suite to help solve complex business challenges while driving top and bottom line growth.”

Within the ERP market, SAP is also further noted as the leader in several relevant categories, including financials and human capital management solutions. SAP also surpassed a major ERP milestone recently (see July 1, 2008 press release, titled “SAP Surpasses Milestone in Product Strategy as 10,000 Customers Run Latest ERP Release”), whereby SAP ERP 6.0 has become the fastest adopted SAP ERP release in the company’s history. Combined with the powerful functionality found in the most current versions of the SAP Business Suite family of applications is providing tangible results for customers on a global scale.

“When we realized our SAP package would literally run our business, we felt we had to place our bet with the most proven solution available,” said Don Whittington, vice president and chief information officer, Florida Crystals. “Our bet with SAP has paid off handsomely. The flexibility and scalability of the software has enabled us to realize our growth objectives through acquisition and support rapidly changing business requirements. This adaptability also enables continuous improvement of business processes at Florida Crystals on a global basis.”

Source – http://www.foxbusiness.com/story/markets/industries/technology/sap-holds-rankings-worldwide-market-share-sapr-business-suite-applications/

Posted in 7-SAP NEWS | Leave a Comment »

SAP Customers Worldwide Tout Early Success With Latest CRM Offering

Posted by crmQ on July 30, 2008

SAP AG today announced that companies across diverse industries have successfully deployed the new customer relationship management application from SAP in record time to deliver superior value to their customers. By selecting the SAP CRM application over competitive CRM offerings, industry leaders, including eBay, Royal Philips Electronics, Eastman Chemical, Home Shopping Europe, Apotex, StatoilHydro, Bank fuer Sozialwirtschaft and Wuerth Group, are able to leverage insights across the enterprise in order to engage with customers in exciting and innovative ways.

Further showing SAP’s momentum, the leading independent research firm Gartner Inc. has once again ranked SAP as the No. 1 CRM vendor worldwide. According to Gartner, SAP leads the CRM market with a total market share of 25.35 percent based on total software revenue, placing it nine percentage points over its closest competitor.(1)

SAP CRM Enables Interaction With eBay’s Top Customers in Europe

eBay has a global presence in 39 markets and approximately 83.9 million active users worldwide; a great deal of those trade on eBay’s European marketplaces. The quality of its business relationships to key customers — PowerSellers, top sellers and top buyers — is critical to the success of the company. In 2007, eBay decided to implement a new CRM solution to increase the satisfaction of these key accounts, as well as to drive the overall productivity of its business. eBay selected SAP CRM to support its customer interaction center for European markets. The company implemented the interaction center and the business intelligence functionalities of the application. The clear CRM roadmap and SAP’s commitment to CRM led eBay to select SAP CRM. The first European eBay country organization went live in May 2008, the last one will follow in August.

Royal Philips Electronics Excites Sales Users

Royal Philips Electronics (Sector Consumer Lifestyle), leader in healthcare, lighting and consumer lifestyle products, went live on SAP CRM 2007 with a team of sales force automation users in Canada.

“Our sales reps rave about the improved ease-of-use of the SAP CRM 2007 application, which was adopted faster than ever,” said Geert van de Ven, program manager, Royal Philips Electronics. “Due to the successful implementation, we plan to expand our rollout of SAP CRM 2007 to additional users later this year.”

Eastman Chemical Captures Comprehensive Customer Interactions

As a major producer of chemicals, fibers and plastics, Eastman Chemical requires a high degree of visibility into customer interactions in order to maintain customer satisfaction levels and support growth strategies. Eastman deployed SAP CRM to capture a more robust view of these customer interactions and provide improved support for sales.

“Our emphasis is on service and insight into customer relationships,” said Bob Strickler, technical lead, Interaction Center project, Eastman Chemical. “The interaction center functionality of SAP CRM will quickly and easily enable us to capture interactions and create the 360-degree view of the customer for all account team members. Thanks to the flexibility and scalability of SAP CRM, we plan to complete the deployment to all our CSRs in North America by the end of this year, and finish the global deployment by mid-2009. We could not have embarked on such an ambitious undertaking without the capabilities provided by SAP CRM.”

Customer is King at Home Shopping EuropeGmbH

As one of the leading shopping television channels in Germany, HSE24 (Home Shopping EuropeGmbH) has identified the multichannel approach as the key success factor for generating superior customer value. Customers can access HSE24’s offerings via TV, the HSE24 Web site, telephone, e-mail or print publications. In March 2007, HSE24 bundled its ‘customer is king’ modernization program, where the company switched the management of customer information and service requests to SAP CRM.

With SAP CRM 2007 available, the company decided to upgrade its systems immediately and extend the scope of functionality covered by the SAP system. SAP CRM 2007 allows HSE24 to integrate internal business units, external services providers and interfaces to the back-end systems as well as to the Internet shop on a single platform. With the SAP application, HSE24 is successfully managing data of more than 6 million customers, 500,000 products and 70,000 daily order entries, with 800 call center specialists who can access the CRM system at the same time.

Apotex Lowers Cost of Customer Service Operations

Apotex, the largest Canadian-owned pharmaceutical company, uses SAP CRM 2007 and the SAP(R: 67.66, -0.69, -1.00%) NetWeaver Portal component as a platform to deliver online value-added services to pharmacists, healthcare professionals and students.

“With over 12,000 Internet customers and internal users utilizing SAP CRM 2007, we were able to consolidate five separate databases and manual processes onto one common platform,” said Michael Davidson, CIO, Apotex. “This enables us to effectively track marketing programs and customer activity. The effort reduced our administrative costs and improved our visibility into customer profitability.”

StatoilHydro Drives Top Line Revenue Growth

StatoilHydro is the largest seller of oil products in Scandinavia, with more than 29,000 employees in 40 countries.

“We upgraded to SAP CRM 2007 in just three months, going live in May 2008,” said Trond Grahnstedt, project manager, StatoilHydro. “With the rapid rollout to 410 users in our Scandinavian subsidiaries, SAP CRM 2007 is keeping our sales pipeline filled. We plan to extend our use of the application to both e-commerce and complaints management functionalities in the future.”

Bank fuer Sozialwirtschaft Strengthens Customer Orientation

Bank fuer Sozialwirtschaft (BfS), based in Cologne, Germany, selected the SAP for Banking solution portfolio in 2005 to replace a legacy core banking solution. Just two years later, BfS enhanced its SAP application landscape with a preconfigured banking solution based on SAP CRM 2007. The solution provides a consistent and comprehensive 360-degree view of all accounts and prospects for all customer-facing front- and back-office employees. Focus areas include customer and prospect management, opportunity and activity management, as well as pipeline performance management. The ease of use of SAP CRM 2007 was a key reason for BfS to select SAP and it is further supported by the integration of Microsoft Office applications with SAP CRM.

Adolf Wuerth GmbH & Co. KG Leverages End-to-End Processes to Strengthen Customer Relationships

The Wuerth Group is one of the world’s leading companies in fixing and assembly materials, including screws, dowels and plugs, chemical products and other tools. To strengthen relationships with its customers, Adolf Wuerth GmbH & Co. KG searched for a CRM solution both able to support the industry-specific requirements of the construction industry and capable of integrating deeply with its existing SAP application landscape. As one of the first companies worldwide to do so, AWKG selected SAP CRM 2007. The application is combined with an industry-specific solution of SAP partner movento and allows comprehensive key-account management for the company’s project-driven business. Additional benefits for AWKG were generated by the deep integration of SAP CRM 2007 into its existing deployment of SAP’s flagship enterprise resource planning application, SAP ERP, leading to tremendous improvements in efficiency.

SAP’s Co-Innovation Commitment

SAP continues to build momentum by engaging closely with customers and partners to further enhance its solutions and help customers exceed their business goals.

“By collaborating closely with our customers and partners, SAP is able to deliver cutting edge solutions that uniquely leverage the strength of our end-to-end process platform, which simply cannot be offered by any other provider,” said Jujhar Singh, senior vice president, CRM Product Management, SAP. “As a result, businesses are embracing SAP CRM 2007 on a global scale in an effort to interact more closely with and provide unmatched value to their customers, and thereby gain a greater competitive edge.”

SAP Customer Relationship Management (SAP CRM) is an important component of the SAP Business Suite. With an eye toward empowering the growing business user market, this breakthrough product has been co-innovated with leading customers and partners, and is designed to be simple and powerful to solve real business problems. SAP CRM offers capabilities such as trade promotions management, business communications management and pipeline performance management. SAP CRM features a dynamic user interface that gives business users the power to easily access all relevant information to best serve customers.

Source – http://www.foxbusiness.com/story/markets/industries/industrials/sap-customers-worldwide-tout-early-success-latest-crm-offering/

Posted in 7-SAP NEWS | Leave a Comment »

COMCPRFORMAT (TCODE) – Lexicograph Format Info

Posted by crmQ on July 26, 2008

1. In CRM, the transaction COMCPRFORMAT ( for Defining Product ID Settings ) has the settings for ‘Save Lexicographically’ as inactive then….
With nonlexicographical storage, the product IDs 123 and 0123 refer to the same product, that is, the leading zeros are meaningless. Both product numbers are stored in the database as 0000000000000000000000000000000000000123 and are thus identical.

2. But if In R3, the corresponding transaction OMSL has the settings for ‘Lexicographical’ as active then these 2 products will be considered as separate products….

Posted in 5-PRODUCT MASTER | Leave a Comment »

Process to Get Partner function (BP Address) related to Sales Order

Posted by crmQ on July 26, 2008

Using table CRMC_OBJECTS try to locate the entry “partner” and get the corresponding object type 7.

From table CRMD_ORDERADM_H take the GUID and select the entries in table CRMD_LINK table. Select the entry which has the objtype set = 7 and objtype_hi = 5. Get the corresponding GUID_SET entry.

Using the GUID_SET entry, select the entries in the CRMD_PARTNER table. Select the entry for the partner function you want to investigate. Get the corresponding address number.

Using this address number we can get the address information for the partner from ADRC table.

Source – www.erpgenie.com

Posted in 2-BP | Leave a Comment »

DEFAULT BP ROLE GROUPING

Posted by crmQ on July 25, 2008

It is not possible to define default Grouping based on BP type (person, org, group). through customizing. But you can accomplish it through a BDT extension (event ISDAT in BUS7). However you can have one default ext number range and one int number range for all BP roles. This is set in the Grouping IMG area.

Posted in 2-BP | Leave a Comment »

SAP user group foments revolt over massive price hike

Posted by crmQ on July 25, 2008

The UK SAP user group today called on the German software giant’s customers to scrutinise plans to force them to cough up almost a third more for their contract.

The group wants companies affected to examine the changes in detail in the hope they’ll be unhappy enough about a real-terms 30 per cent costs increase to kick up a stink.

SAP announced plans to railroad customers onto higher-spec support packages earlier this month. Costs are set to be ratcheted from 17 to 22 per cent of contract value, effective immediately for all new customers and to be phased in by 2012 for everyone else.

Alan Bowling, chairman of the UK SAP users group, said: “We understand that if SAP is to provide more comprehensive support then it has to charge more for it. However, many of our members may not want or need this extra level of support and therefore are reacting negatively to having a new support product and the associated increase in costs forced upon them.”

In particular, the UK users group and its German counterpart reckon the new support will be more than many small and medium-sized businesses need. Feedback on SAP’s attempt to force them to pay more has been “hugely negative”, Bowling said.

He called on SAP management to rethink strategy . Analysts estimate the price hike could generate an extra €1bn annually by the time all its customers have been squeezed, so some pretty loud complaining is likely to be required.

Source – http://www.theregister.co.uk/2008/07/25/sap_user_group_price_complaint/

Posted in 7-SAP NEWS | Leave a Comment »

Z ATTRIBUTES IN ORG MANAGEMENT

Posted by crmQ on July 24, 2008

To create custom attributes, goto TCODE – OOATTRCUST

-OR-

Go to table T77OMATTR ( TCODE – SM30), Find an attribute where table = HRT1222.
Create an new attribute by copying. Then add your new attributes. to the correct scenario (SALE or SERVICE).
Ensure that you have a ‘Z’ preceding the the attribute name

Posted in 1-ORG MANAGEMENT | Leave a Comment »

SAP Shutting down TOMORROWNOW Service

Posted by crmQ on July 23, 2008

SAP said it was working with TomorrowNow’s more than 225 customers to help them move to other service providers. TomorrowNow, which SAP bought in February 2005, provides support for Oracle and other business applications. Oracle’s brands include PeopleSoft, JD Edwards, and Siebel.

SAP plans to finish closing the operation before Oct. 31, 2008

TomorrowNow was at the center of a 2007 Oracle lawsuit accusing SAP of “corporate theft on a grand scale” because of document downloads by TomorrowNow employees.

The suit, which is pending, claimed TomorrowNow employees “copied and swept thousands of Oracle products and other proprietary and confidential materials into its own servers” using fake logins or credentials stolen from Oracle customers such as Bear Stearns, Honeywell, and Merck. The documents allowed SAP “to offer cut-rate support services to customers who use Oracle software, and to attempt to lure them to SAP’s applications software,” Oracle charged. Oracle later amended its suit to include copyright and breach-of-contract claims.

Source – http://www.informationweek.com/news/services/business/showArticle.jhtml?articleID=209400652

Posted in 7-SAP NEWS | Leave a Comment »

« Previous Entries

Next Entries »