Excel ( VB ) to ABAP RFC WEB SERVICE Call - No Errors - Blank Output Table

[Former Member]

Trying to get Excel talk to ABAP RFC Web Service.

- Excel - 2007 ( Since it is Excel 2007, I didn't had to add any Office Web Services Toolkit or any add on )

- ECC 6.0

Excel (VB) not throwing any error, but is not giving any output ( expecting a table output ).

ABAP RFC WebService with Uid Pwd Authentication.

Activated binding for ABAP RFC via SOAMANAGER for clnt 600.

Using WSDL of WS of Clnt 600 in Excel via VB

Basic ABAP RFC -

1 optional import param ( Input Param )

1 table output ( Tables Param )

Basic VB Call Code -

Call projHoursWS.wsm_YProjHours("", arProjHours)

To test if VB and WebService are talking to each other, when i temperorarily change the Authentication method ( uid/pwd ) of Webservice in Sicf it throws "NO MATCHING AUTH" .. So VB and ABAP WS are talking to each other.

Debugged VB in Excel, not throwing any error , but is always returning the output table (arProjHours) Empty.

Missing anything?

[Former Member]

Hi,

Try turning on the ICF Recorder in TCode SICF (check SAP Help for usage details) to establish that the request is reaching SAP successfuly.

You'll also be able to catch the response that's being generated by SAP this way. Then turn off the ICF recorder.

Best Regards, Trevor