SAP CRM BW Report的工作原理分析

CRM Interactive (OLTP) Reporting: very old stuff started in 2006 with CRM 5.2.

With this approach, no separate SAP BI system was required for basic operational / transactional CRM reporting. Instead, the SAP NetWeaver stack that comes with SAP CRM could be used in order to run real-time operational CRM reports directly on the CRM implementation.

Prerequisites

You have set up a client for processing BI Content in SAP CRM. This can be the same client as the one that contains the data for report creation.

The data displayed in an interactive report depends on the user's position within the organizational model. For example, the reports of a sales employee only contain data for opportunities for which he or she is responsible. However, a manager can see data for all opportunities for which the sales employees in the manager's organizational unit are responsible.

Report Areas for Interactive Reports Based on SAP HANA VDM

How it works

When you make some related fields in CRM and save, FM CRM_UPLOAD_BW will be called:

check this structure: BAD_BUS_TRANSN_MESSAGE

and this FM: /1CRMGC/BUS_TRANS_MSG_BWA ( constant of site id defined there )

table SMOXSTAT: defintion for all data sources table SMOXRELP_S: definition of fields for datasource...

important mapper: CRM_BW_SERVPRO_H_MAP

This mapper is called before data is sent to BW.

Read

In read scenario, why destination is QDD?!

0CRM_SRV_PROCESS_H or /CRMBW/OLTP_SRV_ORDER?

outbound BW destination: table roosprmsf

tcode RSA2, DS name: 0CRM_SRV_PROCESS_H

Jerry founds two different kinds of Data source in tcode RSA5 !!

Jerry assumption: one of them is for BW report, and the other is for CRM Interactive Report

table for Interactive report destination: rslogsysdest

relationship between data source and query?

tcode RSRTQ, query name: /CRMBW/SVO_C01_Q0001:

How number of Open Service Order is modelled in BW report:

It works but how? Debug RSOA_DSOURCE_READ_REMOTE_DATA.

index table? CRMD_DHR_HSRVORD

Strange! the order created by report CRM_ORDER_CREATE_SRVO is not put into that table, but if I create order in WebUI, the corresponding entry is in that table. Why?

I made a lot of trace trying to figure out who has filled this buffer table under the hood for us?

I found an intresting tcode CRMD_FILL_CACHE :)

and tcode for One order document mass creation: CRMD_1O_MC

Check customizing in CRM Analytics->Interactive Reporting->Cache management

2268061 - The table CRMD_DHR_ISRVORD is empty #SAPCRM

this report: CRM_REPORT_CACHE_STAT

note 2090500 - Transaction CRMD_FILL_CACHE not filling all entries into cache tables

The buffer tables are used only for interactive reporting and not by any other application. We need not fill the buffer tables explicitly with the data, The required data gets filled at run time as and when you execute the interactive reports. The buffer tables are supposed to have only the required data and not the whole data that is present in the document tables, then there will be no point for having seperate buffer tables , we can as well fetch it from document tables.

The maximum amount of entries for a cache table can be seen in the customizing table CRMC_Q1O_CACHE.