专栏首页Jerry的SAP技术分享SAP CRM BW Report的工作原理分析

SAP CRM BW Report的工作原理分析

Keys->Content Assist, 默认是Shift + Tab:

Guys, we don’t need to remember all possible values for a given annotation, just use Ctrl+space or your customized hot key to trigger auto completion, just as the same way you did in SAP GUI:

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.

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

我来说两句

0 条评论
登录 后参与评论

相关文章

  • How to resolve error message Distribution channel is not allowed for sales

    I try to download customer material info record from ERP via request download. ...

    Jerry Wang
  • SAP CRM的订单模型移植到S4HANA后,在订单保存功能上作出的改进

    Once an order is saved, our new event callback CRM_SRVO_H_SAVE_EC will be called...

    Jerry Wang
  • SAP CRM Relationship API设计原理

    Unlike settype, relationship does not have a dedicated read function module main...

    Jerry Wang
  • Account group in ERP and its mapping relationship with CRM partner group

    When you create a customer in VD01, you need to specify one account group. In th...

    Jerry Wang
  • 错误消息Number not in interval XXX when downloading

    I have created one Sales customer via tcode VD01 in ERP:

    Jerry Wang
  • 软件构建中的设计

    设计中的挑战 1、设计是一个险恶的问题:只有通过解决或部分解决才能被明确的问题 (Tacoma Narrows大桥,空气动力学) ? 2、设计是一个了无...

    java达人
  • 一个简单的例子理解Kubernetes的三种IP地址类型

    很多Kubernetes的初学者对Kubernetes里面三种不同的IP地址和工作机制理解得不是很清楚。

    Jerry Wang
  • Rego的第二个设计原则:接受分层数据

    这是关于Open Policy Agent(OPA)策略语言Rego背后的设计原则的博客系列的第二部分。前面我们描述了如何将Rego的语法设计为反映真实策略的结...

    CNCF
  • 程序员最害怕的五件事

    软件开发通常被认为是一个相当体面的工作,有很好的工资待遇,工作具有挑战性,目前市场对程序员的需求量在增加,而且工作环境很安全。但是所有的这些并不意味着开发人员无...

    程序员互动联盟

扫码关注云+社区

领取腾讯云代金券