Guidelines

What is JDBC lookup in SAP PI?

by Rhyley Bryan

What is JDBC lookup in SAP PI?

In SAP PI 7.1, we can use Graphical JDBC Lookup in the corresponding mapping object in order to avoid UDF Code for simplified manner. The JDBC Receiver Communication Channel for the corresponding Business System/Service should be created and the values should be assigned in the UDF Code.

How do you create a JDBC lookup in SAP PI?

  1. Enable Access to the Database Table. In the Integration Directory, create the JDBC receiver channel for the call to the application system.
  2. Define a Parameterized Message Mapping Program.
  3. Configure a Receiver Channel for Mapping Lookups.

How do you create an RFC lookup in SAP PI?

Import the standard Function module “RFC_READ_TABLE” in ESR under your SWCV. Step2. Go to message mapping conversions function and click on RFC lookup. Step4: Select the required input and output parameters by double clicking on the fields.

How do you use parameterized mapping in SAP PI?

Step by Step Guide on Parameterized Mapping Configuration:

  1. Step 1 – Create Parameters in Mapping Program.
  2. Step 2 – Map the Import Parameter to Required Output Field.
  3. Step 3 – Create Parameters in Operation Mapping.
  4. Step 4 – Bind Operation Mapping Parameters with Message Mapping Parameters.

How to use JDBC lookup in Pi 7.1?

3) In message mapping where this lookup is to be used select JDBC Lookup under Conversions and map 5) Select parameter and a database table (imported as the external definition). All the elements of the table will appear in the middle column.

Is there graphical support for JDBC in SAP 7.1?

In SAP NetWeaver Process Integration (PI) 7.1, there is now graphical support for JDBC and RFC mapping lookups in message mappings, instead of having to create a user-defined function with the relevant lookup code as in previous releases (e.g. XI 3.0/PI 7.0).

How to look up a table in SAP PI?

Select the parameter to be used for the lookup. The parameter is maintained within the Signature tab as shown above. The name of the actual communication channel used for the lookup will be the value for this parameter. Select the relevant external definition that corresponds to the table definition (see prerequisites).

Where do I find the JDBC channel in SAP?

The JDBC channel to be used for the lookup must be configured and activated in the Integration Directory.