Extraction to BW system through external WSDL

[former_member592144]

Hey Gurs.

I need to extract data to BW system using external WSDL.

It seems that ive configured a proxy and a logical port to it ( at least the LP pings ).

Ive also create a programm which send a request to get data through my proxy.

While testing a get the following error :

GET_BUSINESS_SYSTEM_ERROR An error occurred when determining the business system (SLD_API_EXCEPTION)

Ive read a couple of post regarding SLD settings but it didnt really help.

I assume there is a problrm with connection but between which systems? Who should perfer an SLD set up ? Is it a Basis problem or I can manage it myself ?

Thanks in advance for your help.

[former_member592144 · Accepted solution]

A little update on the topic.

We've configure connection in SM59. now when i try to execute my program, which calls my proxy, I get the following error:

GET_BUSINESS_SYSTEM_ERROR An error occurred when determining the business system (COMMUNICATION_ERROR).

Any ideas how to fix that?

The one thing i cant get is:

When i test the proxy in BW it retrieves data from WSDL and i get the XML message with data. So the connection is fine and data passes through. What is the problem when I'm trying to get that data while calling my proxy through the ABAP program?

All the guideline I've read about extracting data from WSDL have one thing in common - the last step - creating and executing a program that uses the proxy and no additional settings are being done to do that. whats the problem in this case?

[former_member592144 · Accepted solution]

Further update.

We didn't specify the logical port when creating the proxy in the program. That was the problem.

Now our proxy returns the data.

Now we have a new problem. Instead of normal data we receive a xml data in every field. Somehow proxy didnt transform data from xml into abap format.

[former_member592144 · Accepted solution]

I finally managed to solve this problem by using FM - 'SMUM_XML_PARSE' , to parse xstring to an applicable data type and to pass it to the data source.