Integrating SAP and non SAP (Java application)

[Former Member]

I am trying to integrate a java application with sap using XI. In java application i will enter the flight name 'LH' and all the reqired details about the flight will be fetched from SAP R/3 table sflight through XI back to Java application.

Could you pls tell me about the usage dependencies and the idocs that i need to use for this purpose. I have added BASIS systems to the usage dependencies of the product that i created is that right for extracting data from the data base.

Is there any book or site that gives step by step procedure to implement such scenarios.

Please Advice

[Former Member · Accepted solution]

Hi Ravi,

First of all, thanks a lot for the reply. Now the issue is when we create a new product component and new software component in integration builder would it be third party or standalone java application.

Also what do we deifne in usage dependencies.

As you know the scenario now. Lets say we try to extract flights info from the sflight table from r/3. so what do we define in usage dependencies?

If i use materials info instead of flight info than how do i add mm module to usage dependencies?

Also you said that we have to write a function that would extract data, so where do we have to write the data, also in which language ABAP or Java.

I am begineer in this field i request your continual guidance as i want to master this field.

Regards,

Ashish Goyal.

[Former Member · Accepted solution]

Ashish,

you will have to create the Software component as a third party system. (This represents your Java application).

I am not sure, why are you looking for Usage dependencies in this case.

Coming to the ABAP, there are quite a BAPI's available ready made for the Flight example. So, you can just call them.

You need to choose the right function module depending on your requirement. If at all you have write the code you will have write it in the R/3 system in ABAP.

Regards,

Ravi

[Former Member · Accepted solution]

Ravi,

I am a bit confused about usage dependencies. Like here our java applications need to extract data from R/3 database, so don't we have to include SAP R/3 in usage dependencies of the product that we create.

Also is it mandatry to include web service for the java application. Beacause as i understand we need proxies to communicate with adapters.

Regards,

Ashish Goyal

[Former Member · Accepted solution]

hello ashish...

usage dependencies r defined for software componentswhich r used in differen t products otherwise its not essential...

also, ur confusing this ...

>>>> Beacause as i understand we need proxies to communicate with adapters.

proxies and adapters r differnt terms acrually.,

u can directly have a scenario of JDBC to RFC without the use of proxies...

proxies r generally used to communicate with external systems...

regards.

vishal

[Former Member · Accepted solution]

Ashish,

I don't in this case you will have to really worry about the usage dependencies.

Proxies / Web SErvices are not mandatory. If you want to communicate with XI without using adapters that is when you will go for proxies. For the exampe that you are trying, I don't suggest proxies.

Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Is it mandatory to involve WEB AS for the kind of integration that i am doing i.e integrating a simple java application with sap r/3 using xi.

Ashish

[Former Member · Accepted solution]

When i create a new technical system, it asks for System Name and Host name.

What should be written in the host name?

[Former Member · Accepted solution]

When i try to create a business system it asks for the logical system name. What is this?

[Former Member · Accepted solution]

hello ashish...

the host name is generally ur local host name if ur creating a third party or a scenario for testing puposes...

and if u know a bit abt ALE IDOCS then a logical system name is unique name assigned to a system..

this same name has to be the name of ur partner profile in tcode:we20 and also the name of ur RFC destination...

so create ur RFC destinaton as the same name as of logical sys name...

regards..

vishal

[Former Member · Accepted solution]

If i have to input the material name in my java application for which all the info would be extracted from the MM module, than where do i define the data type of the parameter that would be sent and the data types of the information that would be retrieved from the MM module. How would XI differentiate between the two.

[Former Member · Accepted solution]

If i have to input the material name in my java application for which all the info would be extracted from the MM module, than where do i define the data type of the parameter that would be sent and the data types of the information that would be retrieved from the MM module. How would XI differentiate between the two.

[Former Member · Accepted solution]

If i have to input the material name in my java application for which all the info would be extracted from the MM module, than where do i define the data type of the parameter that would be sent and the data types of the information that would be retrieved from the MM module. How would XI differentiate between the two.

[Former Member]

Also can i access the database directly or i have to go through a function module.

[Former Member]

In this case, I would envision your scenario like this.

Java Application -

---

> HTTP Adapter -

---

> XI -

---

> RFC Adapter (Synch interface) -

---

> R/3

You might have to write a function that you can call which will extract the data and give it to you. Accessing the database directly is possible, however I don't suggest that method as its an ERP database and is not mean to be touched directly.

Regards,

Ravi

Note : Please reward points if this helps you.