A Composite Application using CE VC 711 and Enterprise Services with Clustered Input

[Former Member]

The intent of this blog is to share the experience of how Visual Composer (CE 7.1.1 version) is used to develop a composite application with two SAP Enterprise Services from a PI 7.1 Service Registry.  The purpose of the application is to search for Batch ID’s of specified Material Number and Plant Code, and display detail of a selected Batch ID from the list. 

The application allows the user to enter a material number and a plant code.  Then it would call the first service BatchSimpleByElementsQueryResponse_In with the material number and plant code and display the result as a list of batch ID’s.  Then when user selects a Batch ID in the list the detail of the Batch would be displayed by calling the second service BatchByIDQueryResponse_In.

Below steps with screen shots explain how this application was created using VC 7.1.1.

1. Start a new model using the Composite View.
   
   
   
2. Search for the services from the Service Registry.
   
   
   
3. Create a Data Service for the 1st service and select needed data from the In/Out Ports.
   
   
   
   
   
   
   
   
   
   
   
4. Add a Form View by dragging from the In Port of the Data Service.
   
   
   
   
   
   
   
5. Define Data for the Data Share s1.
   
   
   Add one row for each of the two recordsets using the Initialize Data button.
   
   
   
   
   
   
   
6. Add Table View for each of the two recordsets in Data Share s1.
   
   
   
   
   
   
   
   
   
   
   
7. Connect Out Port of the two Table Views to the In Port of the Data Service.
   Make sure the Event name is set to “insert” and the Select mode is set to “All data rows”.
   
   
   Then configure the data map.
   
   
   
   
   
   
   
   
   
   
8. Adjust the View’s Layout as appropriate.
   
   
   
9. Add a Table View by dragging from the Out Port of the Data Service.
   
   
   
   
   
   
   
10. Create another Data Service for the 2nd service and select needed data from the In/Out Ports.
    
    
    
    
    
    
    
11. Connect the Out Port of the Table View of the 1st data service to the In Port of the 2^nd data service.
    
    
    
12. Map the data between the table view and the 2^nd data service.
    
    
    
    
    
13. Add a Form View to display the response data from the Out Port of the 2^nd data service.
    
    
    
    
    
    
    
14. The whole picture of the Composite View.
    
    
    
15. Deploy.
    
    
    
16. Test run the application.
    
    
    The input, enter the Material Number and the Plant Code:
    
    The output, select one Batch ID from the list of Batches and the Batch detail is displayed:

This Composite View is composed of two data services, two form views, three table views, and absolutely no coding.  The biggest challenge to me was to figure out how to call the first service BatchSimpleByElementsQueryResponse_In that has clustered data structure for the input data.   I have searched in SAP SDN for examples or discussions without much luck.  Hope this blog will save a little time for others who will implement something similar.