SAP RFC Integration

1 Overview

In SAP systems, the capability for remote calls is provided by the RFC (Remote Function Call) interface system. RFC allows calling between two SAP systems (R/3 or R/2), or between an SAP system and a non-SAP system.

2 How Informat Calls SAP RFC Functions

2.1 Call SAP RFC Functions via Java Extension Library

Calling Method

package informat.library.poc;

import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Properties;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import com.sap.conn.jco.JCo;
import com.sap.conn.jco.JCoDestination;
import com.sap.conn.jco.JCoDestinationManager;
import com.sap.conn.jco.JCoException;
import com.sap.conn.jco.JCoField;
import com.sap.conn.jco.JCoFunction;
import com.sap.conn.jco.JCoParameterList;
import com.sap.conn.jco.ext.DestinationDataProvider;

import informat.library.utils.JSONUtil;

public class SapService {
	//
	private static Logger logger=LoggerFactory.getLogger(SapService.class);
	//
	public static String getVersion() {
		return JCo.getVersion();
	}

	public static void registerDestinationDataProvider(String destinationName, Map<String,String> properties) {
		logger.info("registerDestinationDataProvider destinationName:{}",
			destinationName, JSONUtil.toJson(properties));
		Properties props=new Properties();
		if(properties!=null) {
			properties.forEach((k,v)->{
				props.setProperty(k,v);
			});
		}
		com.sap.conn.jco.ext.Environment.registerDestinationDataProvider(new CustomDestinationDataProvider(destinationName, props));

	}

	// Universal SAP function call method
	public static SapFunctionResult callSapFunction(String destinationName, // SAP destination name (e.g., "SAP_DEST")
			String functionName, // Name of the function module to call
			Map<String, Object> inputs, // Input parameter key-value pairs
			List<String> outputTables // Array of output table names to return (optional)
	) throws JCoException {
		logger.info("callSapFunction destinationName:{}, functionName:{}, inputs:{}, outputTables:{}",
			destinationName, functionName, JSONUtil.toJson(inputs), JSONUtil.toJson(outputTables));
		JCoDestination destination = JCoDestinationManager.getDestination(destinationName);
		JCoFunction function = destination.getRepository().getFunction(functionName);
		if (function == null) {
			throw new RuntimeException("SAP function " + functionName + " does not exist");
		}

		// Set input parameters
		if (inputs != null) {
			JCoParameterList importParams = function.getImportParameterList();
			inputs.forEach((k, v) -> importParams.setValue(k, v));
		}

		// Execute function call
		function.execute(destination);

		// Process return results
		SapFunctionResult result = new SapFunctionResult();

		// Get export parameters
		JCoParameterList exportParams = function.getExportParameterList();
		if (exportParams != null) {
			for (JCoField param : exportParams) {
				result.addExportParam(param.getName(), param.getValue());
			}
		}

		// Process output tables (get as needed)
		if (outputTables != null) {
			JCoParameterList tables = function.getTableParameterList();
			for (String tableName : outputTables) {
				if (tables.isActive(tableName)) {
					result.addOutputTable(tableName, tables.getTable(tableName));
				}
			}
		}
		logger.info("callSapFunction result:{}", JSONUtil.toJson(result));
		return result;
	}

	//
	public static void main(String[] args) throws JCoException {
		System.out.println(JCo.getVersion());
		Map<String,String> props = new HashMap<>();
		props.put(DestinationDataProvider.JCO_ASHOST, "your_sap_host"); // SAP server address
		props.put(DestinationDataProvider.JCO_SYSNR, "00"); // System number
		props.put(DestinationDataProvider.JCO_CLIENT, "100"); // Client number
		props.put(DestinationDataProvider.JCO_USER, "username"); // Username
		props.put(DestinationDataProvider.JCO_PASSWD, "password"); // Password
		props.put(DestinationDataProvider.JCO_LANG, "en"); // Language
		props.put(DestinationDataProvider.JCO_POOL_CAPACITY, "3");
		props.put(DestinationDataProvider.JCO_PEAK_LIMIT, "10");
		//
		String destinationName = "SAP_DEST";
		registerDestinationDataProvider(destinationName, props);
		Map<String, Object> inputs = new HashMap<>();
		// 3. Set input parameters
		inputs.put("AUART", "ZOR1");
		inputs.put("ZOAMWLXX", "20_1.05.01.10455");
		inputs.put("KUNSP", "100689");
		//
		List<String> outputTables = List.of( "OT_DATA", "OTHER_TABLE" );
		SapFunctionResult result=callSapFunction(destinationName, "ZFM_SD051", inputs, outputTables);
		System.out.println(JSONUtil.toJson(result));
	}
}

2.2 Package the Java Project and Upload to Informat Application Extension Library

2.3 Informat Script Calls SAP RFC Functions

Informat scripts call the Java extension library through informat.system.invokeLibrary to implement calling SAP RFC functions

informat.system.invokeLibrary("saplibrary", "informat.library.poc.SapService", "registerDestinationDataProvider", [
  "sap_test1",
  {
    "jco.client.ashost": "192.168.x.x",
    "jco.client.sysnr": "00",
    "jco.client.client": "800",
    "jco.client.user": "user",
    "jco.client.passwd": "password",
    "jco.client.lang": "en",
    "jco.destination.pool_capacity": "3",
    "jco.destination.peak_limit": "10",
  },
]);

let result = informat.system.invokeLibrary("saplibrary", "informat.library.poc.SapService", "callSapFunction", ["sap_test1", "ZFM_SD051", { AUART: "ZOR1" }, ["OT_DATA", "OTHER_TABLE"]]);
console.log("result", result);

SapFunctionResult Structure

public class SapFunctionResult {
	public Map<String, Object> exportParams = new HashMap<>();
	public Map<String, JCoTable> outputTables = new HashMap<>();
}