Java连SAP

最新推荐文章于 2024-03-19 14:54:52 发布

Ian

最新推荐文章于 2024-03-19 14:54:52 发布

阅读量1.1k

点赞数

分类专栏： SAP ABAP

本文链接：https://blog.csdn.net/yuqinying112/article/details/10108561

版权

SAP ABAP 专栏收录该内容

77 篇文章 1 订阅

订阅专栏

参考：http://www.cnblogs.com/cfas/p/3141468.html

1、连接SAP服务器

import java.io.File;
import java.io.FileOutputStream;
import java.util.Properties;

import com.sap.conn.jco.JCoDestination;
import com.sap.conn.jco.JCoDestinationManager;
import com.sap.conn.jco.JCoException;
import com.sap.conn.jco.ext.DestinationDataProvider;

public class ConnectSAPServer {
static String ABAP_AS_POOLED = "ABAP_AS_WITH_POOL";
static{
Properties connectProperties = new Properties();
connectProperties.setProperty(DestinationDataProvider.JCO_ASHOST, "192.168.0.1");
connectProperties.setProperty(DestinationDataProvider.JCO_SYSNR, "00");
connectProperties.setProperty(DestinationDataProvider.JCO_CLIENT, "450");
connectProperties.setProperty(DestinationDataProvider.JCO_USER, "a0001");
connectProperties.setProperty(DestinationDataProvider.JCO_PASSWD, "123456");
connectProperties.setProperty(DestinationDataProvider.JCO_LANG, "en");
connectProperties.setProperty(DestinationDataProvider.JCO_POOL_CAPACITY, "3");
connectProperties.setProperty(DestinationDataProvider.JCO_PEAK_LIMIT,"10");

createDataFile(ABAP_AS_POOLED, "jcoDestination", connectProperties);
}

static void createDataFile(String name, String suffix, Properties properties){
File cfg = new File(name+"."+suffix);
if(!cfg.exists()){
try{
FileOutputStream fos = new FileOutputStream(cfg, false);
properties.store(fos, "for tests only !");
fos.close();
}catch (Exception e){
throw new RuntimeException("Unable to create the destination file " + cfg.getName(), e);
}
}
}

public static JCoDestination Connect(){
JCoDestination destination =null;
try {
destination = JCoDestinationManager.getDestination(ABAP_AS_POOLED);
} catch (JCoException e) {
//e.getCause();
e.printStackTrace();
}
return destination;
}
}

2、

public class SalesOrder {
private String vkorg;
private String vtweg;
private String spart;
private String vbeln;
private String posnr;
private String kunnr;
private String matnr;

public SalesOrder(){}

public SalesOrder(String vkorg,String vtweg,String spart, String vbeln,
String posnr, String kunnr, String matnr){
this.vkorg = vkorg;
this.vtweg = vtweg;
this.spart = spart;
this.vbeln = vbeln;
this.posnr = posnr;
this.kunnr = kunnr;
this.matnr = matnr;
}

public String getVkorg() {
return vkorg;
}

public void setVkorg(String vkorg) {
this.vkorg = vkorg;
}

public String getVtweg() {
return vtweg;
}

public void setVtweg(String vtweg) {
this.vtweg = vtweg;
}

public String getSpart() {
return spart;
}

public void setSpart(String spart) {
this.spart = spart;
}

public String getVbeln() {
return vbeln;
}

public void setVbeln(String vbeln) {
this.vbeln = vbeln;
}

public String getPosnr() {
return posnr;
}

public void setPosnr(String posnr) {
this.posnr = posnr;
}

public String getKunnr() {
return kunnr;
}

public void setKunnr(String kunnr) {
this.kunnr = kunnr;
}
public String getMatnr() {
return matnr;
}

public void setMatnr(String matnr) {
this.matnr = matnr;
}
}

3、

import javax.swing.table.AbstractTableModel;

public class SoTableModel extends AbstractTableModel{
private static final long serialVersionUID = 1L;
public String[] colNames;
private Object[][] stockdata = null;

public SoTableModel(String[] tableTitle, Object[][] tabledata){
colNames = tableTitle;
stockdata = tabledata;
}
public int getColumnCount() {
return colNames.length;
}
public int getRowCount() {
return stockdata.length;
}
public String getColumnName(int col) {
return colNames[col];
}
public void setValueAt(Object value, int row, int col){
Integer num = null;
if ((String) value != null || !String.valueOf(value).equals("")) {
stockdata[row][col] = value;
this.fireTableDataChanged();
}
}
// 从list中拿出rowIndex行columnIndex列显示的值
public Object getValueAt(int row, int col) {
return stockdata[row][col];
}
public void setStockData(Object[][] data) {
this.stockdata = data;
this.fireTableDataChanged();
}

public Object[][] getStockData() {
return stockdata;
}
}

4、

import javax.swing.*;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.event.*;
import java.util.ArrayList;

import javax.swing.JTextField;
import javax.swing.JFrame;
import javax.swing.JTable;

import com.sap.conn.jco.JCoDestination;
import com.sap.conn.jco.JCoFunction;
import com.sap.conn.jco.JCoTable;

