Export (0) Print
Expand All

Invoking RFCs and BAPIs by Using the EXEC Command

The .NET Framework Data Provider for mySAP Business Suite exposes the SAP system as an ADO.NET data source. By using .NET Framework Data Provider for mySAP Business Suite, you can invoke RFCs and BAPIs on the SAP system through an EXEC command.

To invoke an RFC or BAPI using the Data Provider for SAP, perform the following steps:

To invoke an RFC or BAPI
  1. Include a reference (and a using statement in your code) to Microsoft.Data.SAPClient.

  2. Create a SAPConnection object by using a Data Provider for SAP connection string. For more information about the connection string, see The Data Provider for the SAP Connection String.

  3. Open a connection to the SAP system by invoking Open on the SAPConnection.

  4. Create a SAPCommand object from the SAPConnection.

  5. Specify the BAPI or RFC call in the CommandText property of the SAPCommand. If necessary, you can specify parameters using SAPParameter objects. For more information about how to specify a BAPI or RFC call using an EXEC statement, see Syntax for an EXEC Statement. For examples of how to specify a BAPI or RFC, see Examples for EXEC Statement.

  6. Execute the command to invoke the RFC or BAPI and obtain the results in a SAPDataReader.

  7. Read the results from the SAPDataReader.

  8. When you are finished using them, close (or dispose) the SAPConnection and the SAPDataReader.

The Data Provider for SAP also exposes a SAPClientFactory class, which you can use to create SAPConnection, SAPCommand and SAPConnection objects. For more information about the ADO.NET classes extended by the Data Provider for SAP, see Extending ADO.NET Interfaces.

The following example invokes SD_RFC_CUSTOMER_GET to retrieve customer information for all customers whose names start with "AB". It then writes the customer records to the console.

using System;
using System.Collections.Generic;
using System.Text;

using Microsoft.Data.SAPClient;

namespace SapAdoExec
{
    class Program
    {
        static void Main(string[] args)
        {
            string connstr = "TYPE=A; ASHOST=YourSAPHost; SYSNR=00; CLIENT=800; LANG=EN; USER=YourUserName; PASSWD=YourPassword;";

            using (SAPConnection conn = new SAPConnection(connstr))
            {
                conn.Open();

                using (SAPCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "exec sd_rfc_customer_get @name1='AB*' ";
                    using (SAPDataReader dr = cmd.ExecuteReader())
                    {
                        do
                        {
                            int rows = 0;
                            while (dr.Read())
                            {
                                rows++;
                                StringBuilder b = new StringBuilder();
                                for (int i = 0; i < dr.FieldCount; i++)
                                {
                                    b.Append(dr[i].ToString() + " ");
                                }
                                Console.WriteLine("row {0}: {1} ", rows, b.ToString());
                            }
                            Console.WriteLine("Number of rows:{0}", rows);
                        } while (dr.NextResult());
                       
                    }
                }
            }

        }
    }
}
Show:
© 2014 Microsoft