SAP CRM Interactive Report(交互式报表)里和服务订单相关的一些字段-阿里云开发者社区

开发者社区> jerrywangsap> 正文

SAP CRM Interactive Report(交互式报表)里和服务订单相关的一些字段

简介: SAP CRM Interactive Report(交互式报表)里和服务订单相关的一些字段
+关注继续查看

Recently I am working on CRM Interactive Report and I was quite confusing about the difference between these two key figures below:


image.png


This report is created based on Reporting Area: ServiceOrder

The technical name for “Gross Value of Service Orders”: /CRMBW/SVO_GV

“Gross Value Header”: /CRMBW/GV_SVOH



image.png

From this customizing I know the cache table to display report key figure values for Service Order is: CRMD_DHR_HSRVORD


image.png



However in this table there is only one field GROSS_VALUE_H, and how can this single field serve two key figures mentioned in the title of this blog?


image.png


Via debugging I have figured out how the key figure values are retrieved from database table and rendered in WebUI.


It consists of two steps:


(1) the guid of orders which fulfills the specified search criteria in WebUI is fetched from CRMD_ORDER_INDEX via reporting framework API CRM_BSP_OIC_1O_SEARCH_FROM_RF.


I write a simple report to simulate the call sent from Reporting UI:

image.pngimage.png

Execute the report, in my system for posting date 2015.01.27, there are five Service Orders & Service Confirmation:

image.png



(2) Buffer table CRMD_DHR_HSRVORD is then read with the guid fetched from step1, and key figure calculation is done in BAdI implementation class CL_CRM_RFQ1OCALC_STATUS_COMMON.

In line 638 the logic is clear: the gross value of Service Order key figure is only accumulated when the given order is a Service Order ( object_type = ‘BUS2000116’ ).

image.png



This BAdI is called within OLTP extractor belonging to Service Order Reporting Area: /CRMBW/OLTP_EXTRACT_SRV_ORDER


image.png


As a result I can now continue with my simulation report to calculate these two key figures with the same logic:

image.png

Now execute the report, and you can get the same calculated value as you see in WebUI for posting date 2015.01.27:


image.png


Alternatively I have written another report which calls the Reporing framework API from a higher level. The two steps mentioned above are embedded within API RSOA_DSOURCE_READ_REMOTE_DATA.

image.pngimage.png

Of source the response stored in l_t_container has compressed format, which could be parsed by the corresponding program specified in variable l_program.


image.png


The name of this program could be read from function module RSAR_ISOURCE_MD_T_GET. See the following report as an example:

image.png

The program name to parse the reporting response into ABAP format is stored in variable l_s_ts:

image.png

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
SharePoint 向多行文本类型字段插入特殊类型链接
  1、在测试列表中插入一个多行文本字段,名字叫做Content,如下图:   2、在Content字段里,添加一个Link,如下图:   3、尝试输入Notes格式的Link,如下图:   4、点击OK的时候,弹出消息框,如下图:   5、也许有人说,可以直接编辑多行文本的...
602 0
阿里云服务器怎么设置密码?怎么停机?怎么重启服务器?
如果在创建实例时没有设置密码,或者密码丢失,您可以在控制台上重新设置实例的登录密码。本文仅描述如何在 ECS 管理控制台上修改实例登录密码。
10088 0
【oracle】字段不为空时修改字段类型
字段不为空时修改字段类型
1531 0
Oracle 查询对应表所有字段名称,可排除不想要的字段
由于Oracle varchar类型长度限制为4000 ,以下方法仅支持查询字段拼接后长度小于等于4000 第一种方法 select wm_concat(column_name) from user_tab_cols where table_name = upper(...
1070 0
数据库设计之数据库tinyint字段与Int字段的使用
SQL SERVER中的tinyint:从 0 到 255 的整型数据。存储大小为 1 字节。 SQL SERVER中的Smallint: 存储大小为 2 字节。
774 0
阿里云服务器如何登录?阿里云服务器的三种登录方法
购买阿里云ECS云服务器后如何登录?场景不同,阿里云优惠总结大概有三种登录方式: 登录到ECS云服务器控制台 在ECS云服务器控制台用户可以更改密码、更换系.
13891 0
SQL AUTO INCREMENT 字段
1、用于 SQL Server 的语法 下列 SQL 语句把 "Persons" 表中的 "P_Id" 列定义为 auto-increment 主键: CREATE TABLE Persons ( P_Id int PRIMARY KEY IDENTITY, LastName varchar(255) NOT NULL, FirstName varchar(255), Ad
813 0
SAP S/4HANA生产订单抬头字段的维护
SAP S/4HANA生产订单抬头字段的维护
11 0
解决Druid设置Oracle的Clob字段时的小坑
众所周知,Oracle有很多坑, 所以才有了去IOE。 在使用Druid做数据库连接池后,其实偶尔也会碰到小坑,这就是使用开源项目所必须去填平的。【如果使用不开源的产品,那就不是坑,而是陷阱了,你都不知道怎么去填坑】 用Druid连接池,通过JDBC往Oracle数据库的Clob字段插入数据,或者更新数据时,一个问题出现了。
2021 0
+关注
2628
文章
0
问答
来源圈子
更多
+ 订阅
文章排行榜
最热
最新
相关电子书
更多
《2021云上架构与运维峰会演讲合集》
立即下载
《零基础CSS入门教程》
立即下载
《零基础HTML入门教程》
立即下载