cancel
Showing results for 
Search instead for 
Did you mean: 

receive XML file from CIDX adapter and Post to SAP as IDoc using XI

Former Member
0 Kudos

I have scenario where we will receive the xml file from CIDX adapter. I need to take the xml from CIDX, do the Database Lookup and post it to SAP as IDoc.

Any technical documentaion or step-by-step process documents can be very helpfull to me, since I am new to XI

Thanks

SP

Accepted Solutions (0)

Answers (3)

Answers (3)

GabrielSagaya
Active Contributor
0 Kudos

Lookup in XI is used to call the target data storage system and get data from there to your mapping programme.

In XI you can do Lookup in Message Mapping, Java Mapping and in XSLT Mapping. Previously Lookup in XI was system dependent. But now what ever the system are i.e. SAP system or non-sap system(Oracle,MS SQL etc) lookup API are same.

Overview of Lookup

- Lookups are used to identify/request the data from mapping program.

- It interrupt the process and looking for data which was stored in target system.

- It get that data and comeback to process and continue with that data.

Types of Lookups in XI

- JDBC Lookup: JDBC lookup is used for accessing data from database (non SAP).

- RFC Lookup: RFC lookup is used for accessing the SAP Data.

- SOAP Lookup: SOAP lookup is used for accessing data from Webservice

Steps to perform Lookup in Mapping

Import package com.sap.aii.mapping.lookup.*;

Create connection to the target Database system.

// Determine communication channel created in ID

Channel channel = null;

channel = LookupService.getChannel("DB-SYSTEM-NAME","DB-CHANNEL-NAME");

// Get system accessor for the channel.

DataBaseAccessor accessor = null;

accessor = LookupService.getDataBaseAccessor(channel);

Build the Query String.

Getting Result

// Execute Query and get the values.

DataBaseResult resultSet = null;

resultSet = accessor.execute(Query);

GabrielSagaya
Active Contributor
0 Kudos

Lookups are used to identify / request the data from mapping , i mean interupting the process and looking for data which was stored in some where and get that data and comback to process and continue with that data.

We will use these type of lookups in Message mapping for refering DB Lookup for data base which is not SAP, RFC lookups for SAP data

Database lookup in XI

/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

/people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

How to check JDBC SQL Query Syntax and verify the query results inside a User Defined Function of the Lookup API -

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Former Member
0 Kudos

HI,

Check this document for database lookup:

DB lookup - /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

chirag