Skip to main content
Participant
September 22, 2008
Question

Consuming SAP web services with tables

  • September 22, 2008
  • 1 reply
  • 1479 views
I'm doing kind of feasibility study on consuming SAP web services from CF.
So far so good, but I'm stuck dealing with tables (import/export parameters in SAP world).

I know how to receive a table object from SAP functions:
* With Apache Axis v1.2: pass an empty CF structure as a parameter
* With Apache Axis v1.4: pass an empty CF array as a parameter
Then the parameter is filled with data (replaced with Java object) and we can just parse the object accordingly.

My question here is whether or not we can pass a *table with actual records*.
For example, I want to pass a table with multiple records to update DB records under SAP.
I tried passing (1) CF array of structure and (2) Java ArrayList with no chance.
The web service call itself completes without errors (no method signature error), but the SAP function seems to see the parameter as an empty table.

Anyone has been successful with this case?
Any suggestion would be much appreciated.
This topic has been closed for replies.

1 reply

Inspiring
September 22, 2008
table with actual records?
sounds like a query.

Maybe it will work, maybe it won't.
cfsapAuthor
Participant
September 22, 2008
Thanks Dan,

Unfortunately CF query object didn't work either.

Now I'm looking at the code generated by Flex Builder to see how the classes are like ;-)
It's just an ArrayCollection of simple value objects (representing a row).
So CF array of structure or Java ArrayList looks a reasonable approach though they don't at all.
cfsapAuthor
Participant
September 24, 2008
Anyone has an idea?

FYI, with Flex it was easy to pass a table with records to a SAP web service.
The table can be just an ArrayCollection of simple objects.
However, an almost identical solution in CF does not work.