SAP PI系统关于接口清单和接口通量的自定义视图

        根据实际业务需要，在SAP PI系统上做了两个视图：一个是基于IC的接口清单，另一个是按照接口每日统计的接口通量(包括访问量、数据包大小)。将这两部分数据通过接口推送到第三方云平台上进行PO数据大屏的展示。

drop view gd_ic_list;
/*
 创建intergrated configration List 视图 gd_IC_LIST
*/
create view gd_ic_list as (
	select  A.FROMSRVC	 AS FROM_SERVICE,		-- 发送方系统
			A.ACTIONNAME AS FROM_ACTIONNAME,	-- 发送方接口ID
			A.ADAPTERTYPE AS FROM_ADAPTERTYPE,	-- 发送方接口适配器类型
			B.TOSRVC	  AS TO_SERVICE,		-- 接收方系统
			B.ACTIONNAME  AS TO_ACTIONNAME,		-- 接收方接口ID
			B.ADAPTERTYPE AS TO_ADAPTERTYPE,	-- 接收方接口适配器类型
			c.text		  as IC_text			-- IC Receiver Description
		from XI_AF_CPA_BINDING as a 
			 	inner join XI_AF_CPA_BINDING as b
			on a.A1_OBJECT_ID = B.A1_OBJECT_ID
		   AND A.DIRECTION	  = 'I'
		   AND B.DIRECTION	  = 'O'
		   		left join XI_DIR_TXTSHT_SYNC as c
		   	on a.object_id = ABAP_LOWER( c.objectid ) -- 需要注意id 的大小写
		    );


/*
  删除接口通量视图 gd_XI_FLUX
*/
drop view GD_XI_FLUX;

create view GD_XI_flux a