<%@ page language="java" contentType="text/json; charset=UTF-8" pageEncoding="UTF-8" %>
<%@include file="/common.jsp"%>
<%
// Configuration of SAP connection
String JCO_HOST = "192.168.1.250";
String JCO_SYNSNR = "00";
String JCO_CLIENT = "000";
String JCO_USER = "ddic";
String JCO_PASSWD = "123456789qq";
String JCO_LANG = "ZH";
String JCO_POOL_CAPACITY = "30";
String JCO_PEAK_LIMIT = "100";
String JCO_SAPROUTER = "/H/192.168.1.250";
JCO_SAPROUTER="";
SapConn con = new SapConn(JCO_HOST, JCO_SYNSNR, JCO_CLIENT, JCO_USER, JCO_PASSWD, JCO_LANG, JCO_POOL_CAPACITY, JCO_PEAK_LIMIT, JCO_SAPROUTER);
JCoDestination jCoDestination = SAPConnUtil.connect(con);
JCoFunction function = jCoDestination.getRepository().getFunction("ZRFC_SD_ADD_CUSTOMER");
JCoParameterList paramList = function.getImportParameterList();
JCoStructure IS_CUSTOMER =paramList.getStructure("IS_CUSTOMER");
IS_CUSTOMER.setValue("ZCUSTOMERID","990342");
IS_CUSTOMER.setValue("ZCOMPANYNAME","深圳市海希五金电子有限公司");
IS_CUSTOMER.setValue("ZCREATEDATE","2023-03-06");
IS_CUSTOMER.setValue("ZSCOPE","金属制品批发");
IS_CUSTOMER.setValue("ZUSERID","");
IS_CUSTOMER.setValue("ZSEX","");
IS_CUSTOMER.setValue("ZAP","");
function.execute(jCoDestination);
String R_NUMBER = function.getExportParameterList().getString("NUMBER");
out.print(R_NUMBER);
out.print(IS_CUSTOMER);
%>
package com.swift.oa;
import com.sap.conn.jco.*;
/**
* @Author: Wriprin
* @Date: 2022/11/25 17:20
* @Version 1.0
*/
public class GetMaraInfo {
public static void main(String[] args) throws JCoException {
// Configuration of SAP connection
String JCO_HOST = "192.168.1.250";
String JCO_SYNSNR = "00";
String JCO_CLIENT = "000";
String JCO_USER = "ddic";
String JCO_PASSWD = "123456789qq";
String JCO_LANG = "ZH";
String JCO_POOL_CAPACITY = "30";
String JCO_PEAK_LIMIT = "100";
String JCO_SAPROUTER = "/H/192.168.1.250";
JCO_SAPROUTER="";
SapConn con = new SapConn(JCO_HOST, JCO_SYNSNR, JCO_CLIENT, JCO_USER, JCO_PASSWD, JCO_LANG, JCO_POOL_CAPACITY, JCO_PEAK_LIMIT, JCO_SAPROUTER);
JCoDestination jCoDestination = SAPConnUtil.connect(con);
try {
// 获取调用 RFC 函数对象
JCoFunction func = jCoDestination.getRepository().getFunction("ZRFC");
// 配置传入参数
JCoParameterList importParameterList = func.getImportParameterList();
importParameterList.setValue("NAME","Lucy");
importParameterList.setValue("MATERIAL","A02");
JCoTable cerTable = func.getTableParameterList().getTable("GT_PRITEM22");
cerTable.appendRow();
cerTable.setValue("PREQ_ITEM","10");
cerTable.setValue( "MATERIAL","A08");
cerTable.setValue( "PLANT","8010");
cerTable.setValue( "QUANTITY","6666");
cerTable.appendRow();
cerTable.setValue("PREQ_ITEM","20");
cerTable.setValue( "MATERIAL","A02");
cerTable.setValue( "PLANT","8010");
cerTable.setValue( "QUANTITY","555");
// 调用并获取返回值
func.execute(jCoDestination);
String R_NUMBER = func.getExportParameterList().getString("NUMBER");
JCoTable table = func.getTableParameterList().getTable("RETURN");
for(int i=0;i<table.getNumRows();i++)
{
table.setRow(i);
String ID= table.getString("ID");
String TYPE = table.getString("TYPE");
if(TYPE.equals("E"))
{
String MESSAGE_V1 = table.getString("MESSAGE");
System.out.println(TYPE+"==>"+MESSAGE_V1+"==>"+ID);
}
}
//System.out.println("ME51N返回采购申请单号===>"+R_NUMBER);
// // 获取 内表 - ET_MARA
// JCoTable maraTable = func.getTableParameterList().getTable("ET_MARA");
//
// // 循环输出 Table 数据
// for (int i = 0; i < maraTable.getNumRows(); i++) {
// maraTable.setRow(i);
//
// String matnr = maraTable.getString("MATNR");
// String esdra = maraTable.getString("ERSDA");
// String ernam = maraTable.getString("ERNAM");
// String matkl = maraTable.getString("MATKL");
// String meins = maraTable.getString("MEINS");
//
// System.out.println("物料编号:" + matnr + " - 创建日期:" + esdra + " - 创建人:" + ernam + " - 物料组:" + matkl + " - 单位:" + meins);
// }
} catch (Exception e) {
e.printStackTrace();
}
}
}