How to get data's from third party system to Abap reports by calling SAP PI interface

[former_member209211]

Hi Guru's

I have an requirement to create a report with data's from sap and third party system by calling the sap pi interface to fetch data from third party system for the report and process the data in the report.

Thanks in Advance

Ejas

[gagandeep_batra · Accepted solution]

Hi Ejas,

For that you have to create a proxy from ecc side and check how can you connect the third party system.. JDBC,or file or something else.

Regards

GB

[former_member209211 · Accepted solution]

Thanks GB,

Interface is working and I am able to get data when we test the interface separately in SPROXY but I want the data fetched by the interface to be used in the reports by directly calling the interface in the reports like a Functional module in reports

[former_member192343 · Accepted solution]

Call proxy class from report and process the response.

[former_member209211 · Accepted solution]

Thanks MK

I was able to call proxy class outbound and provide the input but we are not able to capture the data fetched by the proxy in the report can you explain how to capture the response of the proxy in the report.

Thanks in Advance

Ejas

[former_member192343 · Accepted solution]

you need to set importing parameters

[former_member192343 · Accepted solution]

Report Z_CREATE_CALL.

DATA:     l_customer_name TYPE z##_custumer_name.
DATA:     l_customer_info TYPE z##_custumer_info.
...
Try.
CALL METHOD Z##_CO_CUSTOMER_INFORMATION_RE=>SYNCHRONOUS
 EXPORTING
 OUTPUT = l_customer_name
 IMPORTING
 INPUT = l_customer_info.

Catch CX_MISSING_INFORMATION into ...

[Former Member · Accepted solution]

Hi Ejas,

Create the outbound synchronous interface in PI.

Thane generate the client proxy method in your ABAP system out of synchronous outbound interface which in turn will generate respective exporting and importing parameters. Use TCode-SPROXY.

Then call the above created method in your ABAP report, pass exporting and importing parameters to it. You can see/capture the interface response in the importing parameters.

Regards,

Amit Patil

[former_member209211 · Accepted solution]

Thanks MK.

I am able to create interface and call method but the synchronous option is not available can you help on this 

Thanks in Advance

Ejas

[former_member192343 · Accepted solution]

You need to generate synchronous outbound proxy.

Service interface should have synchronous mode in ES Builder, then it wil be generated as synchronous in sproxy.

[former_member209211 · Accepted solution]

Thanks MK

Outbound Service Interface Mode is synchronous mode only

Thanks in Advance

Ejas

[former_member192343 · Accepted solution]

So what do you mean about "but the synchronous option is not available "?

[former_member209211 · Accepted solution]

Thanks MK,

when creating a call method pattern below is what i get selecting the interface and method

*TRY.

CALL METHOD me->SI_SC_REQUEST

   EXPORTING

     OUTPUT =

*  IMPORTING

*    INPUT  =

     .

* CATCH CX_AI_SYSTEM_FAULT .

* CATCH CX_AI_APPLICATION_FAULT .

*ENDTRY.

this is the code i get in the program after selecting the methods

Please help on this

Thanks in Advance

ejas

[former_member192343 · Accepted solution]

Ah, ok. My example was from old course. In new versions calling is little different, you need to set input structure for response.

[former_member209211 · Accepted solution]

Thanks MK

It has solved thanks for the support.