WEB TO IDOC

[Former Member]

hi all,

I have to develop an interface, this has to call a web site and recover an XML and map this XML to an IDOC.

the web site that i have to acces is: http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml

I don´t know how to do it. Any one can give us a clue?

Many thanks

Regards

Noelia

[Former Member]

Hey,

You need to go for a BPM.

BPM design

Receive(abstract asynchronous) for file structure

Transformation step(mapping between file structure and request for website)

Send(abstract synchronous) for the website call

Transforamtion step for mapping between website response and Idoc

Send step( abstract asynchronous) for Idoc

For Idoc you need ALE settings

Steps for ALE settings:-

Steps for XI

Step 1)

Goto SM59.

Create new RFC destination of type 3(Abap connection).

Give a suitable name and description.

Give the Ip address of the R3 system.

Give the system number.

Give the gateway host name and gateway service (3300 + system number).

Go to the logon security tab.

Give the lang, client, username and password.

Test connection and remote logon.

Step 2)

Goto IDX1.

Create a new port.

Give the port name.

Give the client number for the R3 system.

Select the created Rfc Destination.

Step 3)

Goto IDX2

Create a new Meta data.

Give the Idoc type.

Select the created port.

Steps for R3.

Step 1)

Goto SM59.

Create new RFC destination of type 3(Abap connection).

Give a suitable name and description.

Give the Ip address of the XI system.

Give the system number.

Give the gateway host name and gateway service (3300 + system number).

Go to the logon security tab.

Give the lang, client, username and password.

Test connection and remote logon.

Step 2)

Goto WE21.

Create a port under transactional RFC.(R3->XI)

Designate the RFC destination created in prev step.

Step 3)

Goto SALE.

Basic settings->Logical Systems->Define logical system.

Create two logical systems(one for XI and the other for R3)

Basic settings->Logical Systems->Assign logical system.

Assign the R3 logical system to respective client.

Step 4)

Goto WE20.

Partner type LS.

Create two partner profile(one for XI the other for R3).

Give the outbound or inbound message type based on the direction.

Step 5)

Goto WE19

Give the basic type and execute.

fill in the required fields.

Goto IDOC->edit control records.

Give the following values.(Receiver port,partner no.,part type and sender Partner no. and type)

Click outbound processing.

Step 6)

Go to SM58

if there are any messages then there is some error in execution.

Goto WE02.

Check the status of the IDOC.

Goto WE47.

TO decode the status code.

Step 7)

Not mandatory.

Goto BD64.

Click on Create model view.

Add message type.

BD87 to check the status of IDOC.

In case if not authorized then go to the target system and check in SU53, see for the missing object

and assign it to the user.

SAP r3

sm59(status check)(no message)

WE02(status check)

WE05(status check)

BD87(status check)

WE42 process code

WE47 status info.

reward points if useful

regards,

Milan

[bhavesh_kantilal]

1. What is the trigger to your Interface? How will you start processing the interface in XI?

If you can give us this detail then the procedure to go ahead can be figured out.

Regards

Bhavesh

[Former Member]

Many thanks for your answer

The trigger of my interface is the call to the web site. I have to load into R3 daily the exchange rate, this rate is in the web site. It is supposed that we are going to go to this site using XI and map the XML of the web site to an IDOC.

I´m using PI 7.0

regards

Noelia

[bhavesh_kantilal]

Hi Noelia,

The point I was making is

1. The Call to the webservice has to start from XI. But , how will your determine when XI has to start the process? There needs to be a External Pull or Push that will trigger the message flow in XI.

For example, at the corresponding time of the day you can have a File that is dropped in your XI server. XI's file adapter will pick this file and then you will have a BPM that will call the webservice, get the values and then post this as an Idoc.

Once you determine the Triggering application you can handle this using aBPM.

Regards

Bhavesh

[Former Member]

Thanks For your answer

I understand what you mean. I will use a file, but I have understand that PI has a scheduler.

Do you think I need to use a soap adapter? or HTTP plain? Is there any way to it with out a BPM?

many thanks

Noelia

[bhavesh_kantilal]

Noelia,

Was just look into the link you have posted. It does not look like a Webservice. So, I dont think SOAP will be helpful here.

Also, am not sure I follow the requirement you have. This XML is a http page on the Internet. How are you supposed to get data from it?

You might need to ask the other team to expose some webservice etc.

Maybe someone has a better solution as I myself am lost after having a look at the Link given by you,

Regards

Bhavesh

[Former Member]

Hi Bhavesh,

I have a same type of requirement.I have posted a thread

Please suggest me what should I do while doing the BPM part.