I’m glad to share with you one of the tools that bring me a lot of satisfaction with the creation of rapid reports with BCV (NWBC) in SAP PPM.

This is a real solution for Contextual reports, where the users access to an individual Portfolio Item that they need to know the status of that Portfolio Item.

This BCV report has been taken me more than two months to create it. So I reproduce separately in eight (8) steps that you need to made for a successfully report.


SAP BCV: Business Context Viewer is a framework that allow all SAP Business Suite applications to integrate different kinds of additional information into the context of their applications. Inthis example will show you more information for Portfolio Item in SAP PPM with NWBC.

The report will look like this:

/wp-content/uploads/2014/10/graph1_557924.jpg

  • Step 01) Create Structure Table (Tr. SE11). This structure it’s how you would show data fields on BCV report. This table will be very important to show fields that you want to complete with data in program to view in BCV report.

        /wp-content/uploads/2014/10/graph2_557925.jpg

    • Example Table: ZSDPR_DATA_WF_DET
  • Step 02) Create Report Program (Tr. SE38). This program will get data to complete the data structure. It’s very important to put parameters and body program between arguments <QUERY_HEAD> and <QUERY_BODY> then be careful because <QUERY_BODY> has to finish with the “ENDLOOP” to complete data into structure and show data at BCV report.
    • Program query body detail:

                PARAMETERS:     p_guid   TYPE rpm_tv_guid,

                                               p_extui  TYPE dpr_tv_name,

                                               p_vers   TYPE version_number,

                                               p_portid TYPE /rpm/tv_guid.

               *<QUERY_HEAD>

               *write all your body program.

               LOOP AT IT_TABLE_RESULT.

               *!! the following commet MUST NOT BE CHANGED !!

               *<QUERY_BODY>

               ENDLOOP.

    

    • Example Program Name: ZDPR_DATA_WF_DET_RES_ITEM
    • This program it’s optional, because you can make a simple query report with table links.
  • Step 03) Create an InfoSet (Tr. SQ02).
    • Using the created structure table ZDPR_TASK_ITEM
    • Program ZSDPR_DATA_WF_DET_RES_ITEM
    • Using Parameters from program
      • P_GUID
      • P_PGUID
      • P_EXTUI
      • P_VERS
      • P_PORTID
    • User Group: ZDPR_GR_BCV
    • Example InfoSet Name: ZDPR_INFOSET_TAREA_ITEM
  • Step 04) Create Query (Tr. SQ01).
    • Using InfoSet ZDPR_INFOSET_TAREA_ITEM
    • Select fields for view data and parameters
    • Example Query Name: ZDPR_TASK_DEV.
  • Step 05) Create Connector (BCV Initial Home Page).
FIELDS
SEMANTICS
P_EXTUI 1DRP_PROJ_ID
P_PGUID 1RPM_OBJECT_GUID
P_PORTID 1RPM_PARENT_GUID
P_VERS 1DPR_TASK_ID
    • Example Connector Name: ZDPR_TASK_DEV.
  • Step 06) Create BCV Query (BCV Initial Home Page)
    • Access to BCV query with two alternatives:
      • SPRO –> Cross-Application Components –> Processes and Tools for Enterprice Applications –> Business Context Viewer –> Query Management –> Define BCV Queries
      • URL –> http://yourserver.com:8000/sap/bc/webdynpro/bcv/wda_cfg_entry?sap-client=200&sap-language=EN
    • Key Context: 1RPM_ITEM
    • Search Connector: ZDPR_TASK_DEV
  • Step 07) Create Query View (BCV Initial Home Page)
    • Access to BCV query view with:
    • Table –> TABLE_ZDPR_DATOS (same as BCV Query)
    • Query BCV ID: ZDPR_DATOS_DET_RES_WF
    • User Group Authorization –> Type the created User group for this BCV report.
    • Chart ID (Diagram)
      • Technology: 1BUSGRAPH
      • Diagram Type: 1COLUMN

               /wp-content/uploads/2014/10/graph3_558679.jpg

               /wp-content/uploads/2014/10/graph4_558695.jpg

    • Query View Name example: ZDPR_DATOS_RES_WF

Also I recommend you to visit the folow sites:

Hope this help you.

Best regards,

Mariano

To report this post you need to login first.

1 Comment

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

  1. Arbind Prasad

    Hello Mariano,

    Many Thanks for this wonderful post. 🙂

    The detailed process is really helpful to have a customized BCV Report.

    Best Regards

    Arbind

    (0) 

Leave a Reply