. NET using NCO to connect SAP from RFC query data code configuration connect SAP information

Keywords: setting SAP connection information in code, parsing from RFC query data into a DataTable

1. Environment:

A. win7+64-bit operating system B. VS2012

C. nco3.0, a dedicated component of SAP for. NET development (64bit download URL: http://www.dllbang.com/dll/sapnco_dll)
D. (may be used) Microsoft Visual C + + 2005 Service Pack 1 for DLL files that are shipped nco3.0
Download URL: http://www.microsoft.com/en-us/download/details.aspx?id=14431
E. After installing NCO3.0, there will be Sapnco_utils.dll Sapnco.dll Rscp4n.dll under the C:\Program files\sap\sap_dotnetconnector3_x86 directory Libicudecnumber.dll Four DLL files, add references to the first two DLL files in the project (you can create a folder in the project, place the two DLLs, and then refer to the two DLLs in the folder), and the project. NET target platform changed to 4.0.

2. Purpose: an RfC that connects a query data from SAP, invokes and parses the returned data into a DataTable

3.RFC Structure: Structure of the zcp3_mmif002zbzz125:

1) input parameter import:input, such as:

The specific structure of input is as follows:

2) input/output parameters Tables: There are many, each of the following lines is one (in the code below, Jhnum and Jhtyp for example), such as:

The structure of Jhnum is as follows:

The structure of the Jhtyp is the same as the structure of the above jhnum.

3) Output Parameters-query results, is the HEADER in the input/output parameter tables, such as:

The header is structured as follows: (in the following C # code, the fields in the header are queried)

4. Test query conditions:

The bukrs:k999 in input
The werks:x666 in input

Tables Jhnum:sign:i Option:eq low:00000001 High: (Empty string "")

Jhtyp:sign:i option:bt low:1 high:2 in tables

5. Code

<span style= "Font-family:microsoft yahei;font-size:14px;" >//c# code to create the SAP Connection object class Sapconnectionpublic class Sapconnection:idestinationconfiguration {public RFCCONFIGP            Arameters getparameters (String destinationname) {rfcconfigparameters conf = new Rfcconfigparameters (); if (Destinationname = = "NSP")//to the object connected to SAP name {conf.                Add (rfcconfigparameters.appserverhost, "SAP Server IP Address"); Conf.                ADD (Rfcconfigparameters.systemnumber, "SAP instance number 00"); Conf.                ADD (Rfcconfigparameters.systemid, ""); Conf.                ADD (Rfcconfigparameters.user, "Login to SAP account"); Conf.                ADD (Rfcconfigparameters.password, "password"); Conf.                ADD (rfcconfigparameters.client, "SAP's Client number"); Conf.            ADD (Rfcconfigparameters.language, "en or en");        } return conf;        } public bool Changeeventssupported () {return true; } public Event RFcdestinationmanager.configurationchangehandler configurationchanged; }//a custom call to the RfC class public class NCOQUERYRFC {//Create an instance of the SAP Connection object class Sapconnection Global_dest, singleton mode private St                Atic rfcdestination global_dest; public static Rfcdestination Sapconninfo () {if (global_dest = = null) {Sapcon Nection con = new sapconnection ();//sapconnection class definition see code at the end Rfcdestinationmanager.registerdestinationconfigura            tion (con);            } global_dest = Rfcdestinationmanager.getdestination ("NSP");        return global_dest; }//Query RfC method public static string Getheadersfromsap () {rfcdestination dest = Ncoqu            Eryrfc.sapconninfo (); Rfcrepository Rfcrep = dest.            Repository; Irfcfunction myfun = Rfcrep. Createfunction ("zcp3_mmif002zbzz125"); The name of the RFC//incoming structure input irfcstructure input = myfun.            Getstructure ("INPUT"); InpUt.            SetValue ("Bukrs", "K999"); Input.            SetValue ("Werks", "X666"); Myfun.             SetValue ("input", input); The jhnum irfctable table = Myfun in the incoming tables tables.            GetTable ("Jhnum"); the table irfcstructure import = null for the jhnum to be passed in//RFC; var Structmeta = Rfcrep.            Getstructuremetadata ("Zcp3mmif002zbzz125_s05");//Is the structure of the Jhnum table reference in SAP import = Structmeta.createstructure (); Import.            SetValue ("sign", "I"); Import.            SetValue ("OPTION", "EQ"); Import.            SetValue ("Low", "00000001"); Import.            SetValue ("High", ""); Table.            Insert (import); Jhtyp irfctable table2 = myfun in the incoming tables table.            GetTable ("Jhtyp");            Irfcstructure import2 = null; var Structmeta = Rfcrep.            Getstructuremetadata ("Zcp3mmif002zbzz125_s05");            Import2 = Structmeta.createstructure (); Import2.            SetValue ("sign", "I"); Import2.            SetValue ("OPTION", "BT"); ImporT2.            SetValue ("Low", "1"); Import2.            SetValue ("High", "2"); Table2.                       Insert (IMPORT2); Myfun. Invoke (dest);//Call irfctable headtable = myfun.            GetTable ("header");//RFC return header structure Collection DataTable DT2 = new DataTable (); String[] Rfcheaderkeys = {"Jhnum", "Bukrs", "Butxt", "Werks", "NAME1", "Jhtyp"};//the column name in the DataTable to be returned foreach (str ing key in Rfcheaderkeys) {DT2.            Columns.Add (key);                }//loop puts the data inside the irfctable into the table for (int i = 0; i < (headtable.count); i++) {                Headtable.currentindex = i; for (int j = 0; j < dt. Rows.Count; J + +) {DataRow Dr = Dt2.                    NewRow ();                    foreach (string key in Rfcheaderkeys) {Dr[key] = headtable.getstring (key); } DT2.                Rows.Add (DR); }            }            return DT2; }}<span style= "White-space:normal;" ></span></span>

. NET using NCO to connect SAP from RFC query data code configuration connect SAP information