如何使用sap .net连接器从SAP系统获取数据？

首先创建连接

RfcDestination destination = mDestinationManager.GetDestination("MYDESTINATION");

创建功能

IRfcFunction readTable = destination.Repository.CreateFunction("RFC_READ_TABLE");

在调用函数之前设置参数

// we want to query table KNA1
readTable.SetValue("QUERY_TABLE","KNA1");
// fields will be separated by semicolon
readTable.SetValue("DELIMITER",";");

表参数是通过从函数中检索表来创建的,使用Append()函数添加行并使用SetValue()为该行中的各个列设置值

// Parameter table FIELDS contains the columns you want to receive
// here we query 2 fields,KUNNR and NAME1
IRfcTable fieldsTable = readTable.GetTable("FIELDS");
fieldsTable.Append();
fieldsTable.SetValue("FIELDNAME","KUNNR");
fieldsTable.Append();
fieldsTable.SetValue("FIELDNAME","NAME1");

// the table OPTIONS contains the WHERE condition(s) of your query
// here a single condition,KUNNR is to be 0012345600
// several conditions have to be concatenated in ABAP syntax,for instance with AND or OR
IRfcTable optsTable = readTable.GetTable("OPTIONS");
optsTable.Append();
optsTable.SetValue("TEXT","KUNNR = '0012345600'");

调用该函数

readTable.Invoke(destination);

处理数据

IRfcTable dataTable = readTable.GetTable("DATA");

foreach(var dataRow in dataTable)
{
    string data = dataRow.GetValue("WA");
    string[] columns = data.Split(';');
}