Skip to Content

There are 11 BW blocks in the Account Fact Sheet.Each BW block has a unique BI report ID.

Block

BI report ID

Last Closed Activities

0TPLB_0CSAL_C01_Q0009_1

Account Classification

0TPLB_0BP_C00_Q0002_1

Account Revenue (Graph)

0TPLB_0CRM_FSC1_Q0002_1

Account Revenue (Table)

0TPLB_0CRM_FSC1_Q0002_2

Sales Pipeline

0TPLB_0CSALMC02_Q009_V01

Backorders

0TPLB_0CRM_SALO_Q001_1

Service Overview

0TPLB_0CSRVMC01_Q0101_V01_FS

Top 5 Products for Previous 12 Months

0TPLB_0CSRVMC02_Q0107_V01_FS

Customer Service

0TPLB_0CRM_FSC1_Q0001_V01_FS

Customer Attributes

0TPLB_0CRM_SOLDTO_Q0001_V01

Expiring Service Contract Items

0TPLB_0CSAL_C07_Q0107_V01_FS

Defining the BI reports in the Customizing System

  • Launch the Transaction CRMC_UI_BI in the customizing system.

Define the all the 11 BI reports…

IMAGE1.png


Defining the Assignment Blocks of the Account Fact Sheet overview

  • Open the transaction SM34 and enter the View Cluster name as BSPVC_DLC_FS and click on Display.
  • Select the BP_ACCOUNT_FACTSHEET and double click on View Assignment

IMAGE2.png

  • Click on the Change icon and maintain the View Assignments. The assignments that are maintained in this View will display
    as assignment blocks in Account Fact Sheet overview.

Maintaining the Account Fact Sheet overview configuration.

The Framework provides a component for the Account Fact Sheet overview configuration.

The Views that have been maintained in the BSPVC_DLC_FS view cluster under the Fact Sheet ID BP_ACCOUNT_FS
will be available in the configuration of the Framework component BSP_DLC_FS.
Hence they can be configured in the configuration of the BSP_DLC_FS/factsheet view of the BSP_DLC_FS component.

  • Open the Component BSP_DLC_FS in the development system.
  • Open the view BSP_DLC_FS/factsheet
  • Go to the configuration of that view.
  • Select Fact Sheet as “Account Fact Sheet” and Role Key as “<DEFAULT>”
  • Click on Continue.

IMAGE3.png

  • For the BW assignment blocks select the BI Report views from the Available Fact Sheet views and move it to the Assigned
    Fact Sheet Views. One view can be assigned multiple times with different Title.
    For the 11 BW blocks the BI Report has to be moved to the Assigned Fact Sheet
    Views 11 times with each having different Title

IMAGE4.png

  • Click on the Show Technical Details button to display the technical details and make not of the Usage Counter of every block.

IMAGE5.png

Maintaining the Configuration of BW views in BP_FACTSHEET view

The BP_FACTSHEET component is the Account Fact Sheet component.

  • Open the Component BP_FACTSHEET
  • Open the view BP_FACTSHEET/BIReportProxy
  • Go to the Configuration of the view BP_FACTSHEET/BIReportProxy.
  • The configuration of the view is provided by the Framework
  • For each of the BW view one configuration needs to be created with the following parameters

      Role Key =
     <DEFAULT>

Component
Usage = Concatenation of BP_FACTSHEET and the Usage Counter of the Block in the configuration of BSP_DLC_FS component

(e.g. Component usage for Last Closed Activities = BP_FACTSHEET0010)

Object Type = BP_ACCOUNT_FS

Object Sub Type = <DEFAULT>

  • Once the configuration is created click on the Attributes button on the configuration.

IMAGE6.png


  • Enter the REPID as the BI Report ID of the corresponding BW view
  • Enter the ADDPARAMETER as the String &filter_iobjnm_1=&1&filter_value_1=&2&filter_iobjnm_2=&3&filter_value_2=&4

Here &1 is the name and &2 is the value of the first input parameter of the BI report.

The string will vary depending on the number of the input parameters of the corresponding BI report.e.g. for a BI report that takes 3 input parameter the
string will be &filter_iobjnm_1=&1&filter_value_1=&2&filter_iobjnm_2=&3&filter_value_2=&4&filter_iobjnm_3=&5&filter_value_3=&6

IMAGE7.png

Same procedure needs to be followed for all the other BW views.

IMAGE8.png

Passing the input parameter value to the BI reports

  • Go to the IF_EX_BSP_DLC_FS~GET_BI_REP_PARAMETER method of the Enhancement Implementation BP_FACTSHEET  of the BAdI BSP_DLC_FS_BADI

IMAGE9.png

In this method the code has to be written in order to pass the value of the parameters to the BI reports of the Account Fact Sheet overview.

This method has been called in the INIT_BI_CONTEXT method of the controller class of the component controller of the BP_FACTSHEET component.

Now inside this BADI a new when clause has to be maintained for the case statement which will pass the input parameters for the newly created BI Report.

Here below mentioned is the sample implementation for that:

Suppose you have a BI report which accepts just one filter parameter, then in the configuration you will maintain it as the string given below:

&filter_iobjnm_1=&1&filter_value_1=&2

First one ‘ &1’ is the parameter name on the BI report and the ‘&2’ second one is the parameter value that we need to pass into the report.

BI repoRt name should be replaced with your report name.

cv_add_parameter
will have the string maintained in the customizing i.e &filter_iobjnm_1=&1&filter_value_1=&2.

Now just replace &1 with object name and &2 with the value.

Repeat the same if the report has multiple values.

          WHEN ‘BI report name’.
*         first add business partner number to parameters

            REPLACE ‘&1’ IN cv_addparameter WITH ‘0BP_ACTIVIT’.

            REPLACE ‘&2’ IN cv_addparameter WITH lv_bp_id.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Thea Raubinger

    Hi,

    Thank you for your summary and this very nice HowTo.

    I am somehow not able to assign a view to the Factsheet multiple times. Once I move the “Available Fact Sheet Views” BP_FACTSHEET/BIReport to the “Assigned Fact Sheet Views” the view is no longer available.

    If I try to add the view BP_FACTSHEET/BIReport multiple times to my fact sheet id in the view cluster BSPVC_DLC_FS I have to differentiate the entries by the inboundplug.

    Do you have a special system setting or how can you have this multiple entries at a time?

    Best regards,

    Thea

    (0) 

Leave a Reply