public class Inputfile extends JFrame implements ActionListener {

private static final long serialVersionUID = 1L;
JTextField jvbeln;
JTextField jkunnr;
JButton btn;
Object[][] pp;
SoTableModel somodel;
public Inputfile() {
JFrame f = new JFrame("SAP-Java");
JPanel p = new JPanel();
JLabel lablevbeln = new JLabel("销售单号");
JLabel lablekunnr = new JLabel("客户编号");
jvbeln = new JTextField(10);
jkunnr = new JTextField(10);
btn = new JButton("确定");
btn.addActionListener(this);
String[] colname = {"销售组织", "分销渠道", "产品组", "客户编号", "销售单号","行项目号","物料号"};
Object[][]pp ={
{"","","","","","",""}};

somodel = new SoTableModel(colname, pp);
JTable table = new JTable(somodel);
table.setPreferredScrollableViewportSize(new Dimension(500,200));
table.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS);
table.setModel(somodel);
JScrollPane scrollPane=new JScrollPane(table);
p.add(lablevbeln);
p.add(jvbeln);
p.add(lablekunnr);
p.add(jkunnr);
p.add(btn);
f.add(p,BorderLayout.NORTH);
f.getContentPane().add(scrollPane,BorderLayout.SOUTH);
f.setVisible(true);
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
System.exit(0);
}
});
f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
f.setSize(800,300);

}
private static JCoDestination jCoDestination;
public void actionPerformed(ActionEvent e) {
String t1 = jvbeln.getText();
if (e.getSource() == btn) {
pp = Getsodata(t1);
somodel.setStockData(pp);
}
}

public Object[][]Getsodata(String t1){
Object[][] redata = null;
// Object[][] redata ={
// {"fff","dsafasdf","dasfasf","cdd","da","da","dd"},
// {"阿呆","dsafasdf","dasfasf","cdd","da","da","dd"},
// };
ArrayList<SalesOrder> solist = new ArrayList<SalesOrder>();
ArrayList arrvkorg = new ArrayList();
ArrayList arrvtweg = new ArrayList();
ArrayList arrspart = new ArrayList();
ArrayList arrkunnr = new ArrayList();
ArrayList arrvbeln = new ArrayList();
ArrayList arrposnr = new ArrayList();
ArrayList arrmatnr = new ArrayList();

try {
jCoDestination = ConnectSAPServer.Connect();
JCoFunction function = jCoDestination.getRepository()
.getFunction("Z_RFC_SO_GETDATA");
if (function == null)
throw new RuntimeException(
"Z_RFC_SO_GETDATA not found in SAP.");

// 传入的参数
function.getImportParameterList().setValue("SVBELN", t1);
//function.getImportParameterList().setValue("SKUNNR", t2);

function.execute(jCoDestination);

JCoTable returnTable = function.getTableParameterList()
.getTable("ZSO_INFO");

if (returnTable.getNumRows() > 0) {

returnTable.firstRow();
for (int i = 0; i < returnTable.getNumRows(); i++, returnTable
.nextRow()) {
SalesOrder so = new SalesOrder();
so.setVkorg(returnTable.getString("VKORG"));
so.setVtweg(returnTable.getString("VTWEG"));
so.setSpart(returnTable.getString("SPART"));
so.setKunnr(returnTable.getString("KUNNR"));
so.setVbeln(returnTable.getString("VBELN"));
so.setPosnr(returnTable.getString("POSNR"));
so.setMatnr(returnTable.getString("MATNR"));
solist.add(so);
arrvkorg.add(returnTable.getString("VKORG"));
arrvtweg.add(returnTable.getString("VTWEG"));
arrspart.add(returnTable.getString("SPART"));
arrkunnr.add(returnTable.getString("KUNNR"));
arrvbeln.add(returnTable.getString("VBELN"));
arrposnr.add(returnTable.getString("POSNR"));
arrmatnr.add(returnTable.getString("MATNR"));
}

redata = new Object[returnTable.getNumRows()][7];
for(int t =0; t<returnTable.getNumRows(); t++){
redata[t][0] = arrvkorg.get(t).toString();
redata[t][1] = arrvtweg.get(t).toString();
redata[t][2] = arrspart.get(t).toString();
redata[t][3] = arrkunnr.get(t).toString();
redata[t][4] = arrvbeln.get(t).toString();
redata[t][5] = arrposnr.get(t).toString();
redata[t][6] = arrmatnr.get(t).toString();
}
//for(int m = 0; m<returnTable.getNumRows(); m++){
// System.out.print(pp[m][0]+"~"+pp[m][1]+"~"+pp[m][5]+"~"+pp[m][6]);
// }
//for (SalesOrder saporder : solist) {
// System.out.println(saporder.getVbeln());
// System.out.println(saporder.getMatnr());
// }

}

} catch (Exception exx) {
exx.printStackTrace();
}
return redata;
}
public static void main(String args[]) {
new Inputfile();
}
}

5、SE37创建函数如下：

z_rfc_so_getdata

DATA:itab LIKE TABLE OF zsoinfo WITH HEADER LINE.

  SELECT
    vbak~vkorg
    vbak~vtweg
    vbak~spart
    vbak~kunnr
     vbap~vbeln
     vbap~posnr
    vbap~matnr
    INTO CORRESPONDING FIELDS OF TABLE itab FROM vbak INNER JOIN vbap ON vbak~vbeln = vbap~vbeln
    WHERE  vbak~vbeln = svbeln.

  LOOP AT itab.
    "MOVE-CORRESPONDING itab TO zso_info.
    zso_info = itab.
    APPEND zso_info.
  ENDLOOP.
ENDFUNCTION.