Applies to:
SAP BW 3.5 and SAP BI 7.0 Reporting Consultants.
Summary
This article provides an exhaustive list of all standard SAP BW reports delivered as part of BI content for CRM-BW. It can be used in the projects during Project preparation and Blueprinting phase. BW Reporting Consultants can refer this guide and map user’s business reporting requirements to the standard reports and leverage them in order to prototype certain business scenarios.
Author(s): Rohit Garg and Rahul Mahajan
Company: Deloitte Consulting India Pvt. Ltd
Created on: 11 June 2012
Business Scenario
At the time of Blueprinting workshops, BW Consultants can leverage this directory of standard content delivered CRM reports. This handbook containing directory of reports can help consultants to map the user’s business requirement in terms of BEx queries.
Introduction
The bottom line of this document lies in the fact that it acts as one stop place where BW Reporting Consultants can look up and find all standard content delivered SAP BW CRM reports. All the reports have been categorized as per their relevant functional areas in order to help consultants to map business requirement and provide users the desirable reporting solution.
Directory of Reports
Query Name |
Description |
Financial Services Analyses |
|
0CRMFSC01_Q0001 |
Contingent Liability Report |
Grants Management for Grantor |
|
0GTR_C04_Q0001 |
Grantor Claims: Current Overview |
0GTR_C02_Q0001 |
Grantor Agreements: Current Overview |
0GTR_C01_Q0001 |
Grantor Applications: Current Overview |
0GTR_MC01_Q0001 |
Grantor Lifecyle: Current Overview |
0GTR_GPMELM_Q0001 |
Master Data: Grantor Program |
0CRM_CMGL_Q0101 |
Cases per Business Partner |
Partner and Channel Analytics |
|
0CHM_C01_Q0002 |
Channel Partner Customer Base |
0CHM_C01_Q0001 |
Channel Manager Partner Base |
0CSALMC02_Q0103 |
Channel Mgt. : Sales Pipeline Analysis |
0CSALMC02_Q0102 |
Channel Mgt.: Quotation Funnel Analysis |
0CRM_C04_Q0100 |
Channel Mgt.: Opportunities (Status: Open/In Progress |
0CSALMC02_Q0101 |
Channel Mgt.: Opportunity Funnel Analysis |
0CSALMC02_ Q0100 |
Channel Mgt. : Lead Funnel Analysis |
0CRM_C04_Q0101 |
Channel Mgt.: Expected Sales volume |
0CSAL_C01_Q0103 |
Channel Mgt.: Closed Activities |
0CSALMC01_Q0100 |
Channel Mgt.: Activities, Opportunities, and Sales Orders by Country |
0CSAL_C01_Q0100 |
Channel Mgt.: Activity History |
Rebate Processing Analyses |
|
0RDLI_Q0001 |
Rebate Due List: Item Data per Agreement Item |
0RDLP_Q0001 |
Rebate Due List: Cumulation Period Data per Agreement Item |
Disbursement of Budget to Invoice Line Items |
|
0SD_MC01_Q0003 |
Condition Rate Deviation (Sales Order and Billing Document) |
0SD_MC01_Q0002 |
Condition Amount (Billing Document) |
0SD_MC01_Q0001 |
Condition Amount (Sales Order) |
0SD_C15_Q0001 |
Condition Amount By Customer |
0SD_C04_Q0004 |
Average Delivery Processing Times |
0SD_C03_Q007 |
Billing Documents |
0SD_C03_Q006 |
Deliveries |
0SD_C04_Q0002 |
Delivery Delays per Sales Area |
0SD_C04_Q0001 |
Delivery Delays per Sold-to Party |
0SD_C01_Q026 |
Distribution Channel Analysis |
0SD_C03_Q011 |
Faultless Sales Order Processing |
0SD_C03_Q008 |
Fulfillment Rates |
0SD_C03_Q0014 |
Fulfillment Rates: Values |
0SD_C05_Q0003 |
General Quotation Information at Sales Area Level |
0SD_C05_Q0001 |
General Quotation Information per Customer |
0SD_C01_Q024 |
Incoming Orders Analysis |
0SD_C01_Q011 |
Incoming Orders per Calendar Year and Month |
0SD_C03_Q004 |
Incoming Orders per Customer |
0SD_C04_Q0003 |
Incorrect Delivery Quantities |
0SD_C02_Q0002 |
Monthly Deliveries |
0SD_C01_Q0002 |
Monthly Incoming Orders and Revenue |
0SD_C14_Q0001 |
Open Order Quantity for Last Week |
0SD_C03_Q010 |
Order, Delivery and Sales Quantities |
0SD_C01_Q021 |
Product Analysis |
0SD_C03_Q005 |
Proportion of Credit Memos to Billing Documents |
0SD_C01_Q012 |
Proportion of Credit Memos to Sales Volume |
0SD_C03_Q003 |
Proportion of Returns to Incoming Orders |
0SD_C01_Q022 |
Product Profitability Analysis |
0SD_C01_Q010 |
Returns per Customer |
0SD_C01_Q0003 |
Quantity and Value of Returns |
0SD_C05_Q0006 |
Quotation Success Rate per Sales Area |
0SD_C05_Q0004 |
Quotation Success Rate per Customer |
0SD_C05_Q0005 |
Quotation Tracking per Customer |
0SD_C05_Q0002 |
Quotation Tracking per Sales Area |
0SD_C01_Q025 |
Sales/Cost Analysis |
0SD_C01_Q0001 |
Sales Figures Comparison |
0SD_C03_Q009 |
Sales Values |
0SD_C01_Q013 |
Sales Volume |
0SD_C12_Q0001 |
Service Level – Item Level |
0SD_C12_Q0005 |
Service Level – Item Level (in six months) |
0SD_C01_Q023 |
Top Customers |
0SD_C02_Q0001 |
Weekly Deliveries (SD) |
0SD_C12_Q0006 |
Delivery Performance |
0SD_C12_Q0007 |
Material Availability Analytics — Stocks |
0SD_C11_Q0005 |
Delivery Performance — Sales Data |
0SD_C14_Q0003 |
Material Availability Analytics — Backorders |
0SD_C03_Q0003 / 0SD_MP02_Q0001 |
Warehouse Workload – Inbound Deliveries |
E-Analytics |
|
0WEB_C01_Q0001 |
Number of Hits |
0WEB_C01_Q0002 |
Technical Status of the Web Site |
0WEB_C01_Q0003 |
User Data |
0WEB_C01_Q0004 |
Clickstream |
0WEB_C01_Q0005 |
Dwell Time |
0WEB_C01_Q0101 |
Top 10 External Referrers |
0WEB_C01_Q0102 |
Visits, Page Impressions, Hits |
0WEB_C01_Q0103 |
Error Status |
0WEB_C01_Q0104 |
Volumes of Downloaded Data |
0WEB_C01_Q0105 |
Loading Time for Pages |
Sales Analyses |
|
Sales Planning Analysis |
|
0SAL_DS01_Q0005 |
Activities by Category |
0CSAL_C02_Q0007 |
Alerts for Contribution Margin Scheme |
0CSAL_C02_Q0006 |
Alerts for Plan/Actual Variance |
0CRM_C04_Q0020 |
OpportunityPipeline |
0CRM_OPPH_Q0001 |
OpportunityPlan |
0CRM_OPPH_Q0002 |
OpportunityPlan (for Alerts) |
0CSAL_C02_Q002 |
Plan/Actual Completion (YTD/YTG |
0CSAL_C02_Q0001 |
Plan/Actual Comparison |
0CSAL_C02_Q0003 |
Plan/Actual Comparison with Hierarchies |
0CSAL_C02_Q001 |
Plan/Actual Comparison with Variances |
0CSAL_C02_Q0004 |
Plan/Actual Contribution Margin Scheme |
0CSAL_C02_Q0012 |
Plan/Actual Monitor of Sales and Opportunity Plan |
0CSALMC02_Q010 |
Sales Pipeline |
0CSAL_C02_Q0005 |
Status Monitor |
0CSAL_C12_Q001 |
Total Funnel |
Sales Analyses |
|
Activity Analysis |
|
0SAL_DS01_Q0005 |
Activities by Category |
0CSAL_C01_Q0004 |
Active/Passive Analysis |
0CSAL_C01_Q0023 |
Activities/Items per Activity Partner |
0SAL_DS01_Q0002 |
Activities per Category (Employee Responsible, Document Level) |
0CSAL_DS01_Q004 |
Activity Details |
SAL_C01_Q0016 |
Activity History |
0CSAL_C01_Q0021 |
Activity Partner with Open Activities |
0SAL_DS01_Q0003 |
Activity Partners w/ Open Activities (Employee Resp, Doc. Level) |
0CSAL_C12_Q002 |
Completed Activities |
0SAL_DS01_Q001 |
Date of Last Activity |
0SAL_DS01_Q0010 |
Date of Next Activity |
0CSAL_C01_Q0005 |
Distribution of Activities per Organizational Unit |
0CSAL_C01_Q0003 |
Intensity of Customer Care (Activity Partner) |
0CRM_C01_Q0018 |
Intensity of Customer Care by Employee (Sales Manager Portal) |
0CSAL_C01_Q0019 |
Intensity of Customer Care by Partner (Sales Manager Portal) |
0CSAL_C01_Q0001 |
Intensity of Customer Care (Employee) |
0CSAL_C01_Q0002 |
Intensity of Customer Care (Owner) |
0SAL_C01_Q0009 |
Last 20 Closed Activities |
0CSAL_C01_Q0013 |
My Team’s Planned Activities |
0CSAL_C01_Q0020 |
Number of Activities per Category |
0CRM_C08_Q0002 |
Number of Samples Distributed in Current Year |
0CRM_C08_Q0003 |
Number of Samples per Batch and Contact Person |
0CRM_C01_Q0017 |
Planned Activities |
0CRM_C08_Q0001 |
Pre-Sales Investment in Activity Partner |
0CSAL_C01_Q0022 |
Previous Months’ Sales Activities |
0CSAL_C01_Q0006 |
Success/Failure Analysis |
0CSAL_C01_Q0015 |
Success/Failure Analysis (Sales Manager Portal) |
0CSAL_C01_Q0024 |
Activities (One Order and Interaction Objects) per Campaign |
Sales Analyses |
|
OpportunityAnalysis |
|
0CRM_C04_Q018 |
Competitors in Current Opportunities |
0CRM_C04_Q007 |
Completed Opportunities According to Status |
0CRM_C04_Q012 |
Completed Opportunities Acc. to Status (Sales Manager Portal) |
0CRM_C04_Q008 |
Expected Product Value |
0CRM_C04_Q015 |
Expected Sales Volume per Product |
0CRM_C04_Q017 |
My Strongest Competitors |
0CRM_C04_Q0001 |
Query of Opportunity |
0CRM_OPPI_Q001 |
Opportunity Item Details |
0CRM_OPMO_Q0001 |
Opportunity Monitor |
0CSALMC04_Q001 |
Opportunity Monitor Timeline Analysis |
0CRM_C04_Q0020 |
OpportunityPipeline |
0CRM_C04_Q003 |
Pipeline Analysis per Phase |
0CRM_C04_Q011 |
Pipeline Analysis per Phase (Sales Manager Portal) |
0CRM_C04_Q004 |
Pipeline Analysis per Region |
0CRM_C04_Q002 |
Sales Volume Forecast |
0CRM_C04_Q014 |
Sales Volume Forecast (Sales Manager Portal) |
0CRM_C04_Q005 |
Targeting Based on Competitors |
0CRM_C04_Q006 |
Targeting Based on Lost Opportunities |
0CRM_C04_Q013 |
Top Five Opportunities |
RM_C04_Q013_1 |
Top Five Opportunities (Business Transaction Number) |
0CRM_C04_Q001 |
Win/Loss Analysis |
0CRM_C04_Q015 |
Win/Loss Analysis According to Product |
0CRM_C04_Q010 |
Win/Loss Analysis (Sales Manager Portal |
Sales Analyses |
|
Sales Quotations and Orders Analysis |
|
Sales Orders |
|
0CSALMC03_Q0006 |
Query of Sales Order |
0CSAL_C03_Q0001 |
Incoming Sales Orders |
0CSAL_C03_Q0003 |
Incoming Orders (Last 12 Months) |
0CSAL_C03_Q0005 |
Sales: Incoming Orders per Month |
0CSAL_C03_Q0002 |
Open Sales Orders |
0CRM_SALO_Q002 |
Items in Backorder Processing |
0CSAL_C03_Q009 |
Incoming Orders per Product |
0CSAL_C03_Q008 |
Best-Selling Products |
0CSAL_C03_Q0011 |
Billed Sales Orders (Last 12 Months) per Territory |
0CRM_SALO_Q0003 |
Billed Sales Orders per Territory and Transaction Number |
Sales Analyses |
|
Sales Quotations and Orders Analysis |
|
Sales Quotations |
|
0CSAL_C05_Q0001 |
Sales: General Quotation Information |
0CSAL_C05_Q0003 |
Sales: Quotation Success Rate |
0CSAL_C05_Q0002 |
Sales: Quotation Tracking |
0CSAL_C05_Q0004 |
Sales: Open Quotations per Region |
0CSAL_C05_Q0005 |
Sales: Top Five Sold-To Parties (Quotations) |
0CRM_QUTO_Q0001 |
Top Five Quotations |
0CRM_QUTO_Q0001_1 |
Top Five Quotations (Business Transaction Number) |
0CRM_QUTO_Q0002 |
Quotation Details |
Sales Analyses |
|
Sales Quotations and Orders Analysis |
|
Channel Management |
|
(0CSAL_C02_Q0008) |
Plan/Actual Comparison (YTD): Product Hierarchy, Business Partner |
(0CSAL_C03_Q0007) |
Incoming Orders from Last Month (Open and Completed) – Top 3 |
(0CSAL_C03_Q0008) |
Incoming Orders from Last Month – Details |
(0CSAL_C03_Q0010) |
Incoming Orders (Open and Completed) with Sold-to Party Variable |
(0CSAL_C04_Q0010) |
Open Sales Contracts: Comparison of Contract Quantity and Value |
0CSAL_C05_Q0100 |
Channel Mgmt.: General Quotation Information |
0CSAL_C03_Q0007 |
Channel Mgmt.: Last Month’s Incoming Orders (Open+Cmpltd)–Top 3 |
0CSAL_C03_Q0009 |
Channel Management: Sales Orders (MTB) (TS) |
0CSAL_C02_Q0108 |
Channel Mgmt.: Plan/Actual Comparison (Order-on-Behalf) YTD |
0CSAL_C05_Q0101 |
Channel Mgmt.: Quotation History |
0CSAL_C05_Q0102 |
Channel Mgmt.: Quotation Top-n Products |
0CSAL_C03_Q0100 |
Channel Mgmt.: Sales Statistics (Hosted Order Management) |
0CSAL_C03_Q0008 |
Channel Mgt.: Incoming Orders(Open+Completed) with Reseller ID |
0CSAL_C03_Q0010 |
Channel Mgt:Order Entry(Open/Compl.) With Variable Sold-To-Party |
0CSAL_C02_Q0009 |
Channel Mgt:Plannd/Act. Comparison(MTD) Prod. Hier., Bus.Partner |
0CSAL_C02_Q0008 |
Channel Mgt:Plannd/Act. Comparison(YTD) Prod. Hier., Bus.Partner |
Marketing Analyses |
|
Marketing and Campaign Analysis |
|
0CRM_MC06_Q3010 |
Top 10 Campaigns by Number of Leads |
0CRM_MC06_Q3011 |
Year to Date Marketing Pipeline |
0CRM_MC06_Q3012 |
Marketing Contribution to Pipeline |
0CRM_MC06_Q3013 |
Campaign Key Performance Indicators |
0CRM_MC06_Q3014 |
Campaign Financial and Response Performance |
0CRM_MC06_Q3015 |
Last Year Campaigns Revenue to Pipeline Revenue |
0CRM_MC06_Q3016 |
Campaign Performance Over Time |
0CRM_MC06_Q3017 |
Campaign Key Metrics |
0CRM_MC06_Q3053 |
Opportunity Discontinuation Reason |
0CRM_MC06_Q3058 |
All Campaigns |
0CRM_MC06_Q3080 |
Historical Campaign Analysis |
Marketing Analyses |
|
External List Analysis |
|
0ELM_IS01_Q7001 |
Quality of Address List |
0MKTG_MC1_Q7001 |
Sales Success Address List |
Marketing Analyses |
|
Lead Analysis |
|
0MKTG_C01_Q7001 |
Won/Lost Leads |
0MKTG_C01_Q7002 |
Lead Origin |
0MKTGMP02_Q3031 |
Top 10 Leads |
0CRM_0MKTG_C01_Q3051 |
Leads per Qualification Level and Priority |
0CRM_0MKTG_C01_Q3052 |
Lead Conversion Rate |
0CRM_0MKTG_C01_Q3053 |
Lead Qualification Time |
0CRM_0MKTG_C01_Q3054 |
Top 5 Leads |
0CRM_MC06_Q3052 |
Leads by Qualification |
0CRM_MC06_Q3054 |
Lead Rejection Reason |
0CRM_MC06_Q3055 |
Cost per Lead Won |
0CRM_MC06_Q3061 |
Lead Aging by Status |
0CRM_MC06_Q3062 |
Leads by Sales Organization |
0CRM_MC06_Q3063 |
Top 10 Leads by Revenue |
0CRM_MC06_Q3064 |
Top 10 Lead Owners |
0CRM_0MKTG_C01_Q3055 |
Employee List |
0MKTG_C01_Q0001 |
Lead Management: Channel Analysis |
0MKTG_C01_Q0002 |
Lead Management: Efficiency Reporting |
0MKTG_C01_Q0004 |
Lead Management: History Reporting |
0MKTG_C01_Q0005 |
Lead Management: Lost Leads |
0MKTG_C01_Q0003 |
Lead Management: Qualification Level |
0MKTG_C01_Q0102 |
Channel Mgmt.: Lead History |
0MKTG_C01_Q0101 |
Channel Mgmt.: Top-n Lost Leads (Current Year) |
0MKTG_C01_Q0100 |
Channel Mgmt.: Won Leads (Current Year) |
Marketing Analyses |
|
Market Exploration |
|
Dun & Bradstreet External Market Data |
|
D&B Marketing Universe for SAP BW |
|
0DB_MC01_Q0001 |
D&B Marketing Analysis |
0DB_MC01_Q0005 |
D&B GIS Penetration Analysis |
0DB_MC01_Q0003 |
D&B Customer (%) vs. Norm (%) |
0DB_MC01_Q0004 |
0DB_MC01_Q0004 |
0DB_MC01_Q0009 |
D&B Historical View |
0DB_MC01_Q0015 |
D&B Historical View (Overview Loaded Data) |
0DB_MC01_Q0002 |
D&B Marketing Details – All Businesses |
0DB_MC01_Q0010 |
D&B Marketing Details – Customers |
0DB_MC01_Q0011 |
D&B Marketing Details – Prospects |
0DB_MC01_Q0007 |
D&B Tactical Data |
0DB_MC01_Q0012 |
D&B Family Tree Analysis |
Product Analyses |
|
Cross-Selling |
|
0CRM_CXS_Q0001 |
CRM Cross-Selling Analysis |
0QM_CXS_Q0001 |
Cross-Selling Analysis |
0CRM_CXS_Q0002 |
Source for CRM Cross-Selling Analysis |
0DM_CXS_Q0002 |
Source for Cross-Selling Analysis |
Product Analyses |
|
Competitor Analysis |
|
0CRM_PRCU_Q0002 |
Top Ten Listed Competitor Products |
0CCP_IS01_Q0001 |
Customer Competitor Products |
Customer Analyses |
|
Fact Sheet Analysis |
|
0CRM_FSC1_Q0002 |
Account Revenue |
0CRM_FSC1_Q0001 |
Customer Service |
0CRM_SOLDTO_Q0001 |
CRM Attributes (Fact Sheet) |
0CSALMC02_Q009 |
Sales Pipeline for Fact Sheet |
0CSRVMC01_Q0101 |
Service Overview |
0CSAL_C07_Q0107 |
Expiring Service Contract Items |
0CRM_ICWY_Q0101 |
Expiring Warranties |
Customer Analyses |
|
0BP_C00_Q0004 |
Queries for Business Partner Billing Data |
0BP_C00_Q0006 |
Queries for Business Partner Sales Data |
0BP_C00_Q0005 |
Queries for Business Partner Shipping Data |
Customer Analyses |
|
Queries for Migration Analysis |
|
0CRMAIS01_Q0001 |
CRM ABC Migration analysis |
0DMACIS01_Q0001 |
Comparison of ABC Classification and Clustering |
0CRATIS01_Q0001 |
Comparison of CRM ABC Classification and CRM Decision Tree |
0DMAMC01_Q0004 |
Deviation of ABC Classification from Decision Tree analysis |
0CRMCIS01_Q0001 |
CRM Clustering Migration analysis |
0DMCIS01_Q0001 |
Clustering Migration analysis |
0CRCTIS01_Q0001 |
Comparison of CRM Clustering and CRM Decision Tree |
0DMCTIS01_Q0001 |
Comparison of Clustering and Decision Tree |
0CRMTIS01_Q0001 |
CRM Decision Tree Migration analysis |
0DMTIS01_Q0001 |
Decision Tree Migration analysis |
Customer Analyses |
|
Queries for Deviation Analysis |
|
0CRMAMC01_Q0001 |
CRM ABC Deviation analysis relative to second ABC Classification |
RMAMC01_Q0002 |
CRM ABC Deviation analysis relative to first ABC Classification |
0DMAMC01_Q0001 |
ABC Deviation analysis relative to second ABC Classification |
0DMAMC01_Q0002 |
ABC Deviation analysis relative to first ABC Classification |
0CRMAMC01_Q0003 |
Deviation of CRM ABC Classification from CRM Clustering analysis |
0CRMCMC01_Q0003 |
Deviation of CRM Clustering analysis from CRM ABC Classification |
0DMAMC01_Q0003 |
Deviation of ABC Classification from Clustering analysis |
0DMCMC01_Q0003 |
Deviation of Clustering analysis from ABC Classification |
0CRMAMC01_Q0004 |
Deviation of CRM ABC Classification from CRM Decision Tree analysis |
0CRMTMC01_Q0003 |
Deviation of CRM Decision Tree analysis from CRM ABC Classification |
0DMAMC01_Q0004 |
Deviation of ABC Classification from Decision Tree analysis |
0DMTMC01_Q0003 |
Deviation of Decision Tree analysis from ABC Classification |
0CRMCMC01_Q0001 |
CRM Clustering Deviation analysis rel to 2nd Clustering analysis |
0CRMCMC01_Q0002 |
CRM Clustering Deviation analysis relative to first Clustering |
0DMCMC01_Q0001 |
Clustering Deviation analysis relative to second Clustering |
0DMCMC01_Q0002 |
Clustering Deviation analysis relative to first Clustering analysis |
0CRMCMC01_Q0004 |
Deviation of CRM Clustering analysis from CRM Decision Tree |
0CRMTMC01_Q0004 |
Deviation of CRM Decision Tree analysis from CRM Clustering |
0DMCMC01_Q0004 |
Deviation of Clustering analysis from Decision Tree analysis |
0DMTMC01_Q0004 |
Deviation of Decision Tree analysis from Clustering analysis |
0CRMTMC01_Q0001 |
CRM Decision Tree Deviation analysis rel to 2nd DT analysis |
0CRMTMC01_Q0002 |
CRM Decision Tree Deviation analysis rel to 1st DT analysis |
0DMTMC01_Q0001 |
Decision Tree Deviation analysis relative to second DT analysis |
0DMTMC01_Q0002 |
Decision Tree Deviation analysis relative to first DT analysis |
Customer Analyses |
|
Prequeries for Deviation Analysis |
|
0CRMAMC01_Q0005 |
CRM ABC analysis BPs in 2nd analysis |
0CRMAMC01_Q0006 |
CRM ABC analysis BPs in 1st analysis |
0CRMCMC01_Q0005 |
CRM Clustering analysis BPs in 2nd analysis |
0CRMCMC01_Q0006 |
CRM Clustering analysis BPs in 1st analysis |
0CRMTMC01_Q0005 |
CRM Decision Tree analysis BPs in 2nd analysis |
0CRMTMC01_Q0006 |
CRM Decision Tree analysis BPs in 1st analysis |
0DMAMC01_Q0005 |
ABC analysis BPs in 2nd analysis |
0DMAMC01_Q0006 |
ABC analysis BPs in 1st analysis |
0DMCMC01_Q0005 |
Clustering analysis BPs in 2nd analysis |
0DMCMC01_Q0006 |
Clustering analysis BPs in 1st analysis |
0DMTMC01_Q0005 |
Decision Tree analysis BPs in 2nd analysis |
0DMTMC01_Q0006 |
Decision Tree analysis BPs in 1st analysis |
Customer Analyses |
|
0CRM_OLVM_Q0001 |
CRM CLTV Models |
0CRM_OLVM_Q0002 |
CRM Sales: CLTV Models |
0CRM_OLVF_Q0001 |
CRM CLTV Predictions |
Cross-Application Performance Analyses |
|
Queries for Cross-Application Performance Analyses |
|
Activities, Opportunities and Sales |
|
0SAL_DS01_Q0005 |
Activities by Category |
0CSALMC01_Q010 |
Sales, Activities & Opportunities: Processing Time/Sales Volumes |
0CSALMC01_Q001 |
Sales, Activities & Opportunities; Number and Volumes |
Cross-Application Performance Analyses |
|
Queries for Cross-Application Performance Analyses |
|
Orders, Contracts and Complaints |
|
0CSALMC03_Q0004 |
Yesterday’s Incoming Orders |
0CSALMC03_Q0003 |
Incoming Orders |
0CSALMC03_Q0005 |
Incoming Orders (Returns, Credit and Debit Memos) |
0CSALMC03_Q001 |
Open Orders and Contracts |
0CSALMC02_Q0005 |
Incoming Orders Returns (Inc. Credit Memos) |
0CSALMC02_Q0006 |
Order Cancellation |
Cross-Application Performance Analyses |
|
Queries for Cross-Application Performance Analyses |
|
Sales Funnel and Pipeline |
|
0CSALMC02_Q0008 |
Campaign Funnel Analysis |
0CSALMC02_Q001 |
Lead Funnel Analysis |
0CSALMC02_Q005 |
OpportunityFunnel Analysis |
0CSALMC02_Q007 |
Quotation Funnel Analysis |
0CSALMC02_Q010 |
Sales Pipeline |
0CSALMC02_Q002 |
Sales Pipeline Analysis |
0CSALM_C02_Q0001 |
Sales Pipeline: Incoming Orders |
0CSALMC02_Q003 |
Sales Pipeline: Forecast Reliability |
Interaction Channel Analyses |
|
Help Desk Analytics |
|
0CSRV_C01_Q0202 |
Service Ticket Overview |
0CSRV_C01_Q0201 |
Open Service Tickets |
0CSRV_T01_Q0001 |
Open Service Ticket History |
0CSRV_C01_Q0203 |
Average Lead Time |
Interaction Channel Analyses |
|
E-Mail Response Management System Analytics |
|
|
|
0CRM_ER11_Q0001 |
E-Mail Response Management System Statistics |
Interaction Channel Analyses |
|
Interactive Scripting Evaluation |
|
0CRM_CIC1_Q0001 |
IC: Interactive Scripting Evaluation (IC WinClient) |
0CRM_ISE2_Q0001 |
IC: Interactive Scripting Evaluation (IC WebClient) |
Interaction Channel Analyses |
|
Interaction Statistics |
|
0CRM_CTI_QABRT1 |
IC: Abandonment Rate |
0CRM_CTI1_QCHAT_ABRT |
Abandonment Rate for Chat |
0CRM_CTI1_QPUSH_REJ |
Number of Rejected Items for Push |
0CRM_CTI1_QDRAB1 |
IC: Average Time to Abandonment |
0CRM_CTI2_QASA1 |
IC: Average Speed of Answer |
0CRM_CTI_QASA1 |
IC: Average Speed of Answer (in Time Intervals) |
0CRM_CTI1_QCHAT_ASA |
Average Speed of Answer for Chat |
0CRM_CTI1_QPUSH_ASA |
Average Speed of Answer for Push |
0CRM_CTI2_QHDTM1 |
IC: Average Handling Times |
0CRM_CTI_QHDTM1 |
IC: Average Handling Times (in Time Intervals) |
0CRM_CTI1_QCHAT_AHT |
Average Handling Time for Chat |
0CRM_CTI1_QPUSH_AHT |
Average Handling Time for Push |
0CRM_CTI2_QSL01 |
IC: Service Level |
0CRM_CTI_QSL01 |
IC: Service Level (in Time Intervals) |
0CRM_CTI1_QCHAT_SL |
Service Level for Chat |
0CRM_CTI2_QPUSH_SL |
Service Level for Push |
0CRM_CTI2_QVOL1 |
IC: Connection Volume |
0CRM_CTI1_QCVOL |
IC: Connection Volume (in Time Intervals) |
0CRM_CTI1_QCHAT_VOL |
Volume of Chat Connections |
0CRM_CTI2_QTRF01 |
IC: Transfers |
0CRM_CTI1_QTRF01 |
IC: Transfers (in Time Intervals) |
0CRM_CTI2_QPUSH_TRF |
Number of Transfers for Push |
0CRM_CTI1_Q001 |
Interaction Statistics in Time Intervals (General) |
Interaction Channel Analyses |
|
Collections Management |
|
0FC_MP25_Q0001 |
Interaction and Work Items (Outbound) |
0CIC_MP45_Q0001 |
Interaction and Event (Inbound) |
Interaction Channel Analyses |
|
Real-Time Offer Management Analytics |
|
CRM IC Real-Time Offer Management |
|
0CRM_IC_RTOM_DS01_Q001 |
Real-Time Offer Management Agent Performance |
0CRM_IC_RTOM_DS01_Q003 |
Real-Time Offer Management Agent Performance on Specific Offers |
0CRM_IC_RTOM_DS01_Q007 |
Real-Time Offer Management Agent Performance Trend |
0CRM_IC_RTOM_DS01_Q002 |
Real-Time Offer Management Offer Performance |
0CRM_IC_RTOM_DS01_Q006 |
Real-Time Offer Management Offer Performance Trend |
0CRM_IC_RTOM_DS01_Q005 |
Real-Time Offer Management Comparison of Offer Performance |
0CRM_IC_RTOM_DS01_Q004 |
Real-Time Offer Management Customer Transactions |
0CRM_IC_RTOM_DS02_Q008 |
Real-Time Offer Management Predictor Changes Over Time |
0CRM_IC_RTOM_DS01_Q009 |
RTOM Query Max |
0CRM_IC_RTOM_DS01_Q009_V012 |
Trend Analysis (Weekly) |
0CRM_IC_RTOM_DS01_Q009_V013 |
Trend Analysis (Monthly) |
0CRM_IC_RTOM_DS01_Q009_V014 |
Offer Performance Graph |
0CRM_IC_RTOM_DS01_Q009_V015 |
Agent Performance Graph |
0CRM_IC_RTOM_DS01_Q010 |
Agent Performance Graph |
0CRM_IC_RTOM_DS01_Q010_V001 |
Agent Performance (Last Day) |
0CRM_IC_RTOM_DS01_Q010_V002 |
Agent Performance on RTOM Offer (Last Day) |
0CRM_IC_RTOM_DS01_Q010_V003 |
Offer Performance (Last Day) |
0CRM_IC_RTOM_DS01_Q010_V004 |
Offer Performance by Recipient Profiles (Last Day) |
0CRM_IC_RTOM_DS01_Q011 |
RTOM Query Last 7 Days |
0CRM_IC_RTOM_DS01_Q011_V001 |
Agent Performance (Last 7 Days) |
0CRM_IC_RTOM_DS01_Q011_V002 |
Agent Performance on RTOM Offer (Last 7 Days) |
0CRM_IC_RTOM_DS01_Q011_V003 |
Offer Performance (Last 7 Days) |
0CRM_IC_RTOM_DS01_Q011_V004 |
Offer Performance by Recipient Profiles (Last 7 Days) |
0CRM_IC_RTOM_DS01_Q011_V005 |
Trend Analysis (Last 7 Days) |
0CRM_IC_RTOM_DS01_Q012 |
Customer Transaction |
0CRM_IC_RTOM_DS02_Q009 |
Predictor Change |
Interaction Channel Analyses |
|
Partner and Channel Analytics |
|
0CSAL_C01_Q0100 |
Channel Mgt.: Activity History |
0CSALMC01_Q0100 |
Channel Mgt.: Activities, Opportunities, and Sales Orders by Country |
0CSAL_C01_Q0103 |
|
0CRM_C04_Q0101 |
Channel Mgt.: Expected Sales volumec |
0CSALMC02_ Q0100 |
Channel Mgt. : Lead Funnel Analysis |
0CSALMC02_Q0101 |
Channel Mgt.: Opportunity Funnel Analysis |
0CRM_C04_Q0100 |
Channel Mgt.: Opportunities (Status: Open/In Progress) |
0CSALMC02_Q0102 |
Channel Mgt.: Quotation Funnel Analysis |
0CSALMC02_Q0103 |
Channel Mgt. : Sales Pipeline Analysis |
0CHM_C01_Q0001 |
Channel Manager Partner Base |
0CHM_C01_Q0002 |
Channel Partner Customer Base |
Service Analyses |
|
Planned Services Analysis |
|
0CRM_FOCS_Q0001 |
Resource Requirements and Service Volume |
0CRM_FOCS_Q0002 |
Resource Requirements and Service Volume (Order Level) |
0CRM_FOCS_Q0003 |
Comparison of Service Plan Simulations |
0CRM_FOID_Q0001 |
Determine ID of Last Service Plan Simulation |
Service Analyses |
|
Service Contract and Quotation Analysis |
|
0CSAL_C07_Q0101 |
Highest-Revenue Products in Service Contracts |
0CSAL_C07_Q0102 |
Top-Selling Products in Service Contracts |
0CSAL_C07_Q0103 |
Profit per Product in Service Contracts |
0CSAL_C07_Q0104 |
Profit-Sales Ratio per Product in Service Contracts |
0CSAL_C07_Q0105 |
Variance Analysis per Product in Service Contracts |
0CSAL_C07_Q0201 |
Product Analysis in Service Contracts |
0CSRVMC03_Q0101 |
Changes in Processing Volumes |
0CSAL_C07_Q0106 |
Remaining Term of Service Contracts |
0CRM_PRLI_Q0101 |
Top-Selling Products in Product Lists |
0CRM_SCOL_Q0101 |
Number of Service Contracts per Installed Base Category |
0CSRVMC06_Q0101 |
Installed Bases Without a Valid Service Contract |
0CSAL_C07_Q0107 |
Expiring Service Contract Items |
0CSRV_C02_Q0101 |
Profitability of Service Contracts |
Service Analyses |
|
Warranty Analysis |
|
0CRM_ICWY_Q0101 |
Expiring Warranties |
0CRM_IOW1_Q0101 |
Warranty Usage List |
0CRM_IOW1_Q0102 |
Warranty Expiration Analysis |
0CRM_PRI_Q0108 |
Warranty Entitlement Analysis |
0CRM_CODT_Q0102 |
Warranty Costs Analysis |
Service Analyses |
|
Service Order and Quotation Analysis |
|
0CSRV_C01_Q0101 |
Average Order Volumes |
0CSRV_C01_Q0102 |
Rate of Order Completion |
0CSRV_C01_Q0103 |
0CSRV_C01_Q0103 |
0CRM_PRI_Q0101 |
Delayed Services with Requested-By Date |
0CRM_PRI_Q0102 |
Services on Schedule with Requested-By Date |
0CRM_PRI_Q0103 |
Delayed Services with Service Level Agreement Date |
0CRM_PRI_Q0104 |
Services on Schedule with Service Level Agreement Date |
0CRM_PRI_Q0105 |
Delayed Services: Order Value |
0CRM_PRI_Q0106 |
Planning Accuracy |
0CRM_PRI_Q0201 |
Service Compliance |
0CSRVMC03_Q0101 |
Changes in Processing Volumes |
0CSRVMC04_Q0101 |
Complaint Ratio by Product |
0CSRV_C01_Q0104 |
Analysis of Incoming Channels for Service Orders |
0CRM_PRI_Q0107 |
Accounting Indicator Analysis |
0CRM_QTIC_Q0101 |
Service Order Quotation Success Analysis |
0CRM_QTIC_Q0102 |
Service Order Quotation Rejection Analysis |
0CRM_QTIC_Q0103 |
Service Order Quotation Expiration Analysis |
0CRM_QTIC_Q0104 |
Service Order Quotation Expected Revenue Analysis |
Service Analyses |
|
Cost and Revenue Analysis |
|
0CRM_CODT_Q0101 |
Material Costs and Labor Costs |
0CSRVMC05_Q0101 |
Changes in Overall Controlling |
0CSRVMC05_Q0102 |
Highest-Revenue Sold-To Parties |
0CSRVMC05_Q0103 |
Profit per Sold-To Party |
0CSRVMC05_Q0104 |
Profit-Sales Ratio per Sold-To Party |
0CSRVMC02_Q0106 |
Variance Analysis per Product |
0CSRVMC05_Q0201 |
Sold-To Party Analysis |
0CSRVMC02_Q0101 |
Changes in Business Volumes |
0CSRVMC02_Q0102 |
Highest-Revenue Products |
0CSRVMC02_Q0103 |
Top-Selling Products |
0CSRVMC02_Q0104 |
Profit per Product |
0CSRVMC02_Q0105 |
Profit-Sales Ratio per Product |
0CSRVMC05_Q0105 |
Variance Analysis per Sold-To Party |
0CSRVMC02_Q0201 |
Product Analysis |
0CSRVMC01_Q0101 |
Service Overview |
0CSRVMC02_Q0107 |
Share of Revenue of Products |
Service Analyses |
|
Complaints and Returns Analysis |
|
0CSAL_C09_Q0101 |
Number of Service Complaints |
0CSRVMC04_Q0101 |
Complaint Ratio by Product |
0CSRVMC03_Q0101 |
Changes in Processing Volumes |
Service Analyses |
|
Case Management Analysis |
|
0CRM_CMG2_Q0102 |
Controlling Analysis for Cases |
0CRM_CASE_Q0101 |
Case Workload Analysis |
0CRM_CASE_Q0102 |
Analysis of Sensitive Cases |
0CRM_CASE_Q0103 |
Planned Date of Case Closure |
0CRM_CMGL_Q0101 |
Case Relationship Analysis for Linked Business Partner |
0CRM_CMGL_Q0102 |
Case Relationship Analysis for Linked Products |
0CRM_CMG1_Q0101 |
Case Escalation Analysis |
0CRM_CMG2_Q0101 |
Status Overview for Documents in Cases |
Service Analyses |
|
IT Service Management Analytics |
|
0SRQ_C10_Q0002 |
Reported Service Request |
0SRQ_C11_Q0001 |
Reported Problems |
0CSRVMC05_Q0001 |
Reported Requests for Change |
0CSRVMC05_Q0001 |
Reported Requests for Change |
0CSRVMC05_Q0002 |
SLA Compliance of Requests for Change |
0CSRVMC05_Q0003 |
Closure Rate for Requests for Change |
0CSRVMC05_Q0004 |
Number and Percentage of Approved Requests for Change |
0CSRVMC05_Q0005 |
Objects with Highest Number of Requests for Change |
0CSRVMC05_Q0006 |
IBases with Highest Number of Requests for Change |
0CSRVMC05_Q1001 |
RFC Priority Total |
0CSRVMC05_Q1002 |
RFC Priority Individual |
0CSRVMC05_Q1003 |
RFC Category by Subject |
0CSRVMC05_Q1004 |
RFC Category by Reason |
0CSRVMC05_Q1005 |
RFC IBase Top 5 |
0CSRVMC05_Q1006 |
RFC Object Top 5 |
0CSRVMC05_Q1007 |
RFC Ref. Product Top 5 |
0CSRVMC05_Q1009 |
RFC Service Org. Top 5 |
0CSRVMC05_Q1010 |
RFC Service Team Top 5 |
0CSRVMC05_Q1011 |
RFC Sold-To Party Top 5 |
0CSRVMC05_Q1012 |
RFC Duration |
0CSRVMC05_Q1013 |
RFC Sales Org. Top 5 |
0SRQ_C10_Q0002 |
Reported Service Request |
0SRQ_C10_Q0003 |
Average Work and Total Duration of Service Requests |
0SRQ_C10_Q0004 |
Service Level Compliance of Service Requests |
0SRQ_C10_Q0005 |
IBases with Highest No. of Service Requests |
0SRQ_C10_Q0006 |
Objects with Highest No. of Service Requests |
0SRQ_C10_Q0007 |
Products with Highest No. of Service Requests |
0SRQ_C10_Q0008 |
Service Request Closure Rate |
0SRQ_C10_Q1001 |
SRQ Priority Total |
0SRQ_C10_Q1002 |
SRQ Priority Individual |
0SRQ_C10_Q1003 |
SRQ Category by Subject |
0SRQ_C10_Q1004 |
SRQ Category by Reason |
0SRQ_C10_Q1005 |
SRQ IBase Top 5 |
0SRQ_C10_Q1006 |
SRQ Object Top 5 |
0SRQ_C10_Q1007 |
SRQ Ref. Product Top 5 |
0SRQ_C10_Q1008 |
SRQ Sales Org. Top 5 |
0SRQ_C10_Q1009 |
SRQ Service Org. Top 5 |
0SRQ_C10_Q1010 |
SRQ Service Team Top 5 |
0SRQ_C10_Q1011 |
SRQ Sold-To Party Top 5 |
0SRQ_C10_Q1012 |
SRQ Duration |
0SRQ_C11_Q0001 |
Reported Problems |
0SRQ_C11_Q0002 |
SLA Compliance of Problems |
0SRQ_C11_Q0003 |
Average Work and Total Duration of Problems |
0SRQ_C11_Q0004 |
Closure Rate of Problems |
0SRQ_C11_Q0005 |
Objects with Highest No. of Problems |
0SRQ_C11_Q0006 |
IBases with Highest No. of Problems |
0SRQ_C11_Q1001 |
Problem Priority Total |
0SRQ_C11_Q1002 |
Problem Priority Individual |
0SRQ_C11_Q1003 |
Problem Category by Subject |
0SRQ_C11_Q1004 |
Problem Category by Reason |
0SRQ_C11_Q1005 |
Problem IBase Top 5 |
0SRQ_C11_Q1006 |
Problem Object Top 5 |
0SRQ_C11_Q1007 |
Problem Ref. Product Top 5 |
0SRQ_C11_Q1008 |
Problem Sales Org. Top 5 |
0SRQ_C11_Q1009 |
Problem Service Org. Top 5 |
0SRQ_C11_Q1010 |
Problem Service Team Top 5 |
0SRQ_C11_Q1011 |
Problem Sold-To Party Top 5 |
0SRQ_C11_Q1012 |
Problem Duration |
Service Analyses |
|
Strategic Service Planning |
|
CSRVPLAN_Q0101 |
Planned / Actual Comparison |
Service Analyses |
|
Timestamp Service Analysis |
|
0CRM_TSSC_Q0101 |
Performance Key Figure Comparison Table |
0CRM_DTRC_Q0101 |
Processing Lifecycle Performance Analysis |
Entitlement Analyses |
|
Strategic Service Planning |
|
0EA_OVERALL |
Overall Entitlement Report |
0EA_DREAB |
Deposit Refund Entitlement Account Balance |
0EA_DRELR |
Deposit Refund Entitlement Liability Report |
Industry-Specific Analyses |
|
High Tech |
|
Entitlement Management |
|
0HTBPLIC_Q0001 |
Software Entitlements of a Business Partner |
0HTBPLIC_Q0002 |
Software Entitlements of a Group of Business Partners |
Industry-Specific Analyses |
|
Consumer Products |
|
Sales and Marketing |
|
Sales and Trade Promotions |
|
0CP_SLSC1_Q0005 |
Orders/Deliveries/Invoices |
0CP_SLSC1_Q0013 |
Current Orders (Quantities) |
0CP_SLSC1_Q0012 |
Current Orders (Values) |
0CP_SLSM1_Q0009 |
Benchmark Conditions |
0CP_SLSM1_Q0010 |
Benchmark Conditions |
0CP_SLSM1_Q0004 |
Selected Key Figures Benchmark |
0CP_SLSC1_Q0016 |
Contribution Margin 1 |
0CP_SLSC6_Q0010 |
Business Partner for Indirect Promotions |
0CP_SLSC6_Q0002 |
Business Partner Sales and Budget (Planned – Actual) |
0CP_SLSCA_Q0002 |
Business Partner Sales and Budget (SU) |
0CP_SLSC6_Q0009 |
Indirect Promotions |
0CP_SLSCA_Q0009 |
Indirect Promotions (SU) |
0CP_SLSC1_Q0015 |
Cannibalization |
0CP_SLSC1_Q0004 |
Internal Sales |
0CP_SLSC1_Q0011 |
Deliveries/Returns/Credit Memos |
0CP_SLSM1_Q0014 |
Net Revenue: Top N Products |
0CP_SLSC1_Q0010 |
New Products |
0CP_SLSM1_Q0013 |
Plan/Plan Comparison Conditions (%) |
0CP_SLSM1_Q0006 |
Plan/Plan Comparison Conditions |
0CP_SLSM1_Q0012 |
Plan/Plan Comparison Net Revenue |
0CP_SLSC1_Q0006 |
Price Dependency of Sales |
0CP_SLSC6_Q0005 |
Promotion Budget Availability |
0CP_SLSCA_Q0005 |
Promotion Budget Availability (SU) |
0CP_SLSC6_Q0007 |
Promotion Portfolio Analysis |
0CP_SLSCA_Q0007 |
Promotion Portfolio Analysis (SU) |
0CP_SLSC6_Q0006 |
Promotion Uplift (Planned-Actual) |
0CP_SLSCA_Q0006 |
Promotion Uplift (Planned and Actual) (SU) |
0CP_SLSC6_Q0003 |
Regular Sales and Promotion Sales |
0CP_SLSC6_Q0008 |
ROI – Top 10 Promotions |
0CP_SLSCA_Q0008 |
ROI – Top 10 Promotions with Business Partners (SU) |
0CP_SLSM1_Q0011 |
Status Conditions |
0CP_SLSM1_Q0003 |
0CP_SLSM1_Q0003 |
0CP_SLSC1_Q0014 |
Third-Party Business – Quantity |
0CP_SLSC1_Q0007 |
Third-Party Business – Value |
0CP_SLSC6_Q0001 |
Trade Promotion: Scoring: Uplift Factor (Training) |
0CP_SLSCA_Q0001 |
Trade Promotion: Scoring: Uplift Factor (Training) (SU) |
0CP_SLSO1_Q0001 |
Trade Promotion: Scoring: Uplift Factor (Prediction) |
0CP_SLSC1_Q0002 |
Sales Development/Customer by Quarter |
0CP_SLSC1_Q0003 |
Sales Development/Product by Quarter |
0CP_SLSC1_Q0001 |
Sales Development by Month |
0CP_SLSC1_Q0009 |
Sales Deal / Annual Comparison |
0CP_SLSC1_Q0008 |
Sales Deals in a Time Period |
0CSAL_C01_Q0022 |
Previous Months’ Sales Activities |
0CP_SLSC6_Q0004 |
Preliminary Evaluation of a Promotion |
0CP_SLSCA_Q0004 |
Preliminary Evaluation of a Promotion (SU) |
0CP_SLSM1_Q0005 |
Target Conditions |
0CP_SLSM1_Q0001 |
Net Revenue Target |
0CP_SLSM1_Q0002 |
Time Series Conditions |
0CP_SLSM1_Q0008 |
Net Revenue Time Series and Billing Quantity in Sales Units |
0CP_SLSCA_Q0011 |
Channel Peformance by Brand/Category YTD |
0CP_SLSCA_Q0012 |
Promotion Tactic Effectiveness |
0CP_SLSCA_Q0013 |
Brand Performance |
0CP_SLSCA_Q0014 |
Trend in Brand Shipments |
0CP_SLSCA_Q0015 |
Trade Promotions Channel Overview |
0CP_SLSCA_Q0016 |
Brand Promotion Budget Availability |
0CP_SLSM1_Q0031 |
Trade Promotions Currently Running |
0CP_SLSM1_Q0032 |
Current Promotion Product Details |
0CP_SLSM1_Q0030 |
KPI Overview: Promotions, Last 12 Weeks |
0CP_SLSM1_Q0028 |
Promotion Actual Versus Plan, Last Twelve Weeks |
0CP_SLSM1_Q0029 |
KPI Overview Promotions Year-to-Date |
0CP_SLSM1_Q0027 |
Promotion: Actual Versus Plan, Year-to-Date |
0CP_MP04_Q0006 |
KPI Overview Logistics, Last Twelve Weeks |
0CP_MP04_Q0005 |
Logistics Performance Trend, Last Twelve Weeks |
0CP_MP04_Q0003 |
KPI Overview Logistics, Year-to-Date |
0CP_MP04_Q0002 |
Logistics Performance Trend, Year-to-Date |
0CP_MP04_Q0004 |
Logistics Performance by Product, Last Twelve Weeks |
0CP_MP04_Q0001 |
Logistics Performance by Product, Year-to-Date |
0CP_SLSM1_Q0026 |
Revenue and Profit Trend with a Business Partner, Last Twelve Weeks |
0CP_SLSM1_Q0023 |
Revenue and Profit Trend with a Business Partner, Year-to-Date |
0CP_SLSM1_Q0025 |
Actual Versus Plan with a Business Partner, Last Twelve Weeks |
OCP_SLSM1_Q0022 |
Actual versus Plan with a Business Partner, Year-to-Date |
0CP_SLSM1_Q0024 |
Profit and Loss Statement, Last Twelve Weeks |
0CP_SLSM1_Q0021 |
Profit and Loss Statement, Year-to-Date |
Industry-Specific Analyses |
|
Consumer Products |
|
Sales and Marketing |
|
Trade Promotion Management |
|
0CP_SLSC6_Q0010 |
Business Partner for Indirect Promotions |
0CP_SLSC6_Q0002 |
Business Partner Sales and Budget (Planned – Actual) |
0CP_SLSC6_Q0009 |
Indirect Promotions |
0CP_SLSC6_Q0005 |
Promotion Budget Availability |
0CP_SLSC6_Q0007 |
Promotion Portfolio Analysis |
0CP_SLSC6_Q0006 |
Promotion Uplift (Planned-Actual) |
0CP_SLSC6_Q0003 |
Regular Sales and Promotion Sales |
0CP_SLSC6_Q0008 |
ROI – Top 10 Promotions |
0CP_SLSC6_Q0001 |
Trade Promotion: Scoring: Uplift Factor (Training) |
0CP_SLSO1_Q0001 |
Trade Promotion: Scoring: Uplift Factor (Prediction) |
0CSAL_C01_Q0022 |
Previous Months’ Sales Activities |
0CP_SLSC6_Q0004 |
Preliminary Evaluation of a Promotion |
Industry-Specific Analyses |
|
Consumer Products |
|
Sales and Marketing |
|
Syndicated Data |
|
0CP_SLSC3_Q0001 |
Market Share |
0CP_SLSC3_Q0002 |
Retail Sales and (EQU) |
0CP_SLSC3_Q0003 |
Baseline and Incremental Share (EQU) |
0CP_SLSC3_Q0004 |
Baseline and Incremental Share (Sales) |
0CP_SLSC3_Q0005 |
Comparison to Competition – YTD |
0CP_SLSC2_Q0001 |
Pipeline Analysis |
0CP_SLSC2_Q0002 |
Sales Deal Pipeline |
0CP_SLSC2_Q0003 |
Contribution Margin and Market Share |
0CP_SLSC2_Q0004 |
Retail Margin |
0CP_SLSC2_Q0005 |
Stock in ACNielsen Market |
0CP_SLSC5_Q0001 |
Retail Sales and Retail Baseline Sales |
0CP_SLSC3_Q0010 |
Brand: Market Share and Distribution |
Industry-Specific Analyses |
|
Consumer Products |
|
Sales and Marketing |
|
Assortment Agreement |
|
0CP_SLSM2_Q0001 |
Assortment Agreement Benchmark |
0CP_SLSM2_Q0002 |
Assortment Agreement Benchmark – Overview |
0CP_SLSM2_Q0003 |
Status: Distribution and Out-of-Stock |
0CP_SLSM2_Q0004 |
Status: Assortment Agreement |
Industry-Specific Analyses |
|
Consumer Products |
|
Inventory Management |
|
0CP_IC_C1_Q0001 |
Stock Development – Quantity |
0CP_IC_C1_Q0002 |
Stock Development – Value |
0CP_IC_C1_Q0003 |
Stock Development – Consignment Stock |
0CP_IC_C1_Q0004 |
Valuated Average Stock and Warehouse Inventory Turn |
0CP_IC_C1_Q0005 |
Issues versus Stock |
0CP_IC_C1_Q0006 |
Return Deliveries from Warehouse |
0CP_IC_C1_Q0007 |
Stock Corrections |
0CP_IC_C1_Q0008 |
Stock Minimum Previous Two Months |
0CP_IC_C1_Q0009 |
ABC Stock Analysis |
0CP_IC_C1_Q0010 |
Old Stock of Raw Materials and Packaging |
0CP_IC_C1_Q0011 |
Old Stock of Finished Products and Trading Goods |
Industry-Specific Analyses |
|
Consumer Products |
|
Procurement |
|
0CP_PURC1_Q0001 |
Purchase Order/Goods Receipt/Invoice (Quantity) |
0CP_PURC1_Q0002 |
Internal Deliveries |
0CP_PURC1_Q0003 |
Returns to Vendor – Quantities |
0CP_PURC1_Q0004 |
Purchase Orders/Scheduling Agreements |
0CP_PURC1_Q0005 |
Vendor Reliability (Quantity) |
0CP_PURC1_Q0006 |
On-Order Stock |
0CP_PURC1_Q0007 |
Delivery Reliability (Quantity/Date |
0CP_PURC1_Q0008 |
Cost Price Development – Previous Six Months |
0CP_PURC1_Q0009 |
Returns to Vendor – Value |
0CP_PURC1_Q0010 |
Returns to Vendor – Items |
0CP_PURC1_Q0011 |
Purchase Order/Goods Receipt/Invoice (Value) |
0CP_PURC1_Q0012 |
Vendor Overview |
Cross-Scenario Analyses |
|
Installed Base Analysis |
|
Queries for the SAP Enterprise Portal |
|
0CRM_IBCO_Q0101 |
Installed Base Analysis by Location |
0CRM_IBCO_Q0104 |
Installed Base Analysis by Business Partner |
0CRM_IBCO_Q0102 |
Analysis of Products in Installed Bases |
0CRM_IBCO_Q0103 |
Analysis of Individual Objects in IBase Components |
Cross-Scenario Analyses |
|
Installed Base Analysis |
|
0SAL_DS01_Q0005 |
Activities by Category |
0CSAL_C01_Q0004 |
Active/Passive Analysis |
0CSAL_C01_Q0023 |
Activities/Items per Activity Partner |
0SAL_DS01_Q0002 |
Activities per Category (Employee Responsible, Document Level) |
0CSAL_DS01_Q004 |
Activity Details |
0CSAL_C01_Q0016 |
Activity History |
0CSAL_C01_Q0021 |
Activity Partner with Open Activities |
0SAL_DS01_Q0003 |
Activity Partners w/ Open Activities (Employee Resp, Doc. Level) |
0SAL_DS01_Q001 |
Date of Last Activity |
0SAL_DS01_Q0010 |
Date of Next Activity |
0CSAL_C01_Q0005 |
Distribution of Activities per Organizational Unit |
0CSAL_C01_Q0003 |
Intensity of Customer Care (Activity Partner) |
0CRM_C01_Q0018 |
Intensity of Customer Care by Employee (Sales Manager Portal) |
0CSAL_C01_Q0019 |
Intensity of Customer Care by Partner (Sales Manager Portal) |
0CSAL_C01_Q0001 |
Intensity of Customer Care (Employee) |
0CSAL_C01_Q0002 |
Intensity of Customer Care (Owner) |
0SAL_C01_Q0009 |
Last 20 Closed Activities |
0CSAL_C01_Q0013 |
My Team’s Planned Activities |
0CSAL_C01_Q0020 |
Number of Activities per Category |
0CRM_C08_Q0002 |
Number of Samples Distributed in Current Year |
0CRM_C08_Q0003 |
Number of Samples per Batch and Contact Person |
0CRM_C01_Q0017 |
Planned Activities |
0CRM_C08_Q0001 |
Pre-Sales Investment in Activity Partner |
0CSAL_C01_Q0022 |
Previous Months’ Sales Activities |
0CSAL_C01_Q0006 |
Success/Failure Analysis |
0CSAL_C01_Q0015 |
Success/Failure Analysis (Sales Manager Portal) |
0CSAL_C01_Q0024 |
Activities (One Order and Interaction Objects) per Campaign |
Cross-Scenario Analyses |
|
Billing Analysis |
|
0BE_C01_Q0001 |
Number of Billing Documents |
0BE_C01_Q0002 |
Canceled Billing Documents |
Cross-Scenario Analyses |
|
Case Management Analysis |
|
0CRM_CMG2_Q0102 |
Controlling Analysis for Cases |
0CRM_CASE_Q0101 |
Case Workload Analysis |
0CRM_CASE_Q0102 |
Analysis of Sensitive Cases |
0CRM_CASE_Q0103 |
Planned Date of Case Closure |
0CRM_CMGL_Q0101 |
Case Relationship Analysis for Linked Business Partner |
0CRM_CMGL_Q0102 |
Case Relationship Analysis for Linked Products |
0CRM_CMG1_Q0101 |
Case Escalation Analysis |
0CRM_CMG2_Q0101 |
Status Overview for Documents in Cases |
Cross-Scenario Analyses |
|
CRM Incentive and Commission Management |
|
0CRM_ICC1_Q0101 |
Commissions on Level Sales Rep./Sales Manager |
0CRM_ICC1_Q0103 |
Commissions Overview Year to Year |
Advantages
- Reporting Directory contains technical names of all standard content queries which can help BI Reporting Consultants for prototyping purpose.
- This directory categorizes information according to each functional area which can directly be mapped to business requirement.
- This can serve as a lookup guide while gathering requirements for SAP BW-CRM reports from business users during Blueprinting phase of the project.
Related Content
http://help.sap.com/saphelp_nw70ehp2/helpdata/en/04/47a46e4e81ab4281bfb3bbd14825ca/frameset.htm
http://help.sap.com/saphelp_nw70ehp2/helpdata/en/04/47a46e4e81ab4281bfb3bbd14825ca/frameset.htm
http://help.sap.com/saphelp_nw70ehp2/helpdata/en/43/f67b4070ebd462e10000000a155106/frameset.htm
Good Work. Thanks for sharing.
HI,
I am searching for standard data source & queries for DSD (Direct Store Delivery). In ECC we do have view /DSD/CV_VP. I could not find standard content for this. Do we have to make generic for that?
Your reply is highly appreciated.
Thank You