XI and DB2

[Former Member]

Good morning everybody,

I'm a junior in SAP (Just started) ...I would like to know what are the different steps to make interfaces between SAP R3 and DB2 with SAP XI?

Thanks in advance,

Muraii

[Former Member · Accepted solution]

Murai,

For connecting to DB2 you have to deploy the corresponding jdbc drivers in your XI server.

For connecting with R/3, you have 3 options if your WebAs is based on 6.2 and above.

1. Proxy

2. RFC adapter

3. IDOC adapter

Regards,

Jai Shankar

[Former Member]

Hi guys,

Can anybody tell me in which case do we need to use a logical sytem and where to create it?(what s the aime to create it?)

Thanks again!

Regards,

Murai

[Former Member]

Hi,

Logical system , when we are integrating the SAP R3 systems we can have Logical system, I mean IDoc related scenarios either sender or receiver side , we would have to take Logical system name consideration.

To create the Logical name , go to R3 of external SAP or R3 instance of XI ,

SM59

BD54. create logical system,

SCC4 to assign logical system name to Client.

To communicate R3 to XI and XI to R3.

Regards

Chilla..

[Former Member]

in IDOC scenario we use logical system. to create to use T/C code BD54. to the tell data to go particular part of system.

Regards

sreeram.g.reddy

[bhavesh_kantilal]

Hi,

Logical System Names are used to uniquely identify every system in your landscape.

When you need to post an idoc to a SAP system, the sender and receievr partner name are taken from the Business Systems's associated Logical System name.

Also, when a SAP system is posting an Idoc to XI, it searches for the its logical system name in XI. When it finds the associated Business System , it uses this as the Sender Bsuiness System and posts the Idoc to XI.

Every SAP system has a uniqeue logical system name associated with it.

The default naming convertion is SYSID"CLNT"ClientNumber.

Regards

Bhavesh

Regards

Bhavesh

[Former Member]

Is there specific product and SWCV to create in my case?

Thanks for your help!!! It is very kind of you

[Former Member]

Not required.

you can create your namespace under exhisting SWCV. if you feel like you need to have new SWCV then you create a new SWCV .

while creating SWCV if like to use exhisting products you use them in your SWCV othewise you can create new product and use it in SWCV.

Regards

sreeram.g.reddy

[Former Member]

HI Murai,

Yes in SLD two things we need to do is

1) Create your product and SWCV in software catalog

2) TS and BS in Technical landscape and Business Landscape.

Regards

Abhi

[Former Member]

Yes actually I would like to know the different steps in SLD

I have to create

- a system Landscape

- One TS (Web AS ABAP) and one (third party)

- One BS (Web AS ABAP) and one (third party)

Am I right? sorry It's probably obvious for you but not for me :s

Thanks you!

Murai

[Former Member]

this is will be created only once in XI and these done BASIS once you install XI One TS (Web AS ABAP),One BS (Web AS ABAP).

if not then yu have do it

thrid part you need to create .

[bhavesh_kantilal]

Hi,

If you have created the WebAsABAP Technical and Busiess Systems for your R3 system and the DB2 is going to be represented as a ThirdParty Technical and WebASABAP business system , you have done things correct.

Regards

Bhavesh

[Former Member]

Thank you all for your help!

Do I need to do something special to create the two business?

Thanks again!

Message was edited by:

Murai Kun

[Former Member]

HI,

Yes you would have to create separate BS and two TS. In real time both should not be the same.

Regards

Chilla..

<i>Points rewarded if it is helpful..</i>

[Former Member]

HI Murai,

You can get the complete walkthrough of scenario related to IDoc as sender from this link

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/cdded790-0201-0010-6db8-beb...

and at a receiver side you can configure the JDBC adapter with the configuration parameters according to your requirement

http://help.sap.com/saphelp_nw04s/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm

Regards

Abhi

[Former Member]

Hi Murai,

For connecting to R/3, you can use IDoc adapter or RFC adapter. Please see the below links for configuring the above adapters..

/people/michal.krawczyk2/blog/2005/03/29/configuring-the-sender-rfc-adapter--step-by-step

- File to Idoc

/people/ravikumar.allampallam/blog/2005/02/23/configuration-steps-required-for-posting-idocsxi

/people/james.guanzon/blog/2006/03/23/how-to-support-industry-standards-in-xi-part-ii-of-iii--mapping

For connecting to DB2, you need to use the type 4 adapter for DB2 and connect using the normal JDBC code. The below link gives the details for configuring JDBC.

http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

/people/ajay.kumar/blog/2005/03/24/writing-bsp-for-sap-r3-version-46

/people/sugree.phatanapherom/blog/2005/08/14/configuring-sld-in-sneak-preview-sap-netweaver-04-sneak

/people/sanyam.kapur/blog/2005/04/30/custom-fields-and-bw-extractors-making-a-mixed-marriage-work-part-ii

Hope these help... Dont forget to reward points if this is helpful..

Also do get back to me in case you need further details...

Regards

Kiran..

[Former Member]

hi,

would like to know what are the different steps to make interfaces between SAP R3 and DB2 with SAP XI?

to communiate SAP R3 and DB2 with SAP XI develop the some scenario.

get all material information from SAP R3 and pull the some of the data into DB2.

Scenario like IDOC-TO-JDBC.

First you have to create two business to identify R3 and DB2

Next devlope the IR What is source IDOC what is the Target Structure need to pull which data in DB2

Next create the configuration scenario in ID.

Regards,

Venu.

[Former Member]

Hi Murai,

Use JDBC Adapter for your purpose.

refer this link and explore your self, it helps you alot than following already defined steps.

http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm

Regards,

Ramesh.