Hi,
1)what is lookups
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.
2).why we can use for lookups.
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
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
Its like a UDF how you can map the udf this is also same.
Some sample code
Imports com.sap.mw.jco.;java.lang.;
String client, user, pwd, sysnr, ipadd;
String systemUser = System.getProperty("user.name");
String xiSystem = systemUser.substring(0,3);
JCO.Repository mRepository;
// connect to SAP
JCO.Client mConnection = JCO.createClient(
client, // SAP client
user, // userid
pwd, // password
"EN", // language
ipadd, // host name
sysnr ); // system number
// connect to SAP
mConnection.connect();
// create repository
mRepository = new JCO.Repository( "SAPLookup", mConnection );
// Create function
JCO.Function function = null;
IFunctionTemplate ft = mRepository.getFunctionTemplate("Z_GETSESSION_ID_TOKEN");
function = ft.getFunction();
// Obtain parameter list for function
JCO.ParameterList input = function.getImportParameterList();
mConnection.execute( function );
String ret = function.getExportParameterList().getString( "CONVERSATION_ID" );
binary_token = function.getExportParameterList().getString( "BINARY_TOKEN" );
mConnection.disconnect();
return ret;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.