About this document:

Recently we used the Cloud Data Source to upload sales information from ERP for analytic purposes. This guide includes the key configuration required in C4C, NW PI, and ERP.  This guide assumes you know NW PI.  It provides screenshots of all the major steps

Architecture

Step 1 : Design the Cloud data source for “ZTEST01”

Step 2 : Download the WSDL

  1. Administrator –>  Communication Arrangement –> Select the scenario.

    B. EDIT –>  Technical Data –> Edit Advance Settings

Step 3. Generate Interface for the Analytics Upload :

  1. Upload the Analytic WSDL of step 2 in PI ESR.

    2. Create the Data Type, Message Type, and Service Interface for the ERP ABAP proxy.

         This is a synchronous ABAP proxy.

Data Type Request :


Data Type Response:

Message Type Request:

Message Type Response:

 

Service Interface : Proxy is generated over this Interface : OS_ERPInfocube_Request


    IS_AnalyticsUploadRequestResponse

  1. Operation Mapping :

XSLT mapping which will convert the xml to csv format accepted by cloud

Integration Scenario

Step 4 : Generate

ABAP Proxy

SPROXY –>

Step 5: Build ABAP report to send the data to C4C

Call to ABAP proxy in report

Test the scenario via ABAP report

Execute the report that will make a call to ABAP Proxy and response message from C4C back will be sent to the ERP system.

T-Code : SXI_MONITOR

Request Message sent via SOAP to the C4C:

Response Message from the C4C:

SOAP UI Integration

I have used SOAP UI tool as well to test the integration to check, if I can upload the data using web service.

  1. Download Analytics WSDL from the C4C.
  2. Create project and upload the WSDL.
  3. Upload the client certificate of C4C in SOAP UI.
  4. Test the scenario
To report this post you need to login first.

10 Comments

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

  1. Francesco Velluto

    Hi Rishabh,

    nice blog. Would be useful insert also a screenshot of the request data type on PI-C4C side. I know there’s a screenshot of the request message after mapping but it’s very little and it’s difficult to read content.

    Many Thanks,

    Francesco

    (0) 
    1. Rishabh Dubey Post author

      Hi Francesco,

      Thanks for the comment. Once I am back to my system, will upload the screen-shot of the AnalyticsUpload WSDL. I suppose that’s what you meant ??

      Cheers

      Rishabh

      (0) 
  2. Tim Chang

    Great to see this blog.

    I’m still looking for a way in the webservice to change the delimiter from “:”. in the <Data> payload

    Have you come across this issue ?

    (0) 
      1. Tim Chang

        I meant to say the webservice requires one to use the semi-colon (;).  I like to see how to change that to use another character as a better delimiter, but I don’t seem to see this anywhere.

        (0) 
      2. Ritesh Nasikkar

        HI Rishabh/Tim,

        We have HCI middleware and we do not have PI middleware, please let us know how we can achieve this scenario. Our C4C is integrated to SAP ECC through HCI middleware and we have requirement to bring Sales order LIS info structure from ECC to C4C like S503 you r using in your above blog.

        Please let us know at the earliest.

        Regards

        Ritesh

        (0) 

Leave a Reply