Skip to content

Web Applications

The following section shows the development process for an ASP.NET/ERPConnect project.

Prerequisites

  • Add the ERPConnect.dll class library as a reference to the project (the .dll is copied to the bin directory when compiling the project).
  • Add the librfc32.dll to your bin directory, see Requirements - 32/64-Bit Environment.

Warning

The standard demo license does not support working in web environments.
To test ERPConnect with your ASP.NET project, apply for a test license number at sales@theobald-software.com.

ASP.NET

The following sample shows how to create a purchase order using the BAPI_PO_CREATE. The sample uses an ASP page to enter data for a purchase order, see screenshot below.
purchase-order1

Input: 

Vendor: 0000001070
Material: B-7000
Plant: 1000
Quantity: 10

Call BAPI_PO_CREATE

To create a purchase order using the BAPI_PO_CREATE BAPI, follow the steps below:

  1. Establish a connection to the SAP system
  2. Create an RFC-Function object for the BAPI BAPI_PO_CREATE.
  3. Fill the structure PO_HEADER with the following values:
  4. DOC_TYPE -> Order type (NB normal order)
  5. PURCH_ORG -> Purchasing organization
  6. PUR_GROUP -> Purchasing group
  7. DOC_DATE -> Date
  8. VENDOR -> Vendor number
  9. Define the items PLANT and PUR_MAT (material number) in the table PO_ITEMS.
  10. The values for the quantity (QUANTITY) and the delivery date (DELIV_DATE) must be placed in the table PO_ITEM_SHEDULES.
  11. Execute the BAPI and process the return messages.
BAPI_PO_CREATE & Table PO_ITEMS
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
private void Button1_Click(object sender, System.EventArgs e)
{
   // Set your ERPConnect license
    LIC.SetLic("xxxx");

    using var connection = new R3Connection(
        host: "server.acme.org",
        systemNumber: 00,
        userName: "user",
        password: "passwd",
        language: "EN",
        client: "001")
    {
        Protocol = ClientProtocol.NWRFC,
    };

    connection.Open();

   // Create a RFC-Function object
   RFCFunction func = connection.CreateFunction("BAPI_PO_CREATE");

   // Fill header structure
   RFCStructure Header = func.Exports["PO_HEADER"].ToStructure();
   Header["DOC_TYPE"]= "NB";
   Header["PURCH_ORG"] = "1000";
   Header["PUR_GROUP"] = "010";
   Header["DOC_DATE"]= ERPConnect.ConversionUtils.NetDate2SAPDate(DateTime.Now);
   Header["VENDOR"]= this.txtVendor.Text

   // Create an Item
   RFCTable items = func.Tables["PO_ITEMS"];
   RFCStructure item = items.AddRow();
   item["PO_ITEM"] = "1";
   item["PUR_MAT"] = this.txtMaterial.Text;
   item["PLANT"] = this.txtPlant.Text;

   // Create and fill shedules
   RFCTable shedules = func.Tables["PO_ITEM_SCHEDULES"];
   RFCStructure shedule = shedules.AddRow();
   shedule["PO_ITEM"] = "1";
   shedule["DELIV_DATE"] = ERPConnect.ConversionUtils.NetDate2SAPDate(DateTime.Now);
   shedule["QUANTITY"] = Convert.ToDecimal(this.txtQuan.Text);

   // Exceute BAPI and process return messages
   func.Execute();
   this.txtReturn.Text = "";
   this.txtReturn.Text += func.Tables["RETURN"].Rows[0, "MESSAGE"] + "\r\n";
}

Output:

Message: Standard PO created under the number 4500018292

purchase-order